trees
1,069 rows where qSpecies_id = 93 sorted by Latitude descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188270 | 30966 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1901X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 16 | 3x3 | Permit Number 34757 | 6001967.37934743 | 2115036.16142537 | 37.7875967808045 | -122.436998951614 | (37.7875967808045, -122.436998951614) | 13 | 6 | 1 | 29490 | 27 |
152947 | 136384 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3604 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5997592.70923 | 2115124.52811 | 37.7875897899782 | -122.452140748718 | (37.7875897899782, -122.452140748718) | 11 | 6 | 1 | 54 | 31 | |||
56839 | 30962 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1900 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34754 | 6002009.52813319 | 2115026.44418956 | 37.7875724953607 | -122.436852429478 | (37.7875724953607, -122.436852429478) | 13 | 6 | 1 | 29490 | 27 | ||
74166 | 138389 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002444.1157 | 2115010.1115 | 37.7875523399426 | -122.435347676 | (37.7875523399426, -122.435347676) | 13 | 9 | 11 | 29490 | 27 | |||
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 | |||
63504 | 138391 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002452.5162 | 2114975.8094 | 37.7874586321962 | -122.435316157397 | (37.7874586321962, -122.435316157397) | 13 | 9 | 11 | 29490 | 27 | |||
159680 | 138406 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002021.2907 | 2114957.6084 | 37.7873841584288 | -122.436806803858 | (37.7873841584288, -122.436806803858) | 13 | 6 | 11 | 29490 | 27 | |||
112939 | 138405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002023.3908 | 2114940.8074 | 37.7873381465407 | -122.436798334797 | (37.7873381465407, -122.436798334797) | 13 | 6 | 11 | 29490 | 27 | |||
89418 | 138404 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6002025.4909 | 2114921.9063 | 37.7872863683147 | -122.436789715353 | (37.7872863683147, -122.436789715353) | 13 | 6 | 11 | 29490 | 27 | |||
98144 | 138403 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002027.5911 | 2114900.905 | 37.7872288234819 | -122.436780945176 | (37.7872288234819, -122.436780945176) | 13 | 6 | 11 | 29490 | 27 | |||
139502 | 138402 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002032.4913 | 2114879.2037 | 37.7871695157566 | -122.43676243751 | (37.7871695157566, -122.43676243751) | 13 | 6 | 11 | 29490 | 27 | |||
44599 | 138401 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002032.4913 | 2114859.6026 | 37.7871156961534 | -122.436761033856 | (37.7871156961534, -122.436761033856) | 13 | 6 | 11 | 29490 | 27 | |||
80568 | 30967 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1904 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34758 | 6002512.7183 | 2114848.7346 | 37.7871131358628 | -122.435098778488 | (37.7871131358628, -122.435098778488) | 13 | 9 | 11 | 29490 | 27 | |
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 | |||
186462 | 30968 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1902 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34759 | 6002518.1694 | 2114816.0277 | 37.7870236405814 | -122.435077578769 | (37.7870236405814, -122.435077578769) | 13 | 9 | 11 | 29490 | 27 | |
131378 | 138488 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002039.4918 | 2114807.7995 | 37.7869738559463 | -122.43673310409 | (37.7869738559463, -122.43673310409) | 13 | 6 | 11 | 29490 | 27 | |||
92768 | 138487 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002041.5919 | 2114791.6986 | 37.786929766345 | -122.436724685254 | (37.786929766345, -122.436724685254) | 13 | 6 | 11 | 29490 | 27 | |||
154530 | 138491 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1800 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002045.7921 | 2114746.8959 | 37.7868069882912 | -122.43670694528 | (37.7868069882912, -122.43670694528) | 13 | 6 | 11 | 29490 | 27 | |||
42292 | 138490 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1800 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002048.5923 | 2114731.495 | 37.7867648604943 | -122.436696154429 | (37.7867648604943, -122.436696154429) | 13 | 6 | 11 | 29490 | 27 | |||
156586 | 197542 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 346 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6014414.15376 | 2114458.74368 | 37.7867109212046 | -122.393894799306 | (37.7867109212046, -122.393894799306) | 6 | 2 | 9 | 28855 | 6 | |||
24897 | 30949 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 10 | 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 | ||
30995 | 30954 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 1 | 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 | ||
51687 | 30943 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 13 | 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 | ||
97829 | 30957 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 2 | 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 | ||
119613 | 30945 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 16 | 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 | ||
135234 | 30946 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 14 | 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 | ||
144248 | 30958 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 8 | 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 | ||
150643 | 30948 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 11 | 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 | ||
151617 | 30952 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 5 | 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 | ||
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 | ||
153237 | 30950 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 7 | 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 | ||
153863 | 30953 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 4 | 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 | ||
159824 | 30944 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 9 | 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 | ||
172994 | 30951 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 6 | 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 | ||
175799 | 30947 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 12 | 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 | ||
178550 | 30956 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 15 | 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 | ||
30024 | 197541 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 33 Guy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014357.779 | 2114449.44998 | 37.7866822697032 | -122.394089193158 | (37.7866822697032, -122.394089193158) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
16917 | 197539 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 33 Guy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014318.065 | 2114410.62146 | 37.7865734481466 | -122.394223875652 | (37.7865734481466, -122.394223875652) | 6 | 2 | 9 | 28855 | 6 | |||
146431 | 120182 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 152 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5987745.04636 | 2114955.0234 | 37.7865553525285 | -122.486198834875 | (37.7865553525285, -122.486198834875) | 11 | 6 | 1 | 55 | 33 | |||
8180 | 197538 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 33 Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6014309.72341 | 2114400.37585 | 37.7865448523989 | -122.39425201814 | (37.7865448523989, -122.39425201814) | 6 | 2 | 9 | 28855 | 6 | |||
115927 | 18088 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3000 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999530.9574 | 2114697.1427 | 37.7865271393644 | -122.445404074823 | (37.7865271393644, -122.445404074823) | 15 | 6 | 1 | 29490 | 31 | |||
108178 | 12645 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 944 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5992509.49668 | 2114843.34604 | 37.7865252483142 | -122.469707022996 | (37.7865252483142, -122.469707022996) | 11 | 6 | 1 | 54 | 11 | |||
131098 | 12646 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 944 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 5992487.23998 | 2114843.45413 | 37.7865242586719 | -122.469784032853 | (37.7865242586719, -122.469784032853) | 11 | 6 | 1 | 54 | 11 | |||
117538 | 30959 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2401 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34753 | 6002022.0507417 | 2114644.40993289 | 37.7865242387809 | -122.436781745524 | (37.7865242387809, -122.436781745524) | 13 | 6 | 1 | 29490 | 27 | ||
183911 | 30960 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2401 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34753 | 6002022.0507417 | 2114644.40993289 | 37.7865242387809 | -122.436781745524 | (37.7865242387809, -122.436781745524) | 13 | 6 | 1 | 29490 | 27 | ||
186525 | 18089 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3000 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 5999515.0867 | 2114695.0726 | 37.786520549412 | -122.445458834419 | (37.786520549412, -122.445458834419) | 15 | 6 | 1 | 29490 | 31 | |||
79932 | 138325 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2492 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001603.2252 | 2114641.6748 | 37.7864929170324 | -122.438230579455 | (37.7864929170324, -122.438230579455) | 13 | 6 | 11 | 29490 | 27 | |||
80921 | 34505 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1x GUY PL | 1 | 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 | |||
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 | |||
93708 | 34503 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1x GUY PL | 2 | 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 | |||
110059 | 34514 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1x GUY PL | 4 | 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 | |||
105423 | 138335 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1799 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002013.7611 | 2114612.8977 | 37.7864372431223 | -122.436808168929 | (37.7864372431223, -122.436808168929) | 13 | 6 | 1 | 29490 | 27 | |||
129693 | 32286 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1800 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | Permit Number 36869 | 6001579.61916409 | 2114619.58179026 | 37.7864309126762 | -122.438310666952 | (37.7864309126762, -122.438310666952) | 13 | 6 | 11 | 29490 | 27 | |||
100760 | 34504 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 6 | 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 | |||
131936 | 34513 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 5 | 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 | |||
136691 | 34507 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 8 | 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 | |||
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 | |||
157944 | 34509 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 4 | 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 | |||
132515 | 102836 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X LANSING ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014464 | 2114267 | 37.7861872071537 | -122.393708916182 | (37.7861872071537, -122.393708916182) | 6 | 2 | 9 | 28855 | 6 | |||
335 | 102831 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
146428 | 102835 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
155597 | 102834 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
167389 | 102832 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
135371 | 122960 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 140 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5993063.2627 | 2114539.09095 | 37.7857218385904 | -122.467769009292 | (37.7857218385904, -122.467769009292) | 11 | 6 | 2 | 54 | 11 | |||
11016 | 53933 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 144 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 17 | Permit Number 9647 | 5993062.86441 | 2114500.7791 | 37.7856166217584 | -122.467767599839 | (37.7856166217584, -122.467767599839) | 11 | 6 | 2 | 54 | 11 | ||
23373 | 53934 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 148 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1992 12:00:00 AM | 16 | Permit Number 30776 | 5993063.90435 | 2114472.77746 | 37.7855397969799 | -122.467761964704 | (37.7855397969799, -122.467761964704) | 11 | 6 | 2 | 54 | 11 | ||
99948 | 47471 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2950 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 4 | Permit Number 45372 | 5999383.7039 | 2114336.8457 | 37.7855294507074 | -122.445887611108 | (37.7855294507074, -122.445887611108) | 15 | 6 | 1 | 29490 | 31 | |
20400 | 84536 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 124 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988694.18379 | 2114506.16667 | 37.7853781914991 | -122.482882183887 | (37.7853781914991, -122.482882183887) | 11 | 6 | 2 | 55 | 26 | |||
49327 | 88393 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 124 23rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51371 | 5988714.5 | 2114502.9 | 37.7853704042268 | -122.482811657264 | (37.7853704042268, -122.482811657264) | 11 | 6 | 2 | 55 | 26 | |||
17552 | 46597 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 170St. 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/09/2002 12:00:00 AM | 11 | Permit Number 44725 | 5993070.73118 | 2114361.72785 | 37.7852352793736 | -122.467730266741 | (37.7852352793736, -122.467730266741) | 11 | 6 | 2 | 54 | 11 | |
27239 | 56308 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 171 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1973 12:00:00 AM | 14 | 3x3 | Permit Number 12442 | 5993024.02697 | 2114355.61708 | 37.785215804041 | -122.467891402947 | (37.785215804041, -122.467891402947) | 11 | 6 | 2 | 54 | 11 | |
67223 | 250321 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 247 27th Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5987414.73446 | 2114306.16368 | 37.7847545126541 | -122.487293940769 | (37.7847545126541, -122.487293940769) | 11 | 6 | 1 | 55 | 33 | |||
187698 | 250320 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 255 27th Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 5987417.56987 | 2114243.02711 | 37.7845813230239 | -122.487279492276 | (37.7845813230239, -122.487279492276) | 11 | 6 | 1 | 55 | 33 | |||
188526 | 106721 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1445 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5999673.9299 | 2113871.5922 | 37.7842685529811 | -122.444850062171 | (37.7842685529811, -122.444850062171) | 15 | 6 | 11 | 29490 | 31 | |||
7491 | 70152 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 231 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5993349.44748 | 2113931.04039 | 37.7840688184898 | -122.466734683653 | (37.7840688184898, -122.466734683653) | 11 | 6 | 2 | 54 | 11 | |||
83828 | 43760 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 8 | Permit Number 43395 | 5990536.37641 | 2113724.23454 | 37.7833382397577 | -122.476451677446 | (37.7833382397577, -122.476451677446) | 11 | 6 | 2 | 55 | 26 | |
47509 | 43759 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43395 | 5990535.98179 | 2113705.55195 | 37.7832869196807 | -122.476451677439 | (37.7832869196807, -122.476451677439) | 11 | 6 | 2 | 55 | 26 | ||
153856 | 86882 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49807 | 6011833 | 2113224.2 | 37.7831773700909 | -122.402738173851 | (37.7831773700909, -122.402738173851) | 6 | 2 | 9 | 28853 | 34 | |||
117285 | 101868 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2014 12:00:00 AM | 6 | 3x3 | Permit Number 771222 | 6012702 | 2113175 | 37.7830907593936 | -122.399728309071 | (37.7830907593936, -122.399728309071) | 6 | 2 | 9 | 28856 | 34 | |
130739 | 197574 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011821.05226 | 2113183.26768 | 37.7830643124058 | -122.402776628832 | (37.7830643124058, -122.402776628832) | 6 | 2 | 9 | 28853 | 34 | |||
96924 | 197573 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011805.47785 | 2113169.35516 | 37.7830252422689 | -122.402829531459 | (37.7830252422689, -122.402829531459) | 6 | 2 | 9 | 28853 | 34 | |||
141730 | 197572 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011789.60702 | 2113153.20247 | 37.7829800045728 | -122.40288330192 | (37.7829800045728, -122.40288330192) | 6 | 2 | 9 | 28853 | 34 | |||
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 | |||
50109 | 197570 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011756.09586 | 2113120.18338 | 37.7828874706141 | -122.402996914199 | (37.7828874706141, -122.402996914199) | 6 | 2 | 9 | 28853 | 34 | |||
23977 | 101872 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012644.6557 | 2113099.5202 | 37.782880312512 | -122.39992139618 | (37.782880312512, -122.39992139618) | 6 | 2 | 9 | 28856 | 34 | |||
153019 | 64355 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 230 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | 8 | Permit Number 770960 | 6011932.302 | 2113111.47227 | 37.7828733899288 | -122.402386698084 | (37.7828733899288, -122.402386698084) | 6 | 2 | 9 | 28853 | 34 | ||
176271 | 197569 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011744.63707 | 2113111.42965 | 37.7828627950365 | -122.403035941152 | (37.7828627950365, -122.403035941152) | 6 | 2 | 9 | 28853 | 34 | |||
155354 | 101871 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6012623.9262 | 2113078.7907 | 37.7828222383966 | -122.399991655868 | (37.7828222383966, -122.399991655868) | 6 | 2 | 9 | 28856 | 34 | |||
101372 | 101867 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769242 | 6012649.1 | 2113074.7 | 37.7828124097662 | -122.399904277178 | (37.7828124097662, -122.399904277178) | 6 | 2 | 9 | 28856 | 34 | |
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 | |
112260 | 101869 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6012583.9023 | 2113041.0524 | 37.7827163862355 | -122.400127471434 | (37.7827163862355, -122.400127471434) | 6 | 2 | 9 | 28856 | 34 | |||
176026 | 121873 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 346 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5990295.07305 | 2113054.8824 | 37.7814863875121 | -122.47723755062 | (37.7814863875121, -122.47723755062) | 11 | 6 | 2 | 55 | 26 | |||
127016 | 5264 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1234 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001356.2408 | 2112747.2805 | 37.7812773444135 | -122.438949270784 | (37.7812773444135, -122.438949270784) | 15 | 5 | 11 | 29490 | 41 | |||
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 | |||
104142 | 5261 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1234 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001382.11052 | 2112701.66304 | 37.7811535623212 | -122.438856504476 | (37.7811535623212, -122.438856504476) | 15 | 5 | 11 | 29490 | 41 | |||
49551 | 5262 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1234 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001365.3782 | 2112681.2883 | 37.7810966664945 | -122.438912929299 | (37.7810966664945, -122.438912929299) | 15 | 5 | 11 | 29490 | 41 | |||
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 |
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) );