Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28716 | 28716 | 226385 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 352 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006123.1231 | 2098057.1404 | 37.7412117286404 | -122.421414615119 | (37.7412117286404, -122.421414615119) | |||
| 188899 | 188899 | 226386 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 354 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006131.45892 | 2098074.37938 | 37.7412595329921 | -122.421387016722 | (37.7412595329921, -122.421387016722) | |||
| 187007 | 187007 | 226411 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 950 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009265.11627 | 2098029.82714 | 37.741313383516996 | -122.410548750743 | (37.741313383517, -122.410548750743) | |||
| 81099 | 81099 | 34556 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 38265 | 6009291.02762051 | 2098031.45158376 | 37.741319296524296 | -122.410459272722 | (37.7413192965243, -122.410459272722) | ||
| 121171 | 121171 | 34557 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2 Nebraska St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 38265 | 6009291.02762051 | 2098031.45158376 | 37.741319296524296 | -122.410459272722 | (37.7413192965243, -122.410459272722) | ||
| 74614 | 74614 | 226387 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 28 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006154.51065 | 2098290.0214 | 37.7418529371529 | -122.421322621667 | (37.7418529371529, -122.421322621667) | |||
| 124255 | 124255 | 43125 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 28 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | Permit Number 42943 | 6006014.62206932 | 2098348.860336 | 37.742006607801706 | -122.421810489884 | (37.7420066078017, -122.421810489884) | ||
| 159380 | 159380 | 248006 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 444 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009948.03902 | 2098416.30132 | 37.7424128208876 | -122.408214684483 | (37.7424128208876, -122.408214684483) | |||
| 134711 | 134711 | 229867 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 474 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002892.54695 | 2098627.83365 | 37.7425960442853 | -122.432625542146 | (37.7425960442853, -122.432625542146) | |||
| 176414 | 176414 | 248003 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 428 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009956.29023 | 2098510.13636 | 37.7426709335279 | -122.40819277067699 | (37.7426709335279, -122.408192770677) | |||
| 35104 | 35104 | 248002 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 428 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009958.97644 | 2098527.35445 | 37.742718361070004 | -122.408184696582 | (37.74271836107, -122.408184696582) | |||
| 129193 | 129193 | 50614 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 474 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | Permit Number 47214 | 6002793.31412073 | 2098675.69251057 | 37.742721825510294 | -122.43297207844401 | (37.7427218255103, -122.432972078444) | |||
| 143365 | 143365 | 37451 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 444 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39924 | 6009949.70212209 | 2098546.33795552 | 37.7427699663381 | -122.40821810325701 | (37.7427699663381, -122.408218103257) | ||
| 57747 | 57747 | 248027 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 423 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009988.36995 | 2098561.68629 | 37.7428142746487 | -122.40808548247 | (37.7428142746487, -122.40808548247) | |||
| 138920 | 138920 | 37050 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 278 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39655 | 6004138.71288838 | 2098700.07455731 | 37.7428649936747 | -122.428321811345 | (37.7428649936747, -122.428321811345) | ||
| 97596 | 97596 | 37445 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 428 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39919 | 6009952.87320759 | 2098588.12487014 | 37.7428848816788 | -122.408210085028 | (37.7428848816788, -122.408210085028) | ||
| 97620 | 97620 | 37446 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 428 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1998 12:00:00 AM | Permit Number 39919 | 6009952.87320759 | 2098588.12487014 | 37.7428848816788 | -122.408210085028 | (37.7428848816788, -122.408210085028) | |||
| 109946 | 109946 | 37443 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 423 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39917 | 6010005.91327801 | 2098599.86014619 | 37.742920074008005 | -122.40802751381901 | (37.742920074008, -122.408027513819) | ||
| 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) | |||
| 53882 | 53882 | 229866 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 116 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6005094.82025 | 2098749.88858 | 37.7430558262652 | -122.42501940003099 | (37.7430558262652, -122.425019400031) | |||
| 118216 | 118216 | 37047 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 116 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39653 | 6005177.12153831 | 2098757.26684492 | 37.743080733972704 | -122.424735348964 | (37.7430807339727, -122.424735348964) | ||
| 165158 | 165158 | 226371 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 626 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002431.857369999 | 2098894.2222599997 | 37.743301348371794 | -122.43423751036 | (37.7433013483718, -122.43423751036) | |||
| 97495 | 97495 | 36018 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 93 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39164 | 6006753.30500561 | 2099126.43768618 | 37.7441832900966 | -122.419311502826 | (37.7441832900966, -122.419311502826) | ||
| 38346 | 38346 | 36010 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.744183746831496 | -122.421946122617 | (37.7441837468315, -122.421946122617) | ||
| 168371 | 168371 | 229745 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 6006000.19569 | 2099145.76871 | 37.7441939246187 | -122.42191696741699 | (37.7441939246187, -122.421916967417) | |||
| 183138 | 183138 | 226388 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 88 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006749.9144 | 2099207.7220900003 | 37.7444062878286 | -122.41932899196001 | (37.7444062878286, -122.41932899196) | |||
| 162976 | 162976 | 248227 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 38 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007014.76999 | 2099297.76945 | 37.7446684509831 | -122.418419557911 | (37.7446684509831, -122.418419557911) | |||
| 167485 | 167485 | 229869 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 314 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003810.99153 | 2099557.89821 | 37.7452018299076 | -122.42951614338001 | (37.7452018299076, -122.42951614338) | |||
| 102190 | 102190 | 37029 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 314 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39639 | 6003842.312663901 | 2099561.92709037 | 37.7452146656232 | -122.429408127516 | (37.7452146656232, -122.429408127516) | ||
| 54838 | 54838 | 226397 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1490 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008007.72496 | 2099487.35787 | 37.745244866072 | -122.414999519809 | (37.745244866072, -122.414999519809) | |||
| 137114 | 137114 | 226401 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 96 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008220.52934 | 2099483.50303 | 37.74524623751729 | -122.414263403134 | (37.7452462375173, -122.414263403134) | |||
| 43371 | 43371 | 100400 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 88 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x3 | 6008223.0 | 2099495.0 | 37.7452779444232 | -122.41425567326598 | (37.7452779444232, -122.414255673266) | |||
| 80186 | 80186 | 104963 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1474X SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3z3 | Permit Number 770948 | 6008023.0 | 2099506.0 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | ||
| 139792 | 139792 | 104962 | Private 5 | Jacaranda mimosifolia :: Jacaranda 52 | 1474X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 74 Aztec St. | 6008023.0 | 2099506.0 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | ||
| 118394 | 118394 | 229868 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 248 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6004337.80093 | 2099585.8632799997 | 37.7453084292413 | -122.427696518086 | (37.7453084292413, -122.427696518086) | |||
| 43697 | 43697 | 226398 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1480 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008004.95256 | 2099511.34192 | 37.745310565138794 | -122.415010803607 | (37.7453105651388, -122.415010803607) | |||
| 84731 | 84731 | 93487 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 643 San Jose Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53236 | 6005997.4 | 2099554.6 | 37.745316324998 | -122.421955670553 | (37.745316324998, -122.421955670553) | |||
| 112234 | 112234 | 37028 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 238 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39638 | 6004336.0974524 | 2099589.08608997 | 37.745317181975395 | -122.427702638011 | (37.7453171819754, -122.427702638011) | ||
| 69907 | 69907 | 226357 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 645 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005980.007540001 | 2099557.6277 | 37.7453236574624 | -122.42201602593799 | (37.7453236574624, -122.422016025938) | |||
| 76600 | 76600 | 226396 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1483 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008038.2899400005 | 2099516.86307 | 37.7453275982942 | -122.41489591881 | (37.7453275982942, -122.41489591881) | |||
| 112350 | 112350 | 68109 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 87 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1993 12:00:00 AM | Permit Number 31855 | 6008266.5705023 | 2099517.92121492 | 37.745343328328296 | -122.41410663456699 | (37.7453433283283, -122.414106634567) | ||
| 180970 | 180970 | 226399 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1480 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008004.14123 | 2099529.6733 | 37.745360853432395 | -122.41501490632 | (37.7453608534324, -122.41501490632) | |||
| 29888 | 29888 | 226402 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 88 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008216.93199 | 2099535.32688 | 37.745388332215704 | -122.414279508218 | (37.7453883322157, -122.414279508218) | |||
| 138378 | 138378 | 68108 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 83 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1993 12:00:00 AM | Permit Number 31854 | 6008265.27071667 | 2099541.297285 | 37.7454074408153 | -122.41411278250601 | (37.7454074408153, -122.414112782506) | ||
| 132371 | 132371 | 226389 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 23 Fair Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006752.48721 | 2099574.02703 | 37.7454122236106 | -122.419346076359 | (37.7454122236106, -122.419346076359) | |||
| 165123 | 165123 | 226400 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1480 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008001.072480001 | 2099553.66374 | 37.745426553388704 | -122.415027215335 | (37.7454265533887, -122.415027215335) | |||
| 40415 | 40415 | 226761 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 69 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005532.060269999 | 2099607.16908 | 37.745434412567896 | -122.423568476998 | (37.7454344125679, -122.423568476998) | |||
| 97500 | 97500 | 68106 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 80 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1993 12:00:00 AM | Permit Number 31852 | 6008212.57916811 | 2099552.28991109 | 37.7454346644163 | -122.41429575959499 | (37.7454346644163, -122.414295759595) | ||
| 174390 | 174390 | 229887 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 87 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008255.9932699995 | 2099554.30466 | 37.745442635078 | -122.414145782603 | (37.745442635078, -122.414145782603) | |||
| 145375 | 145375 | 52376 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 25 Fair Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | Permit Number 48505 | 6006761.98937592 | 2099585.56782641 | 37.7454444472056 | -122.41931403787399 | (37.7454444472056, -122.419314037874) | ||
| 77536 | 77536 | 68105 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31851 | 6008211.91573535 | 2099564.22145596 | 37.745467388517795 | -122.414298897694 | (37.7454673885178, -122.414298897694) | ||
| 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) | |||
| 103667 | 103667 | 68104 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 8 | 5x7 | Permit Number 31850 | 6008263.32103821 | 2099576.36139011 | 37.7455036095439 | -122.414122004435 | (37.7455036095439, -122.414122004435) |
| 60525 | 60525 | 226466 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 7 28th St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6005836.7555 | 2099627.17961 | 37.7455065507954 | -122.42251630979901 | (37.7455065507954, -122.422516309799) | |||
| 105340 | 105340 | 94041 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 5 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2010 12:00:00 AM | Permit Number 53451 | 6005890.0 | 2099632.0 | 37.7455227900977 | -122.422332540821 | (37.7455227900977, -122.422332540821) | |||
| 47649 | 47649 | 226766 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 84 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005428.90079 | 2099643.2891700002 | 37.7455277666988 | -122.42392775438101 | (37.7455277666988, -122.423927754381) | |||
| 126573 | 126573 | 52052 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 84 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2005 12:00:00 AM | Permit Number 48254 | 6005362.31259493 | 2099645.76538508 | 37.745530806311706 | -122.424158182307 | (37.7455308063117, -122.424158182307) | |||
| 150373 | 150373 | 229747 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 84 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005427.81149 | 2099645.37238 | 37.74553342522071 | -122.423931669125 | (37.7455334252207, -122.423931669125) | |||
| 101573 | 101573 | 34194 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 62 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1997 12:00:00 AM | Permit Number 38013 | 6005507.05529052 | 2099654.01670417 | 37.7455616340181 | -122.42365827055599 | (37.7455616340181, -122.423658270556) | |||
| 185078 | 185078 | 226762 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 62 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005544.98011 | 2099653.8434200003 | 37.745563298918704 | -122.42352711990101 | (37.7455632989187, -122.423527119901) | |||
| 48681 | 48681 | 229888 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 83 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008255.19246 | 2099602.19695 | 37.745574091677206 | -122.414151939365 | (37.7455740916772, -122.414151939365) | |||
| 187546 | 187546 | 32262 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 3 | Permit Number 35561 | 6005748.8799 | 2099664.71545 | 37.7456046578383 | -122.422822837406 | (37.7456046578383, -122.422822837406) | |
| 69857 | 69857 | 226395 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1467 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008034.1838 | 2099620.63234 | 37.7456122948636 | -122.414917460292 | (37.7456122948636, -122.414917460292) | |||
| 77815 | 77815 | 71739 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1467 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1995 12:00:00 AM | 3x3 | Permit Number 56975 | 6008043.26276721 | 2099626.05915094 | 37.745627705832206 | -122.41488645052 | (37.7456277058322, -122.41488645052) | ||
| 118944 | 118944 | 68103 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 67 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 8 | 3x3 | Permit Number 31849 | 6008260.07157656 | 2099634.80152159 | 37.745663890633296 | -122.414137374358 | (37.7456638906333, -122.414137374358) |
| 152131 | 152131 | 226403 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008209.691880001 | 2099648.73947 | 37.7456993312598 | -122.414312566376 | (37.7456993312598, -122.414312566376) | |||
| 50747 | 50747 | 229889 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008249.8814900005 | 2099665.88685 | 37.7457486716635 | -122.414174809135 | (37.7457486716635, -122.414174809135) | |||
| 82302 | 82302 | 100215 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 7x6 | 6008249.0 | 2099678.0 | 37.745781882165495 | -122.41417871405301 | (37.7457818821655, -122.414178714053) | |||
| 124012 | 124012 | 65976 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 59 & 1/2 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 8 | 6x6 | Permit Number 31847 | 6008257.472006501 | 2099681.55363989 | 37.745792115536204 | -122.414149670347 | (37.7457921155362, -122.414149670347) |
| 125360 | 125360 | 36029 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 57 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39176 | 6008256.82211369 | 2099693.24167493 | 37.745824171776206 | -122.414152744353 | (37.7458241717762, -122.414152744353) | ||
| 49531 | 49531 | 226394 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1451 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008031.02829 | 2099712.8613299998 | 37.7458653577975 | -122.41493489813699 | (37.7458653577975, -122.414934898137) | |||
| 45657 | 45657 | 229886 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1420 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007989.59839 | 2099723.5875 | 37.7458924813579 | -122.41507891646002 | (37.7458924813579, -122.41507891646) | |||
| 180200 | 180200 | 226393 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1451 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008028.94032 | 2099726.7877 | 37.745903479176896 | -122.41494310356701 | (37.7459034791769, -122.414943103567) | |||
| 152613 | 152613 | 229890 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 67 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008246.22081 | 2099723.2099 | 37.7459058623841 | -122.414191522144 | (37.7459058623841, -122.414191522144) | |||
| 71491 | 71491 | 229885 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1420 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007989.39364 | 2099739.3415900003 | 37.74593572706829 | -122.415080739378 | (37.7459357270683, -122.415080739378) | |||
| 144969 | 144969 | 226392 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1441 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008026.30666 | 2099772.03767 | 37.746027577510795 | -122.414955412565 | (37.7460275775108, -122.414955412565) | |||
| 23785 | 23785 | 226391 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1437 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008021.55589 | 2099786.31396 | 37.746066510059705 | -122.414972850429 | (37.7460665100597, -122.414972850429) | |||
| 172350 | 172350 | 229891 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008240.95046 | 2099813.7494799998 | 37.7461541678773 | -122.41421615095301 | (37.7461541678773, -122.414216150953) | |||
| 129988 | 129988 | 229894 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1435 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008020.95699 | 2099824.31502 | 37.7461708188376 | -122.414977610555 | (37.7461708188376, -122.414977610555) | |||
| 181441 | 181441 | 229892 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008238.53675 | 2099832.54368 | 37.7462056369848 | -122.414225826762 | (37.7462056369848, -122.414225826762) | |||
| 158140 | 158140 | 226358 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 603 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006078.34429 | 2099888.6136 | 37.7462380152724 | -122.42169949783899 | (37.7462380152724, -122.421699497839) | |||
| 1674 | 1674 | 251651 | Significant Tree 6 | Jacaranda mimosifolia :: Jacaranda 52 | 3237 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009049.0 | 2099828.0 | 37.746238652288106 | -122.411423013741 | (37.7462386522881, -122.411423013741) | ||||
| 149086 | 149086 | 229895 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1429 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008018.20821 | 2099852.6789700002 | 37.7462485454514 | -122.41498912275101 | (37.7462485454514, -122.414989122751) | |||
| 53312 | 53312 | 229893 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 57 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008237.21282 | 2099854.8620700003 | 37.7462668439462 | -122.414231983545 | (37.7462668439462, -122.414231983545) | |||
| 60786 | 60786 | 226304 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1425 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008016.149119999 | 2099877.20359 | 37.7463157688762 | -122.41499797839899 | (37.7463157688762, -122.414997978399) | |||
| 183574 | 183574 | 226406 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1417 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008014.498269999 | 2099882.17848 | 37.7463293360461 | -122.415004038921 | (37.7463293360461, -122.415004038921) | |||
| 59781 | 59781 | 226763 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 162 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005498.11754 | 2099940.99775 | 37.7463491139326 | -122.42370957704901 | (37.7463491139326, -122.423709577049) | |||
| 109794 | 109794 | 42046 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 162 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45105 | 6005486.77037609 | 2099946.40187796 | 37.7463633118872 | -122.423749198438 | (37.7463633118872, -122.423749198438) | ||
| 123795 | 123795 | 93885 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 61@ San Jose Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2010 12:00:00 AM | Permit Number 53373 | 6006171.0 | 2099937.0 | 37.746376097789394 | -122.421382540818 | (37.7463760977894, -122.421382540818) | |||
| 139712 | 139712 | 49967 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3228@ PRECITA Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/02/2003 12:00:00 AM | Permit Number 46719 | 6008983.82935555 | 2099882.83427264 | 37.7463855595114 | -122.41165224039499 | (37.7463855595114, -122.411652240395) | ||
| 47572 | 47572 | 229860 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3224 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008991.737509999 | 2099895.44974 | 37.746420642402605 | -122.411625786002 | (37.7464206424026, -122.411625786002) | |||
| 152981 | 152981 | 226310 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010345.87417 | 2099884.35237 | 37.7464660383936 | -122.406942531387 | (37.7464660383936, -122.406942531387) | |||
| 179360 | 179360 | 226405 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1405 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008013.30182 | 2099943.8587 | 37.746498628924996 | -122.415012541103 | (37.746498628925, -122.415012541103) | |||
| 43915 | 43915 | 226404 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 47 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007592.36819 | 2099969.05914 | 37.746544160700005 | -122.416469871814 | (37.7465441607, -122.416469871814) | |||
| 75612 | 75612 | 229880 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 482 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003343.61389 | 2100112.58509 | 37.7466983971062 | -122.43117183930201 | (37.7466983971062, -122.431171839302) | |||
| 86552 | 86552 | 94514 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 476 27th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53699 | 6003420.0 | 2100114.0 | 37.746706610489 | -122.430907804941 | (37.746706610489, -122.430907804941) | ||||
| 69439 | 69439 | 229879 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 402 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003795.058999999 | 2100140.55813 | 37.7468007768344 | -122.429612782729 | (37.7468007768344, -122.429612782729) | |||
| 175571 | 175571 | 229878 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 402 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003817.08439 | 2100142.49851 | 37.746807351775 | -122.429536759424 | (37.746807351775, -122.429536759424) | |||
| 104080 | 104080 | 37022 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 402 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39634 | 6003883.04118176 | 2100148.50226599 | 37.746827570965294 | -122.429309115245 | (37.7468275709653, -122.429309115245) | ||
| 139853 | 139853 | 37023 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 402 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39634 | 6003883.04118176 | 2100148.50226599 | 37.746827570965294 | -122.429309115245 | (37.7468275709653, -122.429309115245) |
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");