Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4849 | 4849 | 253684 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 767 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009074.0 | 2092682.0 | 37.7266186845557 | -122.410831962563 | (37.7266186845557, -122.410831962563) | ||||
| 2817 | 2817 | 253222 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 148 Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6010428.10303 | 2093767.62468 | 37.729675416078294 | -122.406227307752 | (37.7296754160783, -122.406227307752) | ||||
| 2839 | 2839 | 253221 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 148 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6010428.10303 | 2093767.62468 | 37.729675416078294 | -122.406227307752 | (37.7296754160783, -122.406227307752) | ||||
| 4291 | 4291 | 252895 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 790x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:29:00 PM | 3 | 3x3 | 5997282.0 | 2090432.0 | 37.719772464034904 | -122.45143407539 | (37.7197724640349, -122.45143407539) | ||
| 4203 | 4203 | 252894 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:10:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4246 | 4246 | 252893 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:25:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4213 | 4213 | 252892 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:08:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4201 | 4201 | 252891 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:13:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 1380 | 1380 | 251512 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4116x 18th St | 1 | Back Yard : Yard 13 | Tree 1 | MTA 6 | 3x3 | 6002190.0 | 2105341.0 | 37.760988934022706 | -122.43553488468001 | (37.7609889340227, -122.43553488468) | ||||
| 410 | 410 | 251287 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/09/1998 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 358 | 358 | 251286 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/09/1998 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 375 | 375 | 251284 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/21/1996 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 402 | 402 | 251283 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/06/1997 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 385 | 385 | 251282 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/07/2016 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 398 | 398 | 251281 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275x Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/23/2006 12:00:00 AM | 3x3 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 392 | 392 | 251280 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 73619 | 73619 | 248397 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 710 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997610.5725 | 2108098.1732 | 37.7682982739336 | -122.451571931383 | (37.7682982739336, -122.451571931383) | |||
| 131404 | 131404 | 247045 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6002079.02681 | 2099155.53035 | 37.7439988068049 | -122.435476194275 | (37.7439988068049, -122.435476194275) | |||
| 61563 | 61563 | 247044 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002079.830030001 | 2099170.11996 | 37.74403891207071 | -122.43547446040199 | (37.7440389120707, -122.435474460402) | |||
| 153413 | 153413 | 247043 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6002094.89222 | 2099164.93967 | 37.744025543647105 | -122.435422008318 | (37.7440255436471, -122.435422008318) | ||||
| 37729 | 37729 | 247042 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6002114.968169999 | 2099165.77298 | 37.7440289718731 | -122.43535264990601 | (37.7440289718731, -122.435352649906) | ||||
| 50641 | 50641 | 246815 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 182 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6010185.45324 | 2098877.40442 | 37.74369220094071 | -122.407426274006 | (37.7436922009407, -122.407426274006) | |||
| 67823 | 67823 | 246058 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 610 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997562.1198 | 2108443.0956 | 37.769242567665295 | -122.451764409004 | (37.7692425676653, -122.451764409004) | |||
| 2997 | 2997 | 246011 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 609 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1988 12:00:00 AM | 8 | Width 0ft | Permit Number 25501 | 5998952.4081 | 2108635.9977 | 37.7698517546883 | -122.446969376408 | (37.7698517546883, -122.446969376408) | |
| 33995 | 33995 | 244917 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1350 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999690.9856 | 2108819.5575 | 37.7703979319451 | -122.444427856782 | (37.7703979319451, -122.444427856782) | |||
| 51195 | 51195 | 244276 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 480 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004294.0037 | 2109808.1625 | 37.7733739594079 | -122.428576486808 | (37.7733739594079, -122.428576486808) | |||
| 58130 | 58130 | 244275 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 476 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004317.6301 | 2109811.608 | 37.77338475694221 | -122.42849500540001 | (37.7733847569422, -122.4284950054) | |||
| 36933 | 36933 | 244274 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 470 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004329.9355 | 2109813.5769 | 37.7733908594087 | -122.42845257964501 | (37.7733908594087, -122.428452579645) | |||
| 57253 | 57253 | 244273 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 466 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004356.0229 | 2109819.4835 | 37.7734085536944 | -122.428362760697 | (37.7734085536944, -122.428362760697) | |||
| 157247 | 157247 | 244272 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 460 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004370.7894 | 2109821.4524 | 37.77341479537271 | -122.428311821621 | (37.7734147953727, -122.428311821621) | |||
| 33110 | 33110 | 244217 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 516 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998006.3233 | 2108756.3922 | 37.770128230531895 | -122.450250525647 | (37.7701282305319, -122.450250525647) | |||
| 70818 | 70818 | 244038 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 555 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998455.5537 | 2108692.7156 | 37.769979089028 | -122.44869206228 | (37.769979089028, -122.44869206228) | |||
| 130971 | 130971 | 244035 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 516 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998007.9741 | 2108736.9943 | 37.770075063332705 | -122.450243417124 | (37.7700750633327, -122.450243417124) | |||
| 139274 | 139274 | 222597 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 62 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002444.78145 | 2096589.2048099998 | 37.7369730385666 | -122.434028087935 | (37.7369730385666, -122.434028087935) | |||
| 67719 | 67719 | 222596 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 73 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6002296.29369 | 2096683.33913 | 37.73722308157 | -122.43454820456002 | (37.73722308157, -122.43454820456) | |||
| 147315 | 147315 | 222595 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6002381.71285 | 2096266.74074 | 37.736084047029 | -122.434223097845 | (37.736084047029, -122.434223097845) | |||
| 154690 | 154690 | 222594 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1701 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003405.54742 | 2098267.585 | 37.7416359640346 | -122.430826033811 | (37.7416359640346, -122.430826033811) | |||
| 184845 | 184845 | 222593 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 375 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003504.52441 | 2108607.38133 | 37.7700321988694 | -122.43122167795299 | (37.7700321988694, -122.431221677953) | |||
| 29109 | 29109 | 222592 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 352 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003592.38415 | 2108668.4276900003 | 37.7702047958459 | -122.43092212997699 | (37.7702047958459, -122.430922129977) | |||
| 147272 | 147272 | 222591 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 310 Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003760.57016 | 2108690.93214 | 37.770276115676396 | -122.430341981792 | (37.7702761156764, -122.430341981792) | |||
| 168991 | 168991 | 222590 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4486 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999473.95393 | 2105750.34682 | 37.7619582635881 | -122.444957897684 | (37.7619582635881, -122.444957897684) | |||
| 24046 | 24046 | 222589 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4384 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000100.50643 | 2105785.88471 | 37.762091580878604 | -122.44279345615601 | (37.7620915808786, -122.442793456156) | |||
| 49781 | 49781 | 222588 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4380 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000121.81513 | 2105788.1369 | 37.762098979601 | -122.44271991951 | (37.762098979601, -122.44271991951) | |||
| 73488 | 73488 | 222587 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2022 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004007.1473900005 | 2107186.69928 | 37.7661598206327 | -122.429381787342 | (37.7661598206327, -122.429381787342) | |||
| 151156 | 151156 | 222586 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 219 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001763.88203 | 2104576.51068 | 37.758865620975705 | -122.43695390631599 | (37.7588656209757, -122.436953906316) | |||
| 151270 | 151270 | 222585 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 219 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001765.705709999 | 2104562.10445 | 37.758826168613204 | -122.436946567843 | (37.7588261686132, -122.436946567843) | |||
| 184403 | 184403 | 222584 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 374 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001130.451330001 | 2104105.9564799997 | 37.7575375705211 | -122.439110874466 | (37.7575375705211, -122.439110874466) | |||
| 53435 | 53435 | 222583 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 193 Diamond St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001753.50389 | 2104887.2031 | 37.7597181171131 | -122.43701204208 | (37.7597181171131, -122.43701204208) | |||
| 61407 | 61407 | 222582 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 193 Diamond St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001750.8913900005 | 2104845.17495 | 37.759602569523395 | -122.437018068443 | (37.7596025695234, -122.437018068443) | |||
| 64374 | 64374 | 222581 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 193 Diamond St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6001755.3451 | 2104807.77266 | 37.7595001250595 | -122.436999987566 | (37.7595001250595, -122.436999987566) | |||
| 150994 | 150994 | 222580 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 187 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002705.73544 | 2104848.45932 | 37.7596658143394 | -122.433715979125 | (37.7596658143394, -122.433715979125) | |||
| 70747 | 70747 | 222579 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Hartford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002709.09948 | 2104829.71069 | 37.7596145259996 | -122.43370300460501 | (37.7596145259996, -122.433703004605) | |||
| 174688 | 174688 | 222578 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002709.15868 | 2104802.31344 | 37.759539303105505 | -122.433700841745 | (37.7595393031055, -122.433700841745) | |||
| 61670 | 61670 | 222577 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4016 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002861.59805 | 2105354.01605 | 37.7610627942241 | -122.433213052158 | (37.7610627942241, -122.433213052158) | |||
| 28362 | 28362 | 222576 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 471 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003000.71138 | 2105505.41806 | 37.7614863982993 | -122.432742735495 | (37.7614863982993, -122.432742735495) | |||
| 180920 | 180920 | 222575 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 384 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003870.03255 | 2102162.8697200003 | 37.752357817273605 | -122.429497729752 | (37.7523578172736, -122.429497729752) | |||
| 31017 | 31017 | 222574 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 382 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003928.91308 | 2102165.887 | 37.752369435600706 | -122.429294326484 | (37.7523694356007, -122.429294326484) | |||
| 38265 | 38265 | 222573 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3917 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003673.95782 | 2101843.15091 | 37.7514688410299 | -122.43015298120301 | (37.7514688410299, -122.430152981203) | |||
| 53675 | 53675 | 222572 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 524 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002965.6945400005 | 2102138.50273 | 37.7522396670301 | -122.432623334298 | (37.7522396670301, -122.432623334298) | |||
| 50847 | 50847 | 222571 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 593 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001358.40825 | 2101420.45569 | 37.7501768003212 | -122.43813013861099 | (37.7501768003212, -122.438130138611) | |||
| 34992 | 34992 | 222570 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4308 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001844.3062 | 2101201.08908 | 37.7496020939667 | -122.43643417821698 | (37.7496020939667, -122.436434178217) | |||
| 76796 | 76796 | 222569 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4366 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001499.852999999 | 2101184.60004 | 37.749537240249296 | -122.43762412605601 | (37.7495372402493, -122.437624126056) | |||
| 52936 | 52936 | 222568 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 34 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004529.9479 | 2095570.0555900002 | 37.734292801673796 | -122.426746177496 | (37.7342928016738, -122.426746177496) | |||
| 65637 | 65637 | 222567 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 115 College Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004467.78746 | 2096013.76695 | 37.735507618486096 | -122.42699267809601 | (37.7355076184861, -122.426992678096) | |||
| 148647 | 148647 | 222566 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 115 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004480.72884 | 2096010.51075 | 37.73549940946629 | -122.426947702995 | (37.7354994094663, -122.426947702995) | |||
| 51832 | 51832 | 222565 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Precita Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007123.52166 | 2100080.2988 | 37.7468232221335 | -122.418098981082 | (37.7468232221335, -122.418098981082) | |||
| 177802 | 177802 | 222564 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 160 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007476.41433 | 2100201.5835700002 | 37.747176098992796 | -122.41688730020701 | (37.7471760989928, -122.416887300207) | |||
| 52591 | 52591 | 222563 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007620.90266 | 2100266.50742 | 37.747362491591296 | -122.41639226749201 | (37.7473624915913, -122.416392267492) | |||
| 27371 | 27371 | 222562 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 190 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007642.65731 | 2100277.00661 | 37.747392543349704 | -122.416317784757 | (37.7473925433497, -122.416317784757) | |||
| 61402 | 61402 | 222561 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008138.86201 | 2096500.51335 | 37.7370510178737 | -122.414334773354 | (37.7370510178737, -122.414334773354) | |||
| 59363 | 59363 | 222560 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1409 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008015.99739 | 2099911.75152 | 37.7464106212529 | -122.415000947938 | (37.7464106212529, -122.415000947938) | |||
| 175136 | 175136 | 222559 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 30 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007511.95053 | 2099199.57172 | 37.7444267977493 | -122.416693445056 | (37.7444267977493, -122.416693445056) | |||
| 165661 | 165661 | 222558 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 28 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007156.30356 | 2099319.0348400003 | 37.744734807464106 | -122.417931668505 | (37.7447348074641, -122.417931668505) | |||
| 150617 | 150617 | 222557 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 28 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007168.7758 | 2099329.58865 | 37.744764487786796 | -122.417889289774 | (37.7447644877868, -122.417889289774) | |||
| 134983 | 134983 | 222556 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 54 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007284.70429 | 2099159.83714 | 37.7443049117519 | -122.41747640203 | (37.7443049117519, -122.41747640203) | |||
| 44455 | 44455 | 222555 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 121 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006651.1877 | 2098952.76416 | 37.743700669854796 | -122.419652282953 | (37.7437006698548, -122.419652282953) | |||
| 147256 | 147256 | 222554 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 166 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007158.63327 | 2098165.90408 | 37.7415686992375 | -122.417841889206 | (37.7415686992375, -122.417841889206) | |||
| 40334 | 40334 | 222553 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007213.79342 | 2097921.72013 | 37.740901328538996 | -122.417633860722 | (37.740901328539, -122.417633860722) | |||
| 32947 | 32947 | 222552 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 188 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007202.63127 | 2097897.94559 | 37.740835420825206 | -122.417670770702 | (37.7408354208252, -122.417670770702) | |||
| 73593 | 73593 | 222551 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 192 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007190.09246 | 2097874.19927 | 37.740769513115794 | -122.4177124426 | (37.7407695131158, -122.4177124426) | |||
| 149875 | 149875 | 222550 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 225 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007079.56626 | 2097589.10899 | 37.7399804982916 | -122.41807439541701 | (37.7399804982916, -122.418074395417) | |||
| 55473 | 55473 | 222549 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 199 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007198.14969 | 2097813.68298 | 37.740603802237295 | -122.417680295405 | (37.7406038022373, -122.417680295405) | |||
| 29365 | 29365 | 222548 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 191 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007220.93745 | 2097850.24968 | 37.740705488567706 | -122.417604094958 | (37.7407054885677, -122.417604094958) | |||
| 173961 | 173961 | 222547 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 615 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007991.011030001 | 2096013.8629400001 | 37.7357064756744 | -122.414811530923 | (37.7357064756744, -122.414811530923) | |||
| 151938 | 151938 | 222546 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2825 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002452.45425 | 2095510.12485 | 37.734010568315 | -122.433924450977 | (37.734010568315, -122.433924450977) | |||
| 166000 | 166000 | 222545 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2825 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002444.04339 | 2095477.8643900002 | 37.733921511167296 | -122.43395122468 | (37.7339215111673, -122.43395122468) | |||
| 69764 | 69764 | 222544 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2885 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002432.22505 | 2095435.0142400002 | 37.733803183770796 | -122.433989022279 | (37.7338031837708, -122.433989022279) | |||
| 175106 | 175106 | 222543 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 186 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004445.20895 | 2097256.60692 | 37.738918898988295 | -122.427159238823 | (37.7389188989883, -122.427159238823) | |||
| 71778 | 71778 | 222542 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4384 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000744.165990001 | 2102309.32238 | 37.7525824616182 | -122.44031795801399 | (37.7525824616182, -122.440317958014) | |||
| 40 | 40 | 222540 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002573.08856 | 2099992.67614 | 37.74632546084511 | -122.433827665916 | (37.7463254608451, -122.433827665916) | |||
| 43 | 43 | 222539 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002564.39948 | 2099984.1142599997 | 37.7463014588556 | -122.433857099823 | (37.7463014588556, -122.433857099823) | |||
| 66 | 66 | 222538 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002556.19825 | 2099973.42317 | 37.746271638232 | -122.43388469462201 | (37.746271638232, -122.433884694622) | |||
| 55593 | 55593 | 222537 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 540 28th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6002401.940909999 | 2099473.8736099997 | 37.744891237355795 | -122.43438238754999 | (37.7448912373558, -122.43438238755) | |||
| 175314 | 175314 | 222507 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1266 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6010033.6534 | 2101840.39608 | 37.7518194273238 | -122.40816009111099 | (37.7518194273238, -122.408160091111) | |||
| 179663 | 179663 | 222506 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 907 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008600.17028 | 2103215.25622 | 37.7555141138929 | -122.413214501368 | (37.7555141138929, -122.413214501368) | |||
| 129952 | 129952 | 222505 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3632 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005354.298280001 | 2105491.7389599998 | 37.7615820394108 | -122.424601669449 | (37.7615820394108, -122.424601669449) | |||
| 134755 | 134755 | 222504 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1303 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 6006973.353680001 | 2107846.47482 | 37.768138895708105 | -122.419169042118 | (37.7681388957081, -122.419169042118) | |||
| 134787 | 134787 | 222503 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1303 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 6006973.91003 | 2107833.94781 | 37.7681045308268 | -122.41916622906099 | (37.7681045308268, -122.419166229061) | |||
| 41763 | 41763 | 222502 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005857.93432 | 2106390.78551 | 37.764079039426704 | -122.42292369548599 | (37.7640790394267, -122.422923695486) | |||
| 136685 | 136685 | 222501 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 140 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005880.72851 | 2106423.94239 | 37.7641713665432 | -122.422847213547 | (37.7641713665432, -122.422847213547) |
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");