Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25099 | 25099 | 224199 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005272.32245 | 2097108.7115200001 | 37.738559550591795 | -122.42428894459299 | (37.7385595505918, -122.424288944593) | ||||
31769 | 31769 | 224212 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005187.142969999 | 2097371.8747799997 | 37.739277327390795 | -122.42460216947501 | (37.7392773273908, -122.424602169475) | ||||
34116 | 34116 | 224214 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6005180.62218 | 2097351.71746 | 37.73922161167361 | -122.424623281961 | (37.7392216116736, -122.424623281961) | ||||
39821 | 39821 | 224196 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005192.428069999 | 2096936.6445 | 37.73808258165379 | -122.424552945066 | (37.7380825816538, -122.424552945066) | ||||
44361 | 44361 | 247091 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2301 Castro St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6002747.911280001 | 2098608.69961 | 37.7425353031757 | -122.43312428277099 | (37.7425353031757, -122.433124282771) | ||||
46601 | 46601 | 84938 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 49347 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | ||||
47306 | 47306 | 224452 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6003256.424219999 | 2095477.2065700002 | 37.7339657739995 | -122.43114253132099 | (37.7339657739995, -122.431142531321) | ||||
50324 | 50324 | 224208 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 66 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6005339.07699 | 2097371.10972 | 37.7392838060945 | -122.424076794516 | (37.7392838060945, -122.424076794516) | |||
57509 | 57509 | 224451 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 56 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6003260.74151 | 2095484.4937599998 | 37.73398602761579 | -122.431128125086 | (37.7339860276158, -122.431128125086) | ||||
62541 | 62541 | 224210 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6005362.146369999 | 2097481.1402 | 37.739587227456205 | -122.42400485326401 | (37.7395872274562, -122.424004853264) | ||||
62903 | 62903 | 224203 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003487.067319999 | 2095623.9761599998 | 37.734381837255505 | -122.430355595758 | (37.7343818372555, -122.430355595758) | ||||
63643 | 63643 | 224453 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 6003249.48151 | 2095473.62453 | 37.733955545103505 | -122.43116627879499 | (37.7339555451035, -122.431166278795) | ||||
69429 | 69429 | 224202 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6003508.627309999 | 2095617.8291 | 37.7343661800531 | -122.430280617458 | (37.7343661800531, -122.430280617458) | ||||
71049 | 71049 | 224216 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005148.6559 | 2097255.3705700003 | 37.73895525948029 | -122.424726954897 | (37.7389552594803, -122.424726954897) | ||||
72865 | 72865 | 224450 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6003275.39086 | 2095494.7434599998 | 37.7340150010873 | -122.431078209119 | (37.7340150010873, -122.431078209119) | ||||
85476 | 85476 | 112374 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1247 Bosworth St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20x20 | Permit Number 775819 | 6000424.1100699995 | 2096055.79143 | 37.735393525896704 | -122.44097617665199 | (37.7353935258967, -122.440976176652) | |||
91437 | 91437 | 224213 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6005183.176969999 | 2097360.09127 | 37.7392447485499 | -122.42461504414801 | (37.7392447485499, -122.424615044148) | ||||
107396 | 107396 | 112485 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
108486 | 108486 | 107550 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 198X Jennings St | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | |||||
109824 | 109824 | 112486 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | Permit Number 774532 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | |||
112521 | 112521 | 98951 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 401 Grove St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
117944 | 117944 | 104432 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1601X PORTOLA DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5991823.0 | 2096240.0 | 37.73540567927029 | -122.47072655808 | (37.7354056792703, -122.47072655808) | ||||
122611 | 122611 | 112487 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | |||||
122658 | 122658 | 112488 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | |||||
124450 | 124450 | 112484 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
124630 | 124630 | 107538 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 198X JENNINGS ST | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6018784.0 | 2097136.0 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | |||||
126530 | 126530 | 98952 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 302 Ivy St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | |||||
131250 | 131250 | 224198 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005259.16763 | 2097058.5140200001 | 37.7384209767501 | -122.424330858406 | (37.7384209767501, -122.424330858406) | ||||
133023 | 133023 | 224217 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 115 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6005000.71693 | 2096893.74168 | 37.7379539516063 | -122.42521273450001 | (37.7379539516063, -122.4252127345) | ||||
134007 | 134007 | 224207 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 8ft | 6005337.33065 | 2097353.93167 | 37.739236540443294 | -122.42408161128999 | (37.7392365404433, -122.42408161129) | |||
134903 | 134903 | 224201 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6003522.52197 | 2095626.54462 | 37.7343908979074 | -122.430233200698 | (37.7343908979074, -122.430233200698) | ||||
140881 | 140881 | 107539 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 198X JENNINGS ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6018784.0 | 2097136.0 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | |||||
143010 | 143010 | 112970 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1409 MCKINNON AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016184.0 | 2095282.0 | 37.734153872922896 | -122.386433919032 | (37.7341538729229, -122.386433919032) | |||||
151415 | 151415 | 224206 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 59 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6005333.6743 | 2097319.7623400004 | 37.739142512726396 | -122.424091823995 | (37.7391425127264, -122.424091823995) | ||||
158093 | 158093 | 224205 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005328.89296 | 2097313.9887099997 | 37.7391263896815 | -122.424107945232 | (37.7391263896815, -122.424107945232) | ||||
159148 | 159148 | 224215 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6005165.86979 | 2097298.42463 | 37.739074448424 | -122.424670499065 | (37.739074448424, -122.424670499065) | ||||
159855 | 159855 | 224200 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6003533.27125 | 2095632.5118900002 | 37.7344078915187 | -122.430196462512 | (37.7344078915187, -122.430196462512) | ||||
166378 | 166378 | 224204 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003450.74753 | 2095594.0107 | 37.734297501527294 | -122.430479027684 | (37.7342975015273, -122.430479027684) | ||||
166595 | 166595 | 224209 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6005356.45271 | 2097454.81484 | 37.7395146225008 | -122.424022667913 | (37.7395146225008, -122.424022667913) | ||||
175024 | 175024 | 224211 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6005190.349119999 | 2097382.93272 | 37.739307871065996 | -122.424591870417 | (37.739307871066, -122.424591870417) | ||||
182451 | 182451 | 247096 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2301 Castro St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6002729.450119999 | 2098626.9887200003 | 37.7425844735833 | -122.433189422459 | (37.7425844735833, -122.433189422459) | ||||
187524 | 187524 | 224449 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1201 San Jose Ave | 62 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004503.55801 | 2096138.79869 | 37.73585295005579 | -122.426877907491 | (37.7358529500558, -122.426877907491) | ||||
187763 | 187763 | 224197 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6005251.17489 | 2097047.32393 | 37.738389799949104 | -122.424357697761 | (37.7383897999491, -122.424357697761) |
JSON shape: default, array, newline-delimited
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)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");