Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25361 | 25361 | 229873 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3571 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004534.157880001 | 2103646.15858 | 37.75646816057971 | -122.427306727641 | (37.7564681605797, -122.427306727641) | |||
28599 | 28599 | 226426 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3323 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006880.3188 | 2102604.06002 | 37.753739204713895 | -122.419118940914 | (37.7537392047139, -122.419118940914) | |||
30189 | 30189 | 229788 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1799 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005571.35245 | 2107231.70655 | 37.7663718340174 | -122.423974702579 | (37.7663718340174, -122.423974702579) | |||
31787 | 31787 | 121581 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 3x3 | 6013754.46885 | 2106222.8302700003 | 37.764060277784 | -122.395599922908 | (37.764060277784, -122.395599922908) | ||
34263 | 34263 | 226464 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2670 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008878.67119 | 2102975.76915 | 37.7548721679187 | -122.412234430081 | (37.7548721679187, -122.412234430081) | |||
36855 | 36855 | 226463 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2680 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008883.3825199995 | 2102935.43228 | 37.754761676334205 | -122.412215286208 | (37.7547616763342, -122.412215286208) | |||
38730 | 38730 | 226338 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 41 Bartlett St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006684.19647 | 2103512.2186 | 37.7562217526516 | -122.41986161543001 | (37.7562217526516, -122.41986161543) | |||
38848 | 38848 | 229842 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3731 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005435.33161 | 2104281.1313099996 | 37.758262571580794 | -122.424235305437 | (37.7582625715808, -122.424235305437) | |||
40742 | 40742 | 226305 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 84 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006137.34667 | 2097561.4602200002 | 37.7398515040311 | -122.42133024340599 | (37.7398515040311, -122.421330243406) | |||
42743 | 42743 | 108444 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 2 | 3x2.5 | 6014877.0 | 2117007.0 | 37.793733556134896 | -122.39247175850299 | (37.7937335561349, -122.392471758503) | |
48658 | 48658 | 226335 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 19 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006677.49566 | 2103645.89142 | 37.756588409851496 | -122.419894274305 | (37.7565884098515, -122.419894274305) | |||
48894 | 48894 | 226782 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 579 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6003036.36439 | 2104869.3742 | 37.7597419968272 | -122.43257399299999 | (37.7597419968272, -122.432573993) | |||
53368 | 53368 | 78724 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1300 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53574 | 6011950.73154 | 2102276.22736 | 37.7531232815236 | -122.40156116092699 | (37.7531232815236, -122.401561160927) | |
53861 | 53861 | 176586 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 205 Seneca Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 5999824.12192 | 2090353.8387799999 | 37.7197030929005 | -122.44264127649099 | (37.7197030929005, -122.442641276491) | |||
58267 | 58267 | 226467 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 11 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005807.5274 | 2099625.67838 | 37.7455007798334 | -122.42261726946998 | (37.7455007798334, -122.42261726947) | |||
58379 | 58379 | 229740 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 60 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005206.89439 | 2105762.97862 | 37.762318473540795 | -122.425130780182 | (37.7623184735408, -122.425130780182) | |||
61111 | 61111 | 226339 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 41 Bartlett St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006685.94494 | 2103496.44851 | 37.7561785501259 | -122.41985444962201 | (37.7561785501259, -122.419854449622) | |||
63374 | 63374 | 226817 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4430 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999749.40261 | 2105767.64242 | 37.762021469725795 | -122.444006474335 | (37.7620214697258, -122.444006474335) | |||
72874 | 72874 | 226805 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 73 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002033.709009999 | 2105453.8141799998 | 37.7612898163989 | -122.43608349926501 | (37.7612898163989, -122.436083499265) | |||
74219 | 74219 | 226309 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 161 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007378.4424 | 2096771.82308 | 37.737753229234 | -122.41698311040301 | (37.737753229234, -122.416983110403) | |||
75004 | 75004 | 229795 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 277 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004958.17286 | 2108195.3416 | 37.7689831073039 | -122.426164188445 | (37.7689831073039, -122.426164188445) | |||
92205 | 92205 | 105745 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 418 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 2 | 4x4 | Permit Number 771651 | 6002705.0 | 2109971.0 | 37.7737310181147 | -122.43408471033301 | (37.7737310181147, -122.434084710333) | |
98500 | 98500 | 67792 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4252 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52966 | 6002229.57555078 | 2101227.41307609 | 37.7496962578989 | -122.435103788069 | (37.7496962578989, -122.435103788069) | |
115952 | 115952 | 229863 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1511 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010172.47865 | 2100425.75688 | 37.74794291223429 | -122.40758028200001 | (37.7479429122343, -122.407580282) | |||
118175 | 118175 | 226318 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1453 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6009324.958769999 | 2100785.02024 | 37.748881892593296 | -122.410536346369 | (37.7488818925933, -122.410536346369) | |||
130489 | 130489 | 229763 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 6011453.21392 | 2102329.36922 | 37.753241423671795 | -122.403285422977 | (37.7532414236718, -122.403285422977) | |||
132415 | 132415 | 226334 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006673.9132199995 | 2103705.36513 | 37.756751509094 | -122.419910883878 | (37.756751509094, -122.419910883878) | |||
135455 | 135455 | 226308 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 161 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007401.10475 | 2096768.5296099999 | 37.7377454608683 | -122.416904522239 | (37.7377454608683, -122.416904522239) | |||
137381 | 137381 | 43189 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 175 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 2 | Permit Number 42991 | 6009687.65103 | 2094852.37094 | 37.7326124525905 | -122.40886364246401 | (37.7326124525905, -122.408863642464) | |
138072 | 138072 | 229807 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2560 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009717.31333 | 2102417.08102 | 37.753385157817604 | -122.409294735183 | (37.7533851578176, -122.409294735183) | |||
138131 | 138131 | 201517 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 911 Innes Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6019123.25931 | 2094488.31096 | 37.7321368236424 | -122.37621683574699 | (37.7321368236424, -122.376216835747) | |||
152017 | 152017 | 176588 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 151 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004383.65032 | 2094057.6355400002 | 37.73013176266 | -122.42714428398399 | (37.73013176266, -122.427144283984) | |||
152576 | 152576 | 229841 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3772 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6005193.66428 | 2104309.8133400003 | 37.758327677085205 | -122.425073138141 | (37.7583276770852, -122.425073138141) | |||
152773 | 152773 | 226340 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 41 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006685.59051 | 2103479.17398 | 37.7561310982853 | -122.419854449627 | (37.7561310982853, -122.419854449627) | |||
152926 | 152926 | 190743 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 39 Latona St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 6ft | 6014419.07803 | 2094437.81167 | 37.731738047151296 | -122.392476830144 | (37.7317380471513, -122.392476830144) | |||
153170 | 153170 | 228548 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1325 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6009560.01396 | 2101278.1954 | 37.7502492173426 | -122.409758328497 | (37.7502492173426, -122.409758328497) | |||
153521 | 153521 | 219234 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 273 Dalewood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995327.0897 | 2097229.7554099998 | 37.7383253194549 | -122.458683321089 | (37.7383253194549, -122.458683321089) | |||
154552 | 154552 | 229742 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 749 Dolores St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6005048.07948 | 2104060.60475 | 37.7576351838315 | -122.425558898838 | (37.7576351838315, -122.425558898838) | |||
156830 | 156830 | 248273 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 155 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6006714.66464 | 2098690.1987099997 | 37.7429832995482 | -122.419414171229 | (37.7429832995482, -122.419414171229) | |||
160223 | 160223 | 40004 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 911 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 2 | Permit Number 41258 | 6019111.21169 | 2094496.3329 | 37.7321581870346 | -122.376259043617 | (37.7321581870346, -122.376259043617) | |
161138 | 161138 | 190749 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 111 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6008907.60615 | 2111116.85343 | 37.7772273283225 | -122.41270986656201 | (37.7772273283225, -122.412709866562) | |||
163533 | 163533 | 226374 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4120 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001383.53668 | 2102929.36368 | 37.754321328688505 | -122.438151321247 | (37.7543213286885, -122.438151321247) | |||
167292 | 167292 | 54450 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 435 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51720 | 6011224.5432 | 2106327.02843 | 37.7642053321404 | -122.40435757586 | (37.7642053321404, -122.40435757586) | |
172269 | 172269 | 57319 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2719 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 2 | Permit Number 16144 | 5999557.8231 | 2113954.6853 | 37.784490078245604 | -122.44525772561501 | (37.7844900782456, -122.445257725615) | ||
173236 | 173236 | 226336 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 25 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006679.39058 | 2103618.84473 | 37.7565142526416 | -122.41988580180201 | (37.7565142526416, -122.419885801802) | |||
178416 | 178416 | 129103 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1306x Montgomery St | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011435.37643 | 2120050.37627 | 37.8018982087863 | -122.40459448426901 | (37.8018982087863, -122.404594484269) | |||
178840 | 178840 | 226774 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4069 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003404.88062 | 2101242.91418 | 37.749805488230706 | -122.431040646222 | (37.7498054882307, -122.431040646222) | |||
179526 | 179526 | 190700 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 199 Texas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013754.83495 | 2106240.90179 | 37.764109918566206 | -122.395599922892 | (37.7641099185662, -122.395599922892) | |||
186242 | 186242 | 200047 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1582 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015033.0267 | 2094124.7502 | 37.730912518823295 | -122.39033240224899 | (37.7309125188233, -122.390332402249) | |||
186575 | 186575 | 226337 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 41 Bartlett St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006682.98669 | 2103529.00936 | 37.756267788048795 | -122.41986699069099 | (37.7562677880488, -122.419866990691) |
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");