Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5181 | 5181 | 253819 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100x Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001057.0 | 2086858.0 | 37.71017450293179 | -122.43812937571998 | (37.7101745029318, -122.43812937572) | |||||
| 4446 | 4446 | 253627 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 5991061.0 | 2093828.0 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | ||||
| 4105 | 4105 | 253605 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5997753.0 | 2098469.0 | 37.741867117319 | -122.45038506263799 | (37.741867117319, -122.450385062638) | ||||
| 4010 | 4010 | 253604 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 267 Teresita Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 5997729.0 | 2098564.0 | 37.7421265906625 | -122.450474893449 | (37.7421265906625, -122.450474893449) | ||||
| 3817 | 3817 | 253560 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 535 Castenada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5992829.16774 | 2099990.2564 | 37.7457610706327 | -122.46752052447701 | (37.7457610706327, -122.467520524477) | ||||
| 2854 | 2854 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Lopez Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 2777 | 2777 | 253179 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201x Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001862.0 | 2086566.0 | 37.709418484595 | -122.43532626528601 | (37.709418484595, -122.435326265286) | ||||
| 3689 | 3689 | 252876 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Baker St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
| 3756 | 3756 | 252875 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Post St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000387.0 | 2114050.0 | 37.784799083264396 | -122.44239591065 | (37.7847990832644, -122.44239591065) | ||||
| 3694 | 3694 | 252874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Post St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000387.0 | 2114050.0 | 37.784799083264396 | -122.44239591065 | (37.7847990832644, -122.44239591065) | ||||
| 2081 | 2081 | 252873 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Broderick St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
| 3851 | 3851 | 252871 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2557 Sutter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5999847.0 | 2113975.0 | 37.7845623594454 | -122.444258736096 | (37.7845623594454, -122.444258736096) | |||||
| 1500 | 1500 | 251574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 191 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999731.0 | 2100707.0 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | ||||
| 1635 | 1635 | 251542 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 Vista Ln | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 780127 | 5999350.0 | 2102347.0 | 37.752606437592604 | -122.445141915929 | (37.7526064375926, -122.445141915929) | ||||
| 184127 | 184127 | 251009 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3870 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5995692.72986 | 2115842.63123 | 37.7894524874006 | -122.45876626734699 | (37.7894524874006, -122.458766267347) | |||
| 155778 | 155778 | 250948 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 222 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987141.62407 | 2114456.1943200002 | 37.785150523732604 | -122.488249829271 | (37.7851505237326, -122.488249829271) | |||
| 121249 | 121249 | 250947 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 222 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5987142.15773 | 2114445.06147 | 37.7851199872528 | -122.488247164595 | (37.7851199872528, -122.488247164595) | |||
| 187226 | 187226 | 250936 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 242 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5987145.66978 | 2114320.34633 | 37.7847777601171 | -122.488225846157 | (37.7847777601171, -122.488225846157) | |||
| 152473 | 152473 | 250847 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 232 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5986528.248319999 | 2114250.81305 | 37.7845508009207 | -122.49035677535299 | (37.7845508009207, -122.490356775353) | |||
| 43572 | 43572 | 250846 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 232 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 4ft | 5986528.43338 | 2114238.12689 | 37.784515979183205 | -122.490355201546 | (37.7845159791832, -122.490355201546) | |||
| 171905 | 171905 | 250845 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 236 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986530.263669999 | 2114217.2530099996 | 37.7844587724096 | -122.490347333357 | (37.7844587724096, -122.490347333357) | |||
| 71539 | 71539 | 250843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 242 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986531.75481 | 2114201.82149 | 37.7844164889825 | -122.49034103900401 | (37.7844164889825, -122.490341039004) | |||
| 167392 | 167392 | 250806 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 279 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5986182.48717 | 2114056.1831799997 | 37.7839962033991 | -122.491538643706 | (37.7839962033991, -122.491538643706) | |||
| 35050 | 35050 | 250805 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 279 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5986180.52669 | 2114067.55703 | 37.784027318145 | -122.491546263649 | (37.784027318145, -122.491546263649) | |||
| 180424 | 180424 | 250722 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2720 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5987022.28567 | 2114476.78778 | 37.7852001042432 | -122.48866421169501 | (37.7852001042432, -122.488664211695) | |||
| 2107 | 2107 | 250672 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 726 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 5986349.68151 | 2114864.86182 | 37.786226371002705 | -122.491019750162 | (37.7862263710027, -122.491019750162) | |||
| 123714 | 123714 | 250632 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 161 28th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5987122.253169999 | 2114703.4884200003 | 37.785828392221205 | -122.488335025649 | (37.7858283922212, -122.488335025649) | |||
| 52796 | 52796 | 250631 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 161 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5987117.309769999 | 2114718.2513900003 | 37.7858686386749 | -122.488353213533 | (37.7858686386749, -122.488353213533) | |||
| 74073 | 74073 | 250630 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 161 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5987115.474880001 | 2114730.85404 | 37.785903134875795 | -122.48836048817101 | (37.7859031348758, -122.488360488171) | |||
| 130090 | 130090 | 250583 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2201 Golden Gate Ave | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 25 | Width 4ft | 5997549.22583 | 2111234.92705 | 37.7769074772273 | -122.45201045941799 | (37.7769074772273, -122.452010459418) | |||
| 53319 | 53319 | 250582 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2201 Golden Gate Ave | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 20 | Width 4ft | 5997524.78366 | 2111231.6493599997 | 37.776897077482296 | -122.45209477536301 | (37.7768970774823, -122.452094775363) | |||
| 159493 | 159493 | 250556 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 130 El Camino Del Mar | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 5988132.65183 | 2115364.44627 | 37.787702093729 | -122.48488787927 | (37.787702093729, -122.48488787927) | |||
| 62277 | 62277 | 250545 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 5ft | 5987996.344380001 | 2115386.3423900004 | 37.7877542741995 | -122.485361078263 | (37.7877542741995, -122.485361078263) | |||
| 132215 | 132215 | 250322 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 211 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5987406.48872 | 2114540.6222 | 37.785397787832 | -122.487339695585 | (37.785397787832, -122.487339695585) | |||
| 162958 | 162958 | 250311 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3868 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5995709.62625 | 2115845.34686 | 37.78946091493221 | -122.458708004771 | (37.7894609149322, -122.458708004771) | |||
| 41134 | 41134 | 250218 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 310 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6011294.98745 | 2120066.49067 | 37.8019346079448 | -122.40508143388 | (37.8019346079448, -122.40508143388) | |||
| 153809 | 153809 | 249914 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 356 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | Width 0ft | 6011214.96486 | 2120409.42645 | 37.8028717518996 | -122.40538251610701 | (37.8028717518996, -122.405382516107) | |||
| 133552 | 133552 | 249874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | Width 0ft | 6011664.0982800005 | 2120483.35155 | 37.803099833442296 | -122.403833479743 | (37.8030998334423, -122.403833479743) | |||
| 188029 | 188029 | 249872 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Greenwich St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011683.12279 | 2120489.80597 | 37.8031186185004 | -122.403768099014 | (37.8031186185004, -122.403768099014) | |||
| 131556 | 131556 | 249862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 233 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011661.36372 | 2120433.37836 | 37.80296246649579 | -122.403839424247 | (37.8029624664958, -122.403839424247) | |||
| 173700 | 173700 | 249861 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 233 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011664.77155 | 2120432.0260900003 | 37.8029589438729 | -122.403827536111 | (37.8029589438729, -122.403827536111) | |||
| 73821 | 73821 | 249860 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 233 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6011669.484209999 | 2120431.50277 | 37.8029577702374 | -122.403811190928 | (37.8029577702374, -122.403811190928) | |||
| 150439 | 150439 | 249837 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 333 Greenwich St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011222.467209999 | 2120367.48226 | 37.802757002889294 | -122.405353598393 | (37.8027570028893, -122.405353598393) | |||
| 54670 | 54670 | 249836 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 333 Greenwich St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011225.584869999 | 2120372.97732 | 37.802772265286706 | -122.405343196852 | (37.8027722652867, -122.405343196852) | |||
| 25037 | 25037 | 249812 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Chestnut St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010650.1980099995 | 2121033.7396299997 | 37.8045543690542 | -122.40738094817699 | (37.8045543690542, -122.407380948177) | |||
| 33559 | 33559 | 249811 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 0ft | 6010658.60603 | 2121034.26523 | 37.80455628281221 | -122.40735188838 | (37.8045562828122, -122.40735188838) | |||
| 35303 | 35303 | 249715 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 5999395.51836 | 2116974.38878 | 37.7927721260745 | -122.44603651397 | (37.7927721260745, -122.44603651397) | ||||
| 34603 | 34603 | 249714 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 5999388.9274 | 2116973.5904200003 | 37.7927695576174 | -122.446059261445 | (37.7927695576174, -122.446059261445) | ||||
| 35242 | 35242 | 249713 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 5999382.51554 | 2116973.87968 | 37.792769985700296 | -122.446081467494 | (37.7927699857003, -122.446081467494) | ||||
| 160942 | 160942 | 249712 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | 5999372.04623 | 2116967.23886 | 37.792751153907204 | -122.44611721373998 | (37.7927511539072, -122.44611721374) | ||||
| 35488 | 35488 | 249706 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Baker St | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5999689.68932 | 2117193.0957299997 | 37.7933894315405 | -122.445034403012 | (37.7933894315405, -122.445034403012) | ||||
| 31743 | 31743 | 249705 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Baker St | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 5999691.230359999 | 2117200.88619 | 37.793410910039896 | -122.44502963123101 | (37.7934109100399, -122.445029631231) | ||||
| 148824 | 148824 | 249687 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Baker St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 5999715.024 | 2117348.66269 | 37.793818023244796 | -122.444957931866 | (37.7938180232448, -122.444957931866) | ||||
| 138690 | 138690 | 249574 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6006046.96797 | 2113547.6658099997 | 37.78374077347271 | -122.42277853591801 | (37.7837407734727, -122.422778535918) | |||
| 3621 | 3621 | 249566 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005942.163819999 | 2114329.62673 | 37.7858819315591 | -122.42319672154899 | (37.7858819315591, -122.423196721549) | |||
| 22364 | 22364 | 249565 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 25 | Width 4ft | 6005937.376069999 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | |||
| 135624 | 135624 | 249563 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005926.96353 | 2114419.55716 | 37.7861280004634 | -122.42325570540301 | (37.7861280004634, -122.423255705403) | |||
| 187271 | 187271 | 249543 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1031 Franklin St | 4 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6006034.95999 | 2113672.91543 | 37.7840840006086 | -122.42282898338699 | (37.7840840006086, -122.422828983387) | |||
| 164663 | 164663 | 249542 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1031 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6006025.644830001 | 2113728.66347 | 37.7842365454133 | -122.422865173892 | (37.7842365454133, -122.422865173892) | |||
| 31138 | 31138 | 249446 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1050 Ellis St | 6 | : 4 | Tree 1 | Private 1 | 21 | Width 5ft | 6005679.55916 | 2113469.5737 | 37.7835056151439 | -122.424044078095 | (37.7835056151439, -122.424044078095) | |||
| 67123 | 67123 | 249442 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1050 Ellis St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6005782.21609 | 2113483.18621 | 37.783548787090105 | -122.42368989267901 | (37.7835487870901, -122.423689892679) | |||
| 70092 | 70092 | 249441 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1050 Ellis St | 1 | : 4 | Tree 1 | Private 1 | 21 | Width 5ft | 6005807.98079 | 2113486.28035 | 37.7835587371777 | -122.42360097670601 | (37.7835587371777, -122.423600976706) | |||
| 22309 | 22309 | 248978 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1801 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987396.0 | 2097538.0 | 37.738712644317204 | -122.486127408072 | (37.7387126443172, -122.486127408072) | ||||
| 182022 | 182022 | 248378 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1341 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999502.3457 | 2108149.3513 | 37.768546949836995 | -122.44503217206801 | (37.768546949837, -122.445032172068) | |||
| 133663 | 133663 | 248333 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1329 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999495.3806 | 2108202.9521 | 37.7686937265955 | -122.445060117561 | (37.7686937265955, -122.445060117561) | |||
| 182115 | 182115 | 248321 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1323 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999491.7467 | 2108226.5728 | 37.7687583756776 | -122.445074385233 | (37.7687583756776, -122.445074385233) | |||
| 158446 | 158446 | 248205 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 43 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6006998.73795 | 2099219.63063 | 37.7444529968036 | -122.418469454109 | (37.7444529968036, -122.418469454109) | |||
| 49102 | 49102 | 248109 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 138 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010416.26244 | 2099462.28287 | 37.7453110660681 | -122.406669396477 | (37.7453110660681, -122.406669396477) | ||||
| 66596 | 66596 | 248070 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Rutledge St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6010599.59932 | 2099402.0661 | 37.745155979779504 | -122.406031203374 | (37.7451559797795, -122.406031203374) | ||||
| 26417 | 26417 | 247936 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1149 Esmeralda Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010249.43041 | 2098747.94631 | 37.7433403177918 | -122.40719593154101 | (37.7433403177918, -122.407195931541) | ||||
| 185208 | 185208 | 247934 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6010311.02519 | 2098743.98721 | 37.7433328939103 | -122.406982672633 | (37.7433328939103, -122.406982672633) | ||||
| 56158 | 56158 | 247931 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010377.81236 | 2098773.8118 | 37.7434185228518 | -122.406753840137 | (37.7434185228518, -122.406753840137) | ||||
| 133560 | 133560 | 247858 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 82 Bradford St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009570.7437 | 2098077.6511 | 37.7414618274161 | -122.40949536852501 | (37.7414618274161, -122.409495368525) | ||||
| 65626 | 65626 | 247850 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 42 | 6009080.756440001 | 2098231.91815 | 37.7418579436943 | -122.41120047681801 | (37.7418579436943, -122.411200476818) | ||||
| 23489 | 23489 | 247849 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009118.007540001 | 2098230.0964599997 | 37.74185503078979 | -122.41107154552401 | (37.7418550307898, -122.411071545524) | ||||
| 157576 | 157576 | 247792 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004127.24522 | 2098408.26883 | 37.742063113214996 | -122.42834067009 | (37.742063113215, -122.42834067009) | |||
| 179978 | 179978 | 247790 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6004284.58274 | 2098414.05293 | 37.742087896749794 | -122.42779705870501 | (37.7420878967498, -122.427797058705) | |||
| 163763 | 163763 | 247789 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 5 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004321.812940001 | 2098415.77613 | 37.742094734277 | -122.427668451138 | (37.742094734277, -122.427668451138) | |||
| 29152 | 29152 | 247788 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 4 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004361.25599 | 2098418.6984200003 | 37.742104989252894 | -122.427532277614 | (37.7421049892529, -122.427532277614) | |||
| 76984 | 76984 | 247553 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 815 Buena Vista Ave West | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6000067.12392 | 2108379.2714400003 | 37.7692104712049 | -122.44309517240102 | (37.7692104712049, -122.443095172401) | |||
| 50480 | 50480 | 247552 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 815 Buena Vista Ave West | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 4ft | 6000078.154180001 | 2108371.82358 | 37.769190650166294 | -122.443056484487 | (37.7691906501663, -122.443056484487) | |||
| 64508 | 64508 | 247542 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 24 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6000205.7463 | 2108507.1222099997 | 37.769569420322 | -122.442624867448 | (37.769569420322, -122.442624867448) | ||||
| 177544 | 177544 | 247541 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6000212.071930001 | 2108508.7313900003 | 37.769574199310895 | -122.442603102947 | (37.7695741993109, -122.442603102947) | ||||
| 170837 | 170837 | 247540 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6000206.9211 | 2108513.1896 | 37.7695861468207 | -122.442621239574 | (37.7695861468207, -122.442621239574) | ||||
| 184739 | 184739 | 247539 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6000199.67712 | 2108517.8655 | 37.7695985727307 | -122.442646631948 | (37.7695985727307, -122.442646631948) | ||||
| 175229 | 175229 | 247538 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6000181.2283 | 2108513.20093 | 37.769584713305996 | -122.442710110591 | (37.769584713306, -122.442710110591) | ||||
| 73711 | 73711 | 247537 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 6000156.15822 | 2108509.54409 | 37.769573243351104 | -122.442796564207 | (37.7695732433511, -122.442796564207) | ||||
| 148421 | 148421 | 247536 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6000152.32324 | 2108501.61751 | 37.7695512603229 | -122.44280925995501 | (37.7695512603229, -122.442809259955) | ||||
| 47130 | 47130 | 247535 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6000144.0267 | 2108489.25837 | 37.769516852242496 | -122.442837069672 | (37.7695168522425, -122.442837069672) | ||||
| 29568 | 29568 | 247533 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6000119.08328 | 2108491.6907099998 | 37.769522108775 | -122.44292352241501 | (37.769522108775, -122.442923522415) | ||||
| 161634 | 161634 | 247532 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6000110.003280001 | 2108483.6988 | 37.7694996473165 | -122.442954355683 | (37.7694996473165, -122.442954355683) | ||||
| 46722 | 46722 | 247530 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6000087.40838 | 2108481.3833 | 37.7694920012902 | -122.44303234398501 | (37.7694920012902, -122.443032343985) | ||||
| 69221 | 69221 | 247529 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000073.75314 | 2108487.72588 | 37.7695086378454 | -122.44308003233499 | (37.7695086378454, -122.443080032335) | ||||
| 130643 | 130643 | 247527 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000059.53834 | 2108484.86365 | 37.769499968379705 | -122.443128995021 | (37.7694999683797, -122.443128995021) | ||||
| 156377 | 156377 | 247522 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6000010.6242 | 2108472.60358 | 37.7694635161602 | -122.443297305835 | (37.7694635161602, -122.443297305835) | ||||
| 159551 | 159551 | 247520 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6000003.99995 | 2108482.26842 | 37.7694896756401 | -122.443320913055 | (37.7694896756401, -122.443320913055) | ||||
| 137753 | 137753 | 247499 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 348 Scott St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 0ft | 6002255.8916 | 2109762.6323 | 37.77313339352229 | -122.43562333462 | (37.7731333935223, -122.43562333462) | |||
| 184079 | 184079 | 247490 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 324 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6002272.5041 | 2109643.1807 | 37.7728063526387 | -122.43555732280399 | (37.7728063526387, -122.435557322804) | |||
| 154189 | 154189 | 247416 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 991 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6001894.4537 | 2109427.399 | 37.7721923905385 | -122.43684958992901 | (37.7721923905385, -122.436849589929) | |||
| 182846 | 182846 | 247374 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1163 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 6001848.5023 | 2110108.7192 | 37.7740605142533 | -122.43705732709299 | (37.7740605142533, -122.437057327093) |
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");