Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 33614 | 33614 | 188708 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Bridgeview Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6014073.74253 | 2095336.92691 | 37.734187650237395 | -122.393733643518 | (37.7341876502374, -122.393733643518) | ||||
| 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) | |||
| 49122 | 49122 | 221368 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 755 Sanchez St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 3ft | 6003710.38169 | 2103854.76962 | 37.7569943341355 | -122.43017051796998 | (37.7569943341355, -122.43017051797) | |||
| 53970 | 53970 | 188566 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 901 Iowa St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6014791.61868 | 2102890.82424 | 37.7549689439879 | -122.391779701799 | (37.7549689439879, -122.391779701799) | ||||
| 62545 | 62545 | 203698 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1696 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 6ft | 5993434.49176 | 2103973.54477 | 37.7567330891842 | -122.46571676863 | (37.7567330891842, -122.46571676863) | |||
| 67675 | 67675 | 125287 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 945 Green St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6008576.87154 | 2118976.92053 | 37.798790596063206 | -122.414410284916 | (37.7987905960632, -122.414410284916) | ||||
| 70776 | 70776 | 97971 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 3x105 | 6008579.18793 | 2094106.30305 | 37.7305017590298 | -122.412643160269 | (37.7305017590298, -122.412643160269) | |||
| 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) | |||
| 80060 | 80060 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Hiliritas Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | ||||
| 85142 | 85142 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1435X La Salle Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770699 | 6016460.43075 | 2095036.9864400001 | 37.733496412822205 | -122.385461132957 | (37.7334964128222, -122.385461132957) | ||||
| 89406 | 89406 | 114379 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 443X ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5988110.0 | 2090275.0 | 37.718811899837206 | -122.483126550771 | (37.7188118998372, -122.483126550771) | ||||
| 89630 | 89630 | 220144 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 450 Bosworth St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6003159.40524 | 2095238.92343 | 37.733306004372295 | -122.43146095066002 | (37.7333060043723, -122.43146095066) | ||||
| 101578 | 101578 | 117527 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099x WALLER ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000071.0 | 2108311.0 | 37.769023235971 | -122.44307686155001 | (37.769023235971, -122.44307686155) | |||||
| 102829 | 102829 | 98542 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 555 Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 102846 | 102846 | 105415 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
| 105359 | 105359 | 98545 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 555@Rio Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 113891 | 113891 | 220147 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004138.65271 | 2095814.5319700001 | 37.7349419476117 | -122.42811642772699 | (37.7349419476117, -122.428116427727) | ||||
| 121713 | 121713 | 92964 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 380 Valdez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5995792.2 | 2095482.9 | 37.7335556021648 | -122.456948893253 | (37.7335556021648, -122.456948893253) | ||||
| 138465 | 138465 | 120551 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1485 Fairfax Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016296.0 | 2097688.0 | 37.7407664622153 | -122.38621437638201 | (37.7407664622153, -122.386214376382) | |||||
| 153621 | 153621 | 175010 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1051 Hester Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6012675.7431 | 2088120.44685 | 37.714294876771895 | -122.39806090961001 | (37.7142948767719, -122.39806090961) | ||||
| 156682 | 156682 | 175042 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98 San Diego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 5992757.09235 | 2086323.81583 | 37.7082322293939 | -122.466776470378 | (37.7082322293939, -122.466776470378) | ||||
| 171221 | 171221 | 112905 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2401 Keith St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6014331.87009 | 2092225.76664 | 37.725659374776605 | -122.39262364628901 | (37.7256593747766, -122.392623646289) | ||||
| 176663 | 176663 | 175009 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 265 Hester Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6012301.72001 | 2087735.75637 | 37.7132177542762 | -122.399326699068 | (37.7132177542762, -122.399326699068) | ||||
| 178371 | 178371 | 94602 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2939 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/07/2010 12:00:00 AM | 9 | Permit Number 53770 | 5999468.945859999 | 2117347.95354 | 37.7938020288031 | -122.445809330858 | (37.7938020288031, -122.445809330858) | ||
| 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) | ||||
| 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) | |||
| 25522 | 25522 | 175043 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 199 Shakespeare St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 8ft | 5993498.29454 | 2086678.39145 | 37.709248559547504 | -122.464240538697 | (37.7092485595475, -122.464240538697) | |||
| 57106 | 57106 | 220148 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004123.55506 | 2095814.8430700002 | 37.7349419476051 | -122.428168647787 | (37.7349419476051, -122.428168647787) | ||||
| 60424 | 60424 | 125285 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1015 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6008615.56594 | 2118630.81045 | 37.7978424372369 | -122.41425188820699 | (37.7978424372369, -122.414251888207) | ||||
| 66538 | 66538 | 220278 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3925 21st St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6002292.19971 | 2103528.34865 | 37.7560176344239 | -122.435051775442 | (37.7560176344239, -122.435051775442) | ||||
| 98300 | 98300 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1107 Bowdoin St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | ||
| 105444 | 105444 | 105416 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
| 108061 | 108061 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5989494.0 | 2090180.0 | 37.7186314952818 | -122.47833572411999 | (37.7186314952818, -122.47833572412) | |||||
| 168847 | 168847 | 221369 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 755 Sanchez St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 3ft | 6003690.30976 | 2103870.989 | 37.7570377318327 | -122.430241091376 | (37.7570377318327, -122.430241091376) | |||
| 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) | |||
| 175404 | 175404 | 175011 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1051 Hester Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012671.33567 | 2088131.05018 | 37.7143237459272 | -122.398076886938 | (37.7143237459272, -122.398076886938) | ||||
| 176044 | 176044 | 220145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 450 Bosworth St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003154.048330001 | 2095235.16031 | 37.73329536808561 | -122.431479202413 | (37.7332953680856, -122.431479202413) | ||||
| 180588 | 180588 | 188594 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Jack Balestreri Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6012410.71719 | 2104764.5597 | 37.7599813531633 | -122.400145172978 | (37.7599813531633, -122.400145172978) | ||||
| 181734 | 181734 | 175012 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 8ft | 6013182.79855 | 2087056.1572599998 | 37.71140077569589 | -122.396233767795 | (37.7114007756959, -122.396233767795) | |||
| 37054 | 37054 | 175013 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 8ft | 6013185.59041 | 2087064.24232 | 37.7114231310315 | -122.396224684625 | (37.7114231310315, -122.396224684625) | |||
| 43530 | 43530 | 220149 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6004123.90367 | 2095822.3562900003 | 37.734962596934 | -122.428167977786 | (37.734962596934, -122.428167977786) | ||||
| 52850 | 52850 | 220146 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 450 Bosworth St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6003150.7799 | 2095211.43274 | 37.7332300323227 | -122.431488808967 | (37.7332300323227, -122.431488808967) | ||||
| 77934 | 77934 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
| 78929 | 78929 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1325 Portola Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | |||||
| 98469 | 98469 | 107308 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 190 EUCALYPTUS DR | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5990695.4 | 2094728.8 | 37.7311910349726 | -122.474514801842 | (37.7311910349726, -122.474514801842) | ||||
| 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) | |||
| 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) | |||
| 162444 | 162444 | 97973 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 3x105 | Permit Number 767976 | 6008571.293930001 | 2094144.04925 | 37.7306049589414 | -122.412673118464 | (37.7306049589414, -122.412673118464) | ||
| 165578 | 165578 | 246826 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 400 Franconia St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6009973.79808 | 2098728.47143 | 37.7432714144464 | -122.408147628312 | (37.7432714144464, -122.408147628312) | ||||
| 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) | ||||
| 33886 | 33886 | 175014 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 8ft | 6013188.07866 | 2087071.7521799998 | 37.7114438900863 | -122.396216610525 | (37.7114438900863, -122.396216610525) | |||
| 47212 | 47212 | 220136 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2501 25th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6011420.7800900005 | 2101810.83863 | 37.7518158408332 | -122.40336111083401 | (37.7518158408332, -122.403361110834) | ||||
| 54444 | 54444 | 125278 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Greenwich St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6006716.82854 | 2119779.13638 | 37.800888612776106 | -122.420903634692 | (37.8008886127761, -122.420903634692) | ||||
| 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) | |||
| 179805 | 179805 | 246827 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 400 Franconia St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6009974.418190001 | 2098730.47702 | 37.7432769560816 | -122.408145625541 | (37.7432769560816, -122.408145625541) | ||||
| 46213 | 46213 | 125279 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Greenwich St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6006714.731269999 | 2119776.90963 | 37.8008823804688 | -122.42091073396001 | (37.8008823804688, -122.42091073396) | ||||
| 47330 | 47330 | 175015 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6013189.92411 | 2087076.3672900002 | 37.7114566649583 | -122.39621055536999 | (37.7114566649583, -122.39621055537) | |||
| 60005 | 60005 | 220150 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6005133.60427 | 2096768.5161400002 | 37.7376176168434 | -122.424744371178 | (37.7376176168434, -122.424744371178) | ||||
| 143490 | 143490 | 111510 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 800x BOSWORTH ST | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 20 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 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) | |||
| 153992 | 153992 | 220143 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2300 22nd St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6011248.89515 | 2103712.9495599996 | 37.757029016498706 | -122.404089366557 | (37.7570290164987, -122.404089366557) | ||||
| 162818 | 162818 | 220137 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2501 25th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6011439.73612 | 2101810.34595 | 37.751815546759794 | -122.403295523263 | (37.7518155467598, -122.403295523263) | ||||
| 172978 | 172978 | 97975 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 3x105 | Permit Number 767976 | 6008564.43786 | 2094166.6254 | 37.73066656339879 | -122.41269841641399 | (37.7306665633988, -122.412698416414) | ||
| 31496 | 31496 | 220151 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005128.65815 | 2096758.77235 | 37.7375905832326 | -122.42476077930901 | (37.7375905832326, -122.424760779309) | ||||
| 44612 | 44612 | 125280 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Greenwich St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6006711.337180001 | 2119778.11421 | 37.80088549662629 | -122.420922564536 | (37.8008854966263, -122.420922564536) | ||||
| 75430 | 75430 | 125286 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 941 Vallejo St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6008909.00848 | 2118677.12072 | 37.797986072467204 | -122.413239767796 | (37.7979860724672, -122.413239767796) | ||||
| 79771 | 79771 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 595X San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006124.4715599995 | 2100100.1430599997 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | |||||
| 174696 | 174696 | 175016 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 8ft | 6013191.1859 | 2087080.9939 | 37.711469438930294 | -122.396206518314 | (37.7114694389303, -122.396206518314) | |||
| 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) | ||||
| 161044 | 161044 | 220152 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 San Jose Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6005125.321690001 | 2096750.37402 | 37.737567334864295 | -122.424771717755 | (37.7375673348643, -122.424771717755) | ||||
| 162928 | 162928 | 125289 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 900 Green St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008651.45364 | 2119007.8784 | 37.7988797881271 | -122.414154397206 | (37.7988797881271, -122.414154397206) | ||||
| 168523 | 168523 | 97977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 3x105 | Permit Number 767976 | 6008560.783419999 | 2094185.6842900002 | 37.7307186899072 | -122.41271239727301 | (37.7307186899072, -122.412712397273) | ||
| 169297 | 169297 | 175017 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Nueva Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | Width 4ft | 6013060.88681 | 2087564.6207700002 | 37.712790132022704 | -122.39669075108101 | (37.7127901320227, -122.396690751081) | |||
| 184985 | 184985 | 125281 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Greenwich St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6006708.63096 | 2119779.53165 | 37.8008892360157 | -122.42093202991 | (37.8008892360157, -122.42093202991) | ||||
| 173924 | 173924 | 220153 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 9ft | 6004145.42049 | 2095858.4508 | 37.735062921705996 | -122.428096157927 | (37.735062921706, -122.428096157927) | |||
| 40606 | 40606 | 97979 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 3x105 | Permit Number 767976 | 6008557.48708 | 2094193.9971900003 | 37.730741330331995 | -122.412724380735 | (37.730741330332, -122.412724380735) | ||
| 73296 | 73296 | 220154 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6004158.18023 | 2095867.64857 | 37.735088898617896 | -122.428052698177 | (37.7350888986179, -122.428052698177) | ||||
| 55386 | 55386 | 220155 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004171.837169999 | 2095877.8468099998 | 37.735117673337705 | -122.428006207723 | (37.7351176733377, -122.428006207723) | ||||
| 129157 | 129157 | 97980 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x105 | Permit Number 767976 | 6008582.5 | 2094142.5 | 37.730601333974796 | -122.412634267782 | (37.7306013339748, -122.412634267782) | |||
| 141167 | 141167 | 111532 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 10 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 158739 | 158739 | 188663 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 501 Amador St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 1ft | 6017654.784080001 | 2099538.16845 | 37.745921765085605 | -122.38164480728099 | (37.7459217650856, -122.381644807281) | |||
| 129605 | 129605 | 188664 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 501 Amador St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 1ft | 6017799.2263400005 | 2099547.3837200003 | 37.745955042685 | -122.381145981202 | (37.745955042685, -122.381145981202) | |||
| 144952 | 144952 | 97981 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x105 | 6008582.5 | 2094142.5 | 37.730601333974796 | -122.412634267782 | (37.7306013339748, -122.412634267782) | ||||
| 169926 | 169926 | 188630 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Tulare St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6016199.1477 | 2100300.81075 | 37.7479353426391 | -122.386731417715 | (37.7479353426391, -122.386731417715) | ||||
| 9677 | 9677 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9996 | 9996 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 74508 | 74508 | 203882 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 5991371.09776 | 2095893.6112900001 | 37.7344284401265 | -122.47226369551001 | (37.7344284401265, -122.47226369551) | |||
| 68073 | 68073 | 203881 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 5991366.8063199995 | 2095895.3177900002 | 37.734432877380705 | -122.472278656638 | (37.7344328773807, -122.472278656638) | |||
| 72948 | 72948 | 221378 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 190 Storrie St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6000803.23299 | 2105309.21717 | 37.7608228056365 | -122.440328815537 | (37.7608228056365, -122.440328815537) | |||
| 105103 | 105103 | 105858 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1580 Valencia St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 118749 | 118749 | 105859 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1580 Valencia St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 151090 | 151090 | 203880 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 5991364.836759999 | 2095904.51613 | 37.7344580197106 | -122.472286136294 | (37.7344580197106, -122.472286136294) | |||
| 66124 | 66124 | 203879 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 0ft | 5991366.58351 | 2095910.40405 | 37.7344742875433 | -122.472280526329 | (37.7344742875433, -122.472280526329) | |||
| 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) |
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");