trees
1,069 rows where qSpecies_id = 93 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
127628 | 179481 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988902.49405 | 2090393.59661 | 37.7191836220039 | -122.480395922129 | (37.7191836220039, -122.480395922129) | 1 | 8 | 4 | 64 | 14 | ||||
162222 | 179478 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989807.06872 | 2090726.39006 | 37.720149915678 | -122.477293493993 | (37.720149915678, -122.477293493993) | 1 | 8 | 4 | 64 | 14 | ||||
169793 | 179479 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989502.72531 | 2090743.34169 | 37.7201787974032 | -122.478346734135 | (37.7201787974032, -122.478346734135) | 1 | 8 | 4 | 64 | 14 | ||||
176933 | 179484 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5988536.49014 | 2090373.27915 | 37.7191065591004 | -122.481659555971 | (37.7191065591004, -122.481659555971) | 1 | 8 | 4 | 64 | 14 | ||||
126597 | 33954 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1999 12:00:00 AM | Permit Number 48991 | 6002287.3237241 | 2097040.91143479 | 37.7382043832783 | -122.434604778209 | (37.7382043832783, -122.434604778209) | 2 | 7 | 5 | 63 | 7 | |||
38505 | 251188 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000800 | 2109063 | 37.7711295786607 | -122.440609247553 | (37.7711295786607, -122.440609247553) | 15 | 5 | 11 | 29492 | 9 | ||||
105323 | 251187 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000800 | 2109063 | 37.7711295786607 | -122.440609247553 | (37.7711295786607, -122.440609247553) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | |||
135661 | 245059 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000823.1995 | 2109073.1196 | 37.7711586856136 | -122.44052972578 | (37.7711586856136, -122.44052972578) | 15 | 5 | 11 | 29492 | 9 | |||
136787 | 245058 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000819.4043 | 2109108.2246 | 37.7712548590423 | -122.440545371757 | (37.7712548590423, -122.440545371757) | 15 | 5 | 11 | 29492 | 9 | |||
11580 | 247184 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 1 | : | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | 15 | 5 | 11 | 29492 | 9 | |
19789 | 247187 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 4 | : | Tree | Private 2 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | 15 | 5 | 11 | 29492 | 9 | |||
85114 | 247185 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 2 | : | Tree | Private 2 | 13 | Width 4ft | 6000997.16935 | 2108899.56704 | 37.7706920584128 | -122.439915513203 | (37.7706920584128, -122.439915513203) | 15 | 5 | 11 | 29492 | 9 | |||
114285 | 247188 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000957.54767 | 2108914.20808 | 37.7707300035244 | -122.440053614886 | (37.7707300035244, -122.440053614886) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
35678 | 240563 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Hancock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004179.51855 | 2105131.83325 | 37.7605274080343 | -122.42863909662 | (37.7605274080343, -122.42863909662) | 2 | 4 | 5 | 28862 | 3 | |||
166898 | 240564 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Hancock St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004144.38287 | 2105130.57099 | 37.7605219536452 | -122.428760524878 | (37.7605219536452, -122.428760524878) | 2 | 4 | 5 | 28862 | 3 | |||
31221 | 136411 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
38184 | 54244 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | 24 | Permit Number 9985 | 6003826.70188878 | 2107089.19403693 | 37.7658818771202 | -122.429998956827 | (37.7658818771202, -122.429998956827) | 8 | 4 | 5 | 28862 | 3 | ||
42999 | 197560 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011918.46378 | 2107507.65941 | 37.7674858323444 | -122.402040494185 | (37.7674858323444, -122.402040494185) | 8 | 2 | 8 | 28853 | 20 | |||
64168 | 197567 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6011782.82118 | 2107497.01248 | 37.7674490266805 | -122.402508917767 | (37.7674490266805, -122.402508917767) | 8 | 2 | 8 | 28853 | 20 | |||
96943 | 197563 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011871.68658 | 2107504.14213 | 37.767473563785 | -122.402202043898 | (37.767473563785, -122.402202043898) | 8 | 2 | 8 | 28853 | 20 | |||
126705 | 197568 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6011770.36838 | 2107496.45307 | 37.7674467954558 | -122.402551951223 | (37.7674467954558, -122.402551951223) | 8 | 2 | 8 | 28853 | 20 | |||
127345 | 197565 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011813.28863 | 2107500.86119 | 37.7674612952308 | -122.402403805019 | (37.7674612952308, -122.402403805019) | 8 | 2 | 8 | 28853 | 20 | |||
135187 | 197566 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6011795.68975 | 2107497.96925 | 37.7674523721611 | -122.402464474151 | (37.7674523721611, -122.402464474151) | 8 | 2 | 8 | 28853 | 20 | |||
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 | |||
178619 | 197564 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011853.28866 | 2107502.07899 | 37.7674668719146 | -122.402265535131 | (37.7674668719146, -122.402265535131) | 8 | 2 | 8 | 28853 | 20 | |||
192856 | 197561 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6011901.49708 | 2107505.77021 | 37.7674796980447 | -122.402099047246 | (37.7674796980447, -122.402099047246) | 8 | 2 | 8 | 28853 | 20 | |||
12797 | 62238 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | 21 | Permit Number 22364 | 6001428.6005 | 2093653.63751 | 37.7288549250112 | -122.437331333801 | (37.7288549250112, -122.437331333801) | 9 | 7 | 6 | 28861 | 25 | |
74893 | 179487 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Capistrano Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6001448.45649 | 2093575.59463 | 37.7286417658841 | -122.437257104634 | (37.7286417658841, -122.437257104634) | 9 | 7 | 6 | 28861 | 25 | |||
93273 | 179485 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6001441.34691 | 2093639.06415 | 37.7288156345119 | -122.437286225591 | (37.7288156345119, -122.437286225591) | 9 | 7 | 6 | 28861 | 25 | |||
96692 | 179486 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Capistrano Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6001448.85813 | 2093594.99443 | 37.7286950561315 | -122.437257104643 | (37.7286950561315, -122.437257104643) | 9 | 7 | 6 | 28861 | 25 | |||
2386 | 19745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
102044 | 179480 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5989599 | 2090767 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | 1 | 8 | 4 | 64 | 14 | ||||
112112 | 66607 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 12 | Permit Number 29802 | 5989869.39246895 | 2090726.40504468 | 37.7201535727537 | -122.477078065149 | (37.7201535727537, -122.477078065149) | 1 | 8 | 4 | 64 | 14 | ||
147812 | 141823 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004743.395 | 2112299.7812 | 37.7802407554337 | -122.427199492081 | (37.7802407554337, -122.427199492081) | 7 | 9 | 11 | 29490 | 41 | |||
7377 | 14771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 18 | 4x4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
32237 | 14772 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 7 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 06/30/1994 12:00:00 AM | 18 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
49782 | 14776 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 11 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 06/30/1994 12:00:00 AM | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
115880 | 14775 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 10 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
165709 | 14777 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 12 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
177695 | 12322 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1008X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6004729.34594 | 2112297.27395 | 37.7802330766406 | -122.427247915616 | (37.7802330766406, -122.427247915616) | 7 | 9 | 11 | 29490 | 41 | |||
13044 | 197544 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6011744.68904 | 2107088.20402 | 37.766324401967 | -122.402612061007 | (37.766324401967, -122.402612061007) | 8 | 2 | 8 | 28853 | 20 | |||
26872 | 197546 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011743.17098 | 2107136.96799 | 37.7664582120893 | -122.402620741247 | (37.7664582120893, -122.402620741247) | 8 | 2 | 8 | 28853 | 20 | |||
67001 | 197543 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6011744.4821 | 2107062.59215 | 37.7662540659871 | -122.402610975528 | (37.7662540659871, -122.402610975528) | 8 | 2 | 8 | 28853 | 20 | |||
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 | |||
110464 | 197550 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011736.46068 | 2107238.9435 | 37.7667378392138 | -122.402651123063 | (37.7667378392138, -122.402651123063) | 8 | 2 | 8 | 28853 | 20 | |||
139942 | 197547 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6011743.05813 | 2107162.2739 | 37.7665276901155 | -122.402622911324 | (37.7665276901155, -122.402622911324) | 8 | 2 | 8 | 28853 | 20 | |||
147268 | 197552 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011729.09071 | 2107385.60351 | 37.7671401230397 | -122.402686929574 | (37.7671401230397, -122.402686929574) | 8 | 2 | 8 | 28853 | 20 | |||
147544 | 197548 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6011737.58275 | 2107186.12686 | 37.7665928792734 | -122.402643527378 | (37.7665928792734, -122.402643527378) | 8 | 2 | 8 | 28853 | 20 | |||
153490 | 197549 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011738.81307 | 2107215.77896 | 37.766674365946 | -122.402641357327 | (37.766674365946, -122.402641357327) | 8 | 2 | 8 | 28853 | 20 | |||
155041 | 197553 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6011728.60069 | 2107407.79279 | 37.7672010224355 | -122.402690185116 | (37.7672010224355, -122.402690185116) | 8 | 2 | 8 | 28853 | 20 | |||
187175 | 197551 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011729.23528 | 2107361.85894 | 37.7670749338806 | -122.402684759517 | (37.7670749338806, -122.402684759517) | 8 | 2 | 8 | 28853 | 20 | |||
146370 | 105020 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101X ORD ST | 1 | Median : Yard | Tree | DPW 1 | 12 | 6000863 | 2105739 | 37.7620062865301 | -122.440152928616 | (37.7620062865301, -122.440152928616) | 15 | 5 | 5 | 28862 | 3 | ||||
132607 | 66239 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29337 | 5995901.80991046 | 2090714.82365274 | 37.720469900548 | -122.456225313763 | (37.720469900548, -122.456225313763) | 9 | 8 | 6 | 28861 | 24 | ||
62829 | 240524 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1023 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5997228.03932 | 2107019.29645 | 37.7653140406215 | -122.452817189965 | (37.7653140406215, -122.452817189965) | 15 | 5 | 11 | 29492 | 12 | |||
66304 | 123757 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 103 Cabrillo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5995251.69378 | 2110760.63793 | 37.7754733358801 | -122.459923903312 | (37.7754733358801, -122.459923903312) | 11 | 6 | 2 | 54 | 11 | |||
18859 | 14566 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1030 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5999382.6721 | 2109282.399 | 37.7716511811815 | -122.445527596882 | (37.7716511811815, -122.445527596882) | 15 | 5 | 11 | 29492 | 9 | |||
11220 | 239703 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1048 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5998155.79673 | 2106630.88901 | 37.7643006917393 | -122.449580319477 | (37.7643006917393, -122.449580319477) | 15 | 5 | 11 | 29492 | 9 | |||
8307 | 141930 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004152.017 | 2111873.3634 | 37.7790364568014 | -122.429214926277 | (37.7790364568014, -122.429214926277) | 7 | 9 | 11 | 29490 | 41 | |||
30751 | 141929 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 6004201.9404 | 2111879.6644 | 37.7790565838512 | -122.429042670434 | (37.7790565838512, -122.429042670434) | 7 | 9 | 11 | 29490 | 41 | |||
139426 | 141933 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004066.711 | 2111861.7308 | 37.7789996869773 | -122.429509204364 | (37.7789996869773, -122.429509204364) | 7 | 9 | 11 | 29490 | 41 | |||
161010 | 141934 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004016.7876 | 2111854.945 | 37.7789782281051 | -122.429681425362 | (37.7789782281051, -122.429681425362) | 7 | 9 | 11 | 29490 | 41 | |||
180708 | 141935 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003990.6142 | 2111850.0981 | 37.7789634376361 | -122.429771623844 | (37.7789634376361, -122.429771623844) | 7 | 9 | 11 | 29490 | 41 | |||
167487 | 17371 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999379.15193 | 2109268.47217 | 37.7716127406754 | -122.445538771694 | (37.7716127406754, -122.445538771694) | 15 | 5 | 11 | 29492 | 9 | |||
75678 | 197519 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1055 Natoma St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6007591.22918 | 2109427.92338 | 37.7725159572842 | -122.417143942455 | (37.7725159572842, -122.417143942455) | 8 | 2 | 9 | 28853 | 19 | |||
47409 | 96967 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1060 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x9 | Created tree record on 8/15/2011; marked tree basin for expansion. C.Buck | 6003141 | 2102066 | 37.7520505318065 | -122.432011924137 | (37.7520505318065, -122.432011924137) | 2 | 4 | 5 | 28862 | 22 | |||
4235 | 215001 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995907.45606 | 2090967.94562 | 37.7211652376617 | -122.45622408897 | (37.7211652376617, -122.45622408897) | 9 | 8 | 6 | 28861 | 24 | |||
44330 | 67999 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31724 | 5995906.21686349 | 2090968.00525531 | 37.7211653302718 | -122.456228376798 | (37.7211653302718, -122.456228376798) | 9 | 8 | 6 | 28861 | 24 | ||
81823 | 62229 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 107 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 9 | Permit Number 22354 | 6001481.45016 | 2093645.47099 | 37.7288355059294 | -122.437148044757 | (37.7288355059294, -122.437148044757) | 9 | 7 | 6 | 28861 | 25 | |
138687 | 245014 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1070 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999399.1249 | 2109164.2378 | 37.771327679754 | -122.44546218799 | (37.771327679754, -122.44546218799) | 15 | 5 | 11 | 29492 | 9 | |||
76734 | 68000 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1993 12:00:00 AM | Permit Number 31725 | 5995961.29385488 | 2091144.32738343 | 37.7216526305362 | -122.456050733712 | (37.7216526305362, -122.456050733712) | 9 | 8 | 6 | 28861 | 24 | ||
101282 | 215002 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995954.15999 | 2091115.97449 | 37.7215743707347 | -122.456073344621 | (37.7215743707347, -122.456073344621) | 9 | 8 | 6 | 28861 | 24 | |||
108379 | 41627 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1095 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | 8 | 2 | 9 | 28853 | 19 | |||
163502 | 41628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1095 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
8379 | 114770 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
112226 | 246230 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999421.9446 | 2107737.958 | 37.7674127782259 | -122.445280689263 | (37.7674127782259, -122.445280689263) | 15 | 5 | 11 | 29492 | 9 | |||
114122 | 246227 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999464.6435 | 2107744.6203 | 37.7674335084717 | -122.445133479177 | (37.7674335084717, -122.445133479177) | 15 | 5 | 11 | 29492 | 9 | |||
116428 | 246228 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 5999452.5303 | 2107741.8948 | 37.7674253335335 | -122.445175180965 | (37.7674253335335, -122.445175180965) | 15 | 5 | 11 | 29492 | 9 | |||
119182 | 114771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
154229 | 114773 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
160504 | 114772 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
57929 | 179458 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6001021.22839 | 2089673.68312 | 37.7179037068739 | -122.438454610411 | (37.7179037068739, -122.438454610411) | 9 | 7 | 6 | 28861 | 5 | |||
74066 | 179461 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000982.14926 | 2089697.75779 | 37.7179675875255 | -122.43859141349 | (37.7179675875255, -122.43859141349) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
157153 | 179460 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6000997.30077 | 2089688.71555 | 37.7179436214658 | -122.438538393947 | (37.7179436214658, -122.438538393947) | 9 | 7 | 6 | 28861 | 5 | |||
63439 | 9536 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004118.455 | 2112215.6365 | 37.779974353933 | -122.42935544492 | (37.779974353933, -122.42935544492) | 7 | 9 | 11 | 29490 | 41 | ||
118823 | 9537 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004100.4915 | 2112210.9093 | 37.7799603572012 | -122.429417251502 | (37.7799603572012, -122.429417251502) | 7 | 9 | 11 | 29490 | 41 | ||
175086 | 9540 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721316 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | 7 | 9 | 11 | 29490 | 41 | ||
180537 | 9533 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6004176.1272 | 2112221.7819 | 37.7799944925987 | -122.429156369266 | (37.7799944925987, -122.429156369266) | 7 | 9 | 11 | 29490 | 41 | |||
98297 | 30941 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1101 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34750 | 5995913.71268 | 2091275.1809 | 37.7220091920614 | -122.456224664532 | (37.7220091920614, -122.456224664532) | 9 | 8 | 4 | 28861 | 24 | |
186586 | 141838 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1103 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004708.7161 | 2112593.1646 | 37.7810443525714 | -122.427340367744 | (37.7810443525714, -122.427340367744) | 7 | 9 | 11 | 29490 | 41 | |||
27097 | 12333 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1105X Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3X3 | 6004706.62549 | 2112590.71039 | 37.7810374956819 | -122.427347425327 | (37.7810374956819, -122.427347425327) | 7 | 9 | 11 | 29490 | 41 | |||
21443 | 22619 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1107 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6004653.0794 | 2112584.8191 | 37.7810182911755 | -122.427532248108 | (37.7810182911755, -122.427532248108) | 7 | 9 | 11 | 29490 | 41 | |||
112860 | 240566 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 111 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000512.65205 | 2104881.02417 | 37.759630543828 | -122.441303078972 | (37.759630543828, -122.441303078972) | 2 | 4 | 5 | 28862 | 3 | |||
60890 | 239696 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 112 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5997951.3916 | 2106835.98646 | 37.7648521416436 | -122.450302081196 | (37.7648521416436, -122.450302081196) | 15 | 5 | 11 | 29492 | 9 | |||
37780 | 136408 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1120 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008149.75151 | 2118608.08883 | 37.7977538729053 | -122.415862131533 | (37.7977538729053, -122.415862131533) | 5 | 1 | 10 | 28858 | 21 |
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) );