trees
93 rows where SiteOrder = 3 and qSpecies_id = 93
This data as json, CSV (advanced)
rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6230 | 262036 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
6859 | 246229 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5999439.8115 | 2107740.3807 | 37.7674204502126 | -122.44521906453 | (37.7674204502126, -122.44521906453) | 15 | 5 | 11 | 29492 | 9 | |||
10659 | 136418 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6013527.00347 | 2118227.13229 | 37.797008690162 | -122.397228498003 | (37.797008690162, -122.397228498003) | 3 | 1 | 10 | 28860 | 6 | |||
15630 | 75661 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 38th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5984119.5345 | 2111005.02849 | 37.7754978458904 | -122.498450151227 | (37.7754978458904, -122.498450151227) | 11 | 6 | 2 | 55 | 26 | |||
17557 | 261982 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2403 Keith St | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
20431 | 248436 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 755 Ashbury St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5999049.7676 | 2107927.8319 | 37.7679128724009 | -122.446581655831 | (37.7679128724009, -122.446581655831) | 15 | 5 | 11 | 29492 | 9 | |||
20607 | 123755 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 4ft | 5995425.06371 | 2110766.64717 | 37.7754998049095 | -122.459324614731 | (37.7754998049095, -122.459324614731) | 11 | 6 | 2 | 54 | 11 | |||
22531 | 138489 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002035.9915 | 2114842.1015 | 37.7870678415341 | -122.436747670692 | (37.7870678415341, -122.436747670692) | 13 | 6 | 11 | 29490 | 27 | |||
26019 | 14743 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
27413 | 101870 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779151 | 6012595.5925 | 2113052.7427 | 37.7827491368943 | -122.400087849303 | (37.7827491368943, -122.400087849303) | 6 | 2 | 9 | 28856 | 34 | |
28353 | 10521 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1855 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 5997344.2343 | 2108442.9441 | 37.769229670497 | -122.452518048778 | (37.769229670497, -122.452518048778) | 15 | 5 | 11 | 29492 | 9 | |||
36115 | 113591 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6013610.58042 | 2118128.2339 | 37.796741791142 | -122.396932362048 | (37.796741791142, -122.396932362048) | 3 | 1 | 10 | 28860 | 6 | |||
37312 | 142672 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 444 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009151.8318 | 2121171.42 | 37.8048484279172 | -122.412575941125 | (37.8048484279172, -122.412575941125) | 3 | 1 | 10 | 308 | 23 | |||
38419 | 179448 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 49 Brookdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006504.26821 | 2087381.76307 | 37.7119209426602 | -122.419339618327 | (37.7119209426602, -122.419339618327) | 9 | 7 | 8 | 309 | 39 | |||
38449 | 197556 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Kansas St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 37 | Width 4ft | 6011387.43171 | 2107337.57251 | 37.7669891592581 | -122.403865303157 | (37.7669891592581, -122.403865303157) | 8 | 2 | 8 | 28853 | 20 | |||
40218 | 124458 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 41 Willard St North | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5996118.46825 | 2111510.19918 | 37.7775812452699 | -122.456979771086 | (37.7775812452699, -122.456979771086) | 11 | 6 | 2 | 54 | 16 | |||
43725 | 200673 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6015618.3638 | 2095361.6525 | 37.7343412551751 | -122.38839507653 | (37.7343412551751, -122.38839507653) | 10 | 3 | 8 | 58 | 1 | |||
46666 | 136413 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 550 Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013222.1695 | 2118341.72349 | 37.7973063549552 | -122.398291348284 | (37.7973063549552, -122.398291348284) | 3 | 1 | 10 | 28860 | 6 | |||
48487 | 136414 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 640 Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013178.6157 | 2118647.51257 | 37.7981435527405 | -122.398463524392 | (37.7981435527405, -122.398463524392) | 3 | 1 | 10 | 28860 | 6 | |||
49310 | 109298 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 8 | 2 | 8 | 28853 | 20 | ||||
50406 | 179433 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006535.42412 | 2086786.75181 | 37.7102889213719 | -122.419189754426 | (37.7102889213719, -122.419189754426) | 9 | 7 | 8 | 309 | 39 | |||
54587 | 246597 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 3 | : | Tree | Private 2 | 16 | Width 3ft | 6005485.46938 | 2109277.24468 | 37.7719835424264 | -122.42441726525 | (37.7719835424264, -122.42441726525) | 7 | 9 | 11 | 28852 | 10 | |||
57986 | 40147 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
63033 | 179440 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Blythdale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6007040.38457 | 2086896.48953 | 37.7106186631909 | -122.417452275027 | (37.7106186631909, -122.417452275027) | 9 | 7 | 8 | 309 | 39 | |||
66240 | 102833 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
69290 | 2751 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 59 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5995436.711 | 2110737.12628 | 37.7754194179801 | -122.459282185974 | (37.7754194179801, -122.459282185974) | 11 | 6 | 2 | 54 | 11 | |||
72102 | 239740 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1314 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2017 12:00:00 AM | 3 | 6x6 | 6003222.89805 | 2100527.56399 | 37.7478309907011 | -122.431618884227 | (37.7478309907011, -122.431618884227) | 2 | 4 | 5 | 63 | 22 | ||
73836 | 215019 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 113 Stillings Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 10ft | 6000031.68078 | 2095690.19732 | 37.7343673311927 | -122.442306709796 | (37.7343673311927, -122.442306709796) | 9 | 7 | 4 | 63 | 40 | |||
74453 | 5263 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1234 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001361.3171 | 2112714.792 | 37.7811884280768 | -122.438929380366 | (37.7811884280768, -122.438929380366) | 15 | 5 | 11 | 29490 | 41 | |||
75778 | 40141 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560X Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | Permit Number 41343 | 5996910.70022428 | 2109465.35547876 | 37.7720120993682 | -122.454091465131 | (37.7720120993682, -122.454091465131) | 15 | 5 | 11 | 29492 | 16 | |||
76665 | 197545 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6011743.33462 | 2107114.1601 | 37.7663955958981 | -122.402618571184 | (37.7663955958981, -122.402618571184) | 8 | 2 | 8 | 28853 | 20 | |||
78732 | 28532 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | Permit Number 769387 | 6010727.06736 | 2111841.54231 | 37.7793191064344 | -122.406466814313 | (37.7793191064344, -122.406466814313) | 14 | 2 | 9 | 28853 | 34 | ||
81245 | 140666 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 540 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5996922.2565 | 2109538.357 | 37.7722132052629 | -122.454056764617 | (37.7722132052629, -122.454056764617) | 15 | 5 | 11 | 29492 | 16 | |||
86507 | 80829 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3100 Turk Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.456929197984 | (37.7774658426, -122.456929197984) | 11 | 6 | 2 | 54 | 16 | |
87999 | 240522 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 395 Sussex St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000901.87189 | 2096680.83514 | 37.7371369499022 | -122.439369168752 | (37.7371369499022, -122.439369168752) | 2 | 7 | 5 | 63 | 7 | |||
89117 | 251320 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 35 Park St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6004965.06472 | 2096463.48809 | 37.7367705580153 | -122.425305393447 | (37.7367705580153, -122.425305393447) | 2 | 7 | 5 | 28859 | 2 | ||||
90230 | 34506 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1x GUY PL | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462 | 2114376 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | 6 | 2 | 9 | 28855 | 6 | |||
90659 | 118237 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 680 38th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 5984156.56832 | 2111248.83134 | 37.7761694298689 | -122.498340055521 | (37.7761694298689, -122.498340055521) | 11 | 6 | 2 | 55 | 26 | |||
94767 | 179482 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5988878.80429 | 2090370.98469 | 37.7191201586413 | -122.48047615337 | (37.7191201586413, -122.48047615337) | 1 | 8 | 4 | 64 | 14 | ||||
96485 | 141902 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004761.5188 | 2111959.3964 | 37.7793071675848 | -122.427112541879 | (37.7793071675848, -122.427112541879) | 7 | 9 | 11 | 29490 | 41 | |||
98734 | 246592 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 22 Waller St | 3 | : | Tree | Private 2 | 20 | Width 3ft | 6005574.15853 | 2109287.40717 | 37.7720164540359 | -122.42411120528 | (37.7720164540359, -122.42411120528) | 7 | 9 | 11 | 28852 | 10 | |||
101559 | 179477 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 245 Wilson St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5994326.32135 | 2086634.18047 | 37.7091748582933 | -122.461375565754 | (37.7091748582933, -122.461375565754) | 9 | 8 | 6 | 28861 | 25 | ||||
101844 | 200843 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1919 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010746.5844 | 2106917.9333 | 37.765801102418 | -122.406052338315 | (37.765801102418, -122.406052338315) | 8 | 4 | 8 | 28853 | 19 | |||
104058 | 239693 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3591 21st St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6004448.48684 | 2103643.67064 | 37.7564564838073 | -122.427602831218 | (37.7564564838073, -122.427602831218) | 2 | 4 | 5 | 28862 | 22 | |||
106282 | 197571 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011772.19211 | 2113135.08358 | 37.7829292819051 | -122.402942275888 | (37.7829292819051, -122.402942275888) | 6 | 2 | 9 | 28853 | 34 | |||
106890 | 142161 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 490X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000657 | 2110488 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | 15 | 5 | 11 | 29492 | 16 | |||
107752 | 94890 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 491 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997284 | 2107398 | 37.7663570704681 | -122.452650969879 | (37.7663570704681, -122.452650969879) | 15 | 5 | 11 | 29492 | 9 | |||||
110036 | 19298 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 40X CABRILLO ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5995512 | 2110798 | 37.7755908894339 | -122.459026153947 | (37.7755908894339, -122.459026153947) | 11 | 6 | 2 | 54 | 11 | |||
112158 | 179483 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5988918.91652 | 2090347.02209 | 37.7190566943955 | -122.480335749404 | (37.7190566943955, -122.480335749404) | 1 | 8 | 4 | 64 | 14 | ||||
112256 | 179466 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6001678.49541 | 2090085.4444 | 37.7190716762026 | -122.436212182343 | (37.7190716762026, -122.436212182343) | 9 | 7 | 6 | 28861 | 5 | |||
115078 | 1630 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 20X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/06/2015 01:42:00 PM | 3 | 3X3 | 5995606.71843 | 2110827.0926 | 37.7756762144924 | -122.458700608592 | (37.7756762144924, -122.458700608592) | 11 | 6 | 2 | 54 | 11 | ||
118357 | 179426 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Santos St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 6ft | 6006719.22339 | 2087474.42971 | 37.7121874900245 | -122.418603238164 | (37.7121874900245, -122.418603238164) | 9 | 7 | 8 | 309 | 39 | |||
121229 | 5352 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6004792.2174 | 2107120.31816 | 37.7660219698556 | -122.426661654709 | (37.7660219698556, -122.426661654709) | 8 | 4 | 5 | 28862 | 3 | |||
124614 | 123734 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 398 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5994478.28383 | 2110786.36923 | 37.7754994768485 | -122.462601159537 | (37.7754994768485, -122.462601159537) | 11 | 6 | 2 | 54 | 11 | |||
126162 | 197522 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1919 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010758.27193 | 2106916.01149 | 37.7657964792528 | -122.406011778026 | (37.7657964792528, -122.406011778026) | 8 | 4 | 8 | 28853 | 19 | |||
129578 | 21856 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 215X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2003 12:00:00 AM | 18 | 4.5X4.5 | 5994989.01038 | 2110754.0886 | 37.7754402423317 | -122.460832106591 | (37.7754402423317, -122.460832106591) | 11 | 6 | 2 | 54 | 11 | ||
132594 | 247579 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 300x Alemany Blvd | 3 | Median : Yard | Tree | DPW 1 | 30 | 6008670.31016 | 2095309.15662 | 37.7338096498957 | -122.412413126286 | (37.7338096498957, -122.412413126286) | 9 | 7 | 7 | 28859 | 2 | ||||
133836 | 136387 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3395 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998704.14947 | 2115236.64778 | 37.7879612450483 | -122.448303478237 | (37.7879612450483, -122.448303478237) | 13 | 6 | 1 | 54 | 31 | |||
134111 | 245060 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000828.8922 | 2109039.4379 | 37.7710665282542 | -122.440507618445 | (37.7710665282542, -122.440507618445) | 15 | 5 | 11 | 29492 | 9 | |||
141055 | 138390 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002448.3159 | 2114992.6104 | 37.7875045249199 | -122.435331891812 | (37.7875045249199, -122.435331891812) | 13 | 9 | 11 | 29490 | 27 | |||
141666 | 26133 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1504 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 5x5 | 6015522.1816 | 2095153.8991 | 37.7337654760523 | -122.388713114387 | (37.7337654760523, -122.388713114387) | 10 | 3 | 8 | 58 | 1 | |||
141904 | 14751 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 940 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
142168 | 246905 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 491 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 5997325.00222 | 2107400.61537 | 37.7663666008754 | -122.452509340335 | (37.7663666008754, -122.452509340335) | 15 | 5 | 11 | 29492 | 9 | |||
144560 | 179459 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6001007.64891 | 2089683.17948 | 37.7179290093058 | -122.438502228612 | (37.7179290093058, -122.438502228612) | 9 | 7 | 6 | 28861 | 5 | |||
145491 | 197562 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6011885.98223 | 2107505.07026 | 37.7674769101657 | -122.402152662133 | (37.7674769101657, -122.402152662133) | 8 | 2 | 8 | 28853 | 20 | |||
147191 | 239721 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 400 Clipper St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6002485.20231 | 2100944.35113 | 37.7489335487424 | -122.434199588643 | (37.7489335487424, -122.434199588643) | 2 | 4 | 5 | 28862 | 22 | |||
147321 | 34510 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | 6 | 2 | 9 | 28855 | 6 | |||
147347 | 46758 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44858 | 6007776.04474552 | 2115482.02501481 | 37.7891494581332 | -122.416933662921 | (37.7891494581332, -122.416933662921) | 13 | 1 | 10 | 28858 | 21 | |||
149756 | 40571 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1750 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.7984424358323 | -122.41375022293 | (37.7984424358323, -122.41375022293) | 3 | 1 | 10 | 308 | 21 | |||
150237 | 200831 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1550 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6011784.6689 | 2107029.6831 | 37.7661659486938 | -122.402469661979 | (37.7661659486938, -122.402469661979) | 8 | 3 | 8 | 28853 | 20 | |||
150837 | 197526 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6010646.79925 | 2106595.9922 | 37.7649115436568 | -122.40637478936 | (37.7649115436568, -122.40637478936) | 8 | 4 | 8 | 28853 | 19 | |||
150907 | 239700 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 157 Rivoli St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997877.76471 | 2105918.81674 | 37.7623296116347 | -122.450490611447 | (37.7623296116347, -122.450490611447) | 15 | 5 | 11 | 29492 | 9 | |||
151691 | 30955 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
152685 | 101980 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
153125 | 136405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 897 Green St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6008967.16736 | 2119019.94772 | 37.7989306555735 | -122.413062774033 | (37.7989306555735, -122.413062774033) | 3 | 1 | 10 | 308 | 21 | |||
164587 | 117839 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 600x 39th Ave | 3 | Median : Cutout | Tree | DPW 1 | 15 | Width 6ft | 5983810.52385 | 2111649.02031 | 37.7772479352498 | -122.499566680778 | (37.7772479352498, -122.499566680778) | 11 | 6 | 2 | 55 | 26 | |||
166144 | 35111 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
166256 | 239741 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1455 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6003319.39316 | 2099769.25377 | 37.7457543167157 | -122.431231089344 | (37.7457543167157, -122.431231089344) | 2 | 7 | 5 | 63 | 22 | |||
166748 | 31500 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3244 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 35060 | 6006677.13820069 | 2103812.71234735 | 37.7570464414299 | -122.419907347924 | (37.7570464414299, -122.419907347924) | 2 | 4 | 7 | 28859 | 19 | ||||
167679 | 7137 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 336X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5994611.62343 | 2110790.08992 | 37.775517371009 | -122.462140179219 | (37.775517371009, -122.462140179219) | 11 | 6 | 2 | 54 | 11 | |||
168461 | 47789 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 445 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | 7 | Permit Number 45558 | 6009148.3227 | 2121126.9048 | 37.8047260033811 | -122.412584936044 | (37.8047260033811, -122.412584936044) | 3 | 1 | 10 | 308 | 23 | ||
170254 | 114999 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 460 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6009096.1804 | 2121164.206 | 37.8048254966519 | -122.412768019096 | (37.8048254966519, -122.412768019096) | 3 | 1 | 10 | 308 | 23 | |||
170405 | 136402 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007876.49139 | 2115513.01244 | 37.7892401916349 | -122.416588325105 | (37.7892401916349, -122.416588325105) | 13 | 1 | 10 | 28858 | 21 | |||
175707 | 41649 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 450X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2000 12:00:00 AM | Permit Number 42121 | 6000751.83853912 | 2110650.06591878 | 37.7754845196238 | -122.440889708326 | (37.7754845196238, -122.440889708326) | 15 | 5 | 11 | 29492 | 10 | |||
177543 | 247186 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 3 | : | Tree | Private 2 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.7707008151093 | -122.439956869431 | (37.7707008151093, -122.439956869431) | 15 | 5 | 11 | 29492 | 9 | ||
180689 | 179493 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6002457.74986 | 2087117.22162 | 37.710965833866 | -122.433306619399 | (37.710965833866, -122.433306619399) | 9 | 7 | 6 | 28861 | 5 | |||
181402 | 179454 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1657 Sunnydale Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6006909.47125 | 2087494.69484 | 37.7122538429007 | -122.417947119763 | (37.7122538429007, -122.417947119763) | 9 | 7 | 8 | 309 | 39 | |||
181985 | 2771 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 300 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 5994637.57621 | 2110789.57481 | 37.775517450891 | -122.462050365613 | (37.775517450891, -122.462050365613) | 11 | 6 | 2 | 54 | 11 | |||
182028 | 111028 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | 8 | 2 | 8 | 28853 | 20 | ||||
187276 | 197540 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 33 Guy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6014343.28071 | 2114436.43625 | 37.7866457311723 | -122.394138442734 | (37.7866457311723, -122.394138442734) | 6 | 2 | 9 | 28855 | 6 | |||
188249 | 197508 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | 6009725.72224 | 2109430.36659 | 37.7726425134742 | -122.409760657749 | (37.7726425134742, -122.409760657749) | 14 | 2 | 9 | 28853 | 34 | ||||
192310 | 21851 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 199X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 5995125.29913 | 2110753.84628 | 37.7754474178474 | -122.460360637268 | (37.7754474178474, -122.460360637268) | 11 | 6 | 2 | 54 | 11 | |||
192936 | 805 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 680X 39th Ave | 3 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983823.96426 | 2111160.91126 | 37.7759085177004 | -122.499484105844 | (37.7759085177004, -122.499484105844) | 11 | 6 | 2 | 55 | 26 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );