home / sf-trees

Street_Tree_List

32 rows where search matches "palm" and PlantDate contains "1990" sorted by TreeID

View and edit SQL

This data as .json

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
146068 5446 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 500X Dolores St 14 Median : Cutout 11 Tree 1 DPW 2   03/20/1990 12:00:00 AM 90 6   6004896.4850004995 2105439.5076575 37.7614127588524 -122.426181340905 (37.7614127588524, -122.426181340905)
67659 32542 Permitted Site 1 Crateagus spp :: Hawthorn 160 91 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 6   Permit Number 37040 5995849.2868099995 2113912.80222 37.7841626930639 -122.458084878555 (37.7841626930639, -122.458084878555)
123947 53439 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 52 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 4   Permit Number 28945 5995912.02924 2114136.39379 37.784780220516794 -122.45788399909901 (37.7847802205168, -122.457883999099)
157185 59260 Permitted Site 1 Syagrus romanzoffianum :: Queen Palm 142 1400 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/13/1990 12:00:00 AM 8   Permit Number 28432 6006768.1927 2115720.7306 37.7897481413543 -122.42043766215099 (37.7897481413543, -122.420437662151)
61823 65584 Permitted Site 1 Cordyline australis :: Dracena Palm 141 251 Peru Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/24/1990 12:00:00 AM 1   Permit Number 28484 6004276.22204 2093135.2738 37.7275930871392 -122.427449994148 (37.7275930871392, -122.427449994148)
182671 65601 Permitted Site 1 Syagrus romanzoffianum :: Queen Palm 142 112 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/1990 12:00:00 AM 12   Permit Number 28503 6004142.9253 2093740.45732 37.7292472461511 -122.42795390857201 (37.7292472461511, -122.427953908572)
116426 65602 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 114 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/1990 12:00:00 AM 13   Permit Number 28504 6004165.03379 2093741.9135900002 37.729252495484 -122.427877581308 (37.729252495484, -122.427877581308)
182797 65606 Permitted Site 1 Cordyline australis :: Dracena Palm 141 142 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/1990 12:00:00 AM 47   Permit Number 28510 6004334.881680001 2093748.3562099999 37.729279792610505 -122.427290860879 (37.7292797926105, -122.427290860879)
37573 65688 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 184 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/31/1990 12:00:00 AM 8   Permit Number 28909 5995950.945309999 2113042.38118 37.7817785895398 -122.45767017670201 (37.7817785895398, -122.457670176702)
129681 65814 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 90 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/19/1990 12:00:00 AM 12   Permit Number 28802 5995920.72408 2113894.39262 37.784116249570296 -122.45783640007099 (37.7841162495703, -122.457836400071)
47966 65893 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 116 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/31/1990 12:00:00 AM 9   Permit Number 28900 5995931.63622 2113606.82428 37.7833272906212 -122.457777832601 (37.7833272906212, -122.457777832601)
133443 65895 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 126 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/31/1990 12:00:00 AM 6   Permit Number 28902 5995934.2793 2113524.40657 37.783101145423394 -122.457762722955 (37.7831011454234, -122.457762722955)
129940 65896 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 152 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/31/1990 12:00:00 AM 6   Permit Number 28903 5995943.06706 2113318.17907 37.7825354045306 -122.457717393964 (37.7825354045306, -122.457717393964)
146577 65897 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 156 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/31/1990 12:00:00 AM 6   Permit Number 28904 5995942.3619800005 2113297.5350200003 37.7824786809659 -122.457718338978 (37.7824786809659, -122.457718338978)
179367 65899 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 166 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/31/1990 12:00:00 AM 8   Permit Number 28906 5995945.57364 2113203.14409 37.782219693115394 -122.45770039603998 (37.7822196931154, -122.45770039604)
59630 65900 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 168 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/31/1990 12:00:00 AM 8   Permit Number 28907 5995947.205130001 2113189.79047 37.782183121353896 -122.457693785315 (37.7821831213539, -122.457693785315)
35039 65901 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 180 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/08/1990 12:00:00 AM 11   Permit Number 28908 5995949.76859 2113077.47191 37.7818748717492 -122.457676787407 (37.7818748717492, -122.457676787407)
126062 65924 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 86 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM     Permit Number 28940 5995916.1594989 2113912.59060771 37.784165954142 -122.457853509092 (37.784165954142, -122.457853509092)
40601 65925 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 80 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 11   Permit Number 28942 5995918.83699 2113960.3676 37.7842972908104 -122.45784770445 (37.7842972908104, -122.45784770445)
181402 65926 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 74 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 5   Permit Number 28944 5995917.2932400005 2113985.23252 37.784365474541 -122.457854845171 (37.784365474541, -122.457854845171)
53212 65927 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 47 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 18   Permit Number 28946 5995857.72267 2114184.09174 37.7849080661642 -122.45807533396002 (37.7849080661642, -122.45807533396)
167683 65928 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 41 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 4   Permit Number 28947 5995850.771380001 2114206.39787 37.7849689134171 -122.45810099794 (37.7849689134171, -122.45810099794)
28719 65929 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 35 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 8   Permit Number 28948 5995849.4697199995 2114245.46982 37.7850761197315 -122.45810832997 (37.7850761197315, -122.45810832997)
60857 65931 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 115 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 7   Permit Number 28950 5995872.00692 2113664.41853 37.7834820032566 -122.45798829440201 (37.7834820032566, -122.457988294402)
156275 65934 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 150 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/31/1990 12:00:00 AM 7   Permit Number 28953 5995941.68563 2113369.58328 37.782676467432 -122.45772589379801 (37.782676467432, -122.457725893798)
3787 65935 Permitted Site 1 Cordyline australis :: Dracena Palm 141 1343 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/1990 12:00:00 AM 14   Permit Number 28954 6006463.24964 2119706.38252 37.800674552539604 -122.421775955514 (37.8006745525396, -122.421775955514)
101992 66205 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 285 Mullen Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/03/1990 12:00:00 AM     Permit Number 29289 6010420.85602386 2100006.0506029 37.746804390663 -122.406691826217 (37.746804390663, -122.406691826217)
183148 66354 Permitted Site 1 Syagrus romanzoffianum :: Queen Palm 142 334 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/1990 12:00:00 AM 13   Permit Number 29475 6003787.88189 2089236.55246 37.7168604267574 -122.428860361341 (37.7168604267574, -122.428860361341)
188342 70057 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1799 Revere Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/18/1990 12:00:00 AM 12     6014037.2583099995 2095146.8497099997 37.7336637097057 -122.393846481427 (37.7336637097057, -122.393846481427)
45437 71814 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 68 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/19/1990 12:00:00 AM 18     5995915.832219999 2114038.69637 37.7845121880339 -122.45786376992201 (37.7845121880339, -122.457863769922)
110657 71815 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 151X Palm Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/19/1990 12:00:00 AM 10 3x3   5995888.68435 2113315.23973 37.782524209628704 -122.45790532062 (37.7825242096287, -122.45790532062)
73423 72214 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1799 Revere Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/18/1990 12:00:00 AM 12     6014033.56934 2095149.8862 37.7336718422767 -122.39385944784901 (37.7336718422767, -122.393859447849)
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id))
Powered by Datasette · Query took 46.902ms