trees
527 rows where SiteOrder = 1 and qSpecies_id = 93 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2386 | 19745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
18752 | 51349 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 6401 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2004 12:00:00 AM | Permit Number 47697 | |||||||||||||
17584 | 66355 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 842 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1992 12:00:00 AM | 15 | Permit Number 30970 | 6006677.47104 | 2121530.77464 | 37.8056959468756 | -122.421164278004 | (37.8056959468756, -122.421164278004) | 5 | 1 | 1 | 28858 | 32 | ||
22630 | 59288 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2067 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1980 12:00:00 AM | 17 | Permit Number 18625 | 6003010.51633 | 2119230.45541 | 37.7991724689015 | -122.433689789967 | (37.7991724689015, -122.433689789967) | 13 | 9 | 1 | 57 | 17 | ||
29722 | 39913 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2116 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | Permit Number 770988 | 6000956 | 2115624 | 37.7891532958703 | -122.440540293957 | (37.7891532958703, -122.440540293957) | 13 | 6 | 1 | 29490 | 27 | ||
45910 | 250462 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 290 Seacliff Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5986816.96544 | 2115727.4811 | 37.7886221640356 | -122.489466544563 | (37.7886221640356, -122.489466544563) | 11 | 6 | 1 | 55 | 33 | |||
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 | ||
58010 | 56642 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 345 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/1981 12:00:00 AM | 12 | Permit Number 19074 | 5997614.66831 | 2115182.98817 | 37.7877515636362 | -122.452068994515 | (37.7877515636362, -122.452068994515) | 11 | 6 | 1 | 54 | 31 | ||
61164 | 57496 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2090 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1988 12:00:00 AM | 15 | Permit Number 25529 | 6003581.68174 | 2117969.32312 | 37.7957421173574 | -122.431623277394 | (37.7957421173574, -122.431623277394) | 13 | 9 | 1 | 57 | 17 | ||
67130 | 23587 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3251X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.425855144407 | (37.8066799978444, -122.425855144407) | 13 | 1 | 1 | 28858 | 17 | |||
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 | |||
82261 | 68986 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1990 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 18 | Permit Number 32976 | 5999758.99431 | 2121250.9256 | 37.8045351046614 | -122.44508646209 | (37.8045351046614, -122.44508646209) | 13 | 9 | 1 | 57 | 17 | |
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 | |
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 | |||
105968 | 46548 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3042 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2005 12:00:00 AM | 7 | Permit Number 47880 | 5999598.88033 | 2116387.07823 | 37.7911711367754 | -122.445290628875 | (37.7911711367754, -122.445290628875) | 13 | 6 | 1 | 29490 | 27 | ||
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 | |||
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 | |||
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 | ||
128300 | 40086 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1667 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/1999 12:00:00 AM | 9 | Permit Number 41307 | 6005062.9841 | 2118469.14548 | 37.7971983526666 | -122.426533306168 | (37.7971983526666, -122.426533306168) | 13 | 9 | 1 | 57 | 17 | ||
144095 | 68014 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1993 12:00:00 AM | 1 | Permit Number 31744 | 5999283.32146 | 2120515.04352 | 37.8024874104189 | -122.446679585917 | (37.8024874104189, -122.446679585917) | 13 | 9 | 1 | 57 | 17 | ||
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 | |||
151848 | 138288 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2605 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001853.9989 | 2115318.2614 | 37.7883649098379 | -122.43741143324 | (37.7883649098379, -122.43741143324) | 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 | |||
156884 | 136385 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3395 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998661.8986 | 2115230.45117 | 37.787941815198 | -122.448449211579 | (37.787941815198, -122.448449211579) | 13 | 6 | 1 | 54 | 31 | |||
173032 | 138285 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2603 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001869.0685 | 2115321.3526 | 37.7883742541874 | -122.437359516387 | (37.7883742541874, -122.437359516387) | 13 | 6 | 1 | 29490 | 27 | |||
182662 | 30961 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1900 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/2013 12:00:00 AM | 8 | Permit Number 770536 | 6001993.3657 | 2115129.3914 | 37.7878542434133 | -122.436915720974 | (37.7878542434133, -122.436915720974) | 13 | 6 | 1 | 29490 | 27 | |
185426 | 30965 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1932 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 12 | Permit Number 34756 | 6001977.8019 | 2115220.4687 | 37.7881034337143 | -122.436976091665 | (37.7881034337143, -122.436976091665) | 13 | 6 | 1 | 29490 | 27 | |
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 | |||
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 |
190896 | 138387 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1905 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001950.5989 | 2115065.5557 | 37.7876765361513 | -122.43705911384 | (37.7876765361513, -122.43705911384) | 13 | 6 | 1 | 29490 | 27 | |||
194298 | 262528 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||
17629 | 71250 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1240 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6x3 | 6007647.94637 | 2118195.049 | 37.7965915450137 | -122.417569230932 | (37.7965915450137, -122.417569230932) | 5 | 1 | 10 | 28858 | 32 | ||
23104 | 136416 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6013522.99602 | 2118258.2651 | 37.797093950371 | -122.397244549101 | (37.797093950371, -122.397244549101) | 3 | 1 | 10 | 28860 | 6 | |||
28172 | 142669 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 444 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6009205.7299 | 2121176.5543 | 37.8048655501446 | -122.412389783451 | (37.8048655501446, -122.412389783451) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
31371 | 47783 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 411 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | Permit Number 45557 | 6009328.94293981 | 2121149.73408628 | 37.8047988220658 | -122.4119614934 | (37.8047988220658, -122.4119614934) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
56923 | 136400 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007907.63985 | 2115517.19966 | 37.7892534404542 | -122.416480851612 | (37.7892534404542, -122.416480851612) | 13 | 1 | 10 | 28858 | 21 | |||
59403 | 46760 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 1 | 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 | |||
67554 | 23458 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2252 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 4X4 | 6005965.50421 | 2118183.1057 | 37.7964639393172 | -122.423390011952 | (37.7964639393172, -122.423390011952) | 13 | 9 | 10 | 28858 | 32 | |||
68428 | 113589 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6013618.31729 | 2118086.59987 | 37.7966279046102 | -122.396902670038 | (37.7966279046102, -122.396902670038) | 3 | 1 | 10 | 28860 | 6 | |||
74616 | 136410 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1700 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008350.5752 | 2118320.27531 | 37.7969748963406 | -122.415146840471 | (37.7969748963406, -122.415146840471) | 5 | 1 | 10 | 308 | 21 | |||
78374 | 40569 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1750 Taylor St | 1 | 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 | |||
84021 | 49096 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 550 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2003 12:00:00 AM | 3 | Permit Number 46244 | 6013227.23366 | 2118310.02974 | 37.7972196135456 | -122.398271600054 | (37.7972196135456, -122.398271600054) | 3 | 1 | 10 | 28860 | 6 | ||
108020 | 47787 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 445 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | 7 | Permit Number 45558 | 6009109.534 | 2121122.2501 | 37.8047110457521 | -122.412718839471 | (37.8047110457521, -122.412718839471) | 3 | 1 | 10 | 308 | 23 | ||
117371 | 114997 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 460 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009124.5214 | 2121167.813 | 37.8048369912448 | -122.412670196869 | (37.8048369912448, -122.412670196869) | 3 | 1 | 10 | 308 | 23 | |||
131492 | 136403 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 897 Green St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6008921.12724 | 2119013.91425 | 37.7989115045253 | -122.413221661757 | (37.7989115045253, -122.413221661757) | 3 | 1 | 10 | 308 | 21 | |||
173622 | 142733 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 425 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009181 | 2121098 | 37.8046484719029 | -122.41246980811 | (37.8046484719029, -122.41246980811) | 3 | 1 | 10 | 308 | 23 | |||
1337 | 27411 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2198 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5996975.1116 | 2109480.4382 | 37.7720572057802 | -122.453869751853 | (37.7720572057802, -122.453869751853) | 15 | 5 | 11 | 29492 | 16 | ||
4554 | 74167 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1801 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6000438.3175 | 2111300.5273 | 37.7772526604879 | -122.442020948646 | (37.7772526604879, -122.442020948646) | 15 | 5 | 11 | 29492 | 16 | |||
5222 | 240527 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 201 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 5997609 | 2105896 | 37.7622515762528 | -122.451418517771 | (37.7622515762528, -122.451418517771) | 15 | 5 | 11 | 29492 | 9 | |||
7621 | 239705 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4922 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 5997802.28625 | 2105653.55065 | 37.7615969375718 | -122.450732535394 | (37.7615969375718, -122.450732535394) | 15 | 5 | 11 | 29492 | 9 | |||
9615 | 70386 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1536 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6000423.3259 | 2110656.0694 | 37.7754822883832 | -122.442026539723 | (37.7754822883832, -122.442026539723) | 15 | 5 | 11 | 29492 | 16 | |||
10054 | 63509 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1805 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/1987 12:00:00 AM | 8 | 3x3 | Permit Number 24115 | 6000922.9965 | 2111712.7723 | 37.7784121888349 | -122.440373864948 | (37.7784121888349, -122.440373864948) | 15 | 5 | 11 | 29490 | 41 |
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 | |||
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 | |
14424 | 46330 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 548 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2002 12:00:00 AM | 11 | Permit Number 44580 | 5996909.4172 | 2109622.8664 | 37.7724445099575 | -122.454107281383 | (37.7724445099575, -122.454107281383) | 15 | 5 | 11 | 29492 | 16 | ||
14953 | 239697 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 155 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5997911.0613 | 2106175.96002 | 37.763037567858 | -122.450393989214 | (37.763037567858, -122.450393989214) | 15 | 5 | 11 | 29492 | 9 | |||
15470 | 105248 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1301 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x5 | 5998246 | 2105821 | 37.7620821004846 | -122.44920998149 | (37.7620821004846, -122.44920998149) | 15 | 5 | 11 | 29492 | 9 | |||
16227 | 138388 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002442.7156 | 2115026.9125 | 37.7875983916864 | -122.435353722329 | (37.7875983916864, -122.435353722329) | 13 | 9 | 11 | 29490 | 27 | |||
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 | |||
21426 | 35154 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 838 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2004 12:00:00 AM | Permit Number 47291 | 6002552.46430035 | 2109566.25151631 | 37.7726110209677 | -122.43458340802 | (37.7726110209677, -122.43458340802) | 15 | 5 | 11 | 29492 | 9 | ||
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 | |||
23571 | 59786 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 401 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/2004 12:00:00 AM | Permit Number 19235 | 5998844.30042115 | 2109361.70149477 | 37.7718381757148 | -122.447395558288 | (37.7718381757148, -122.447395558288) | 15 | 5 | 11 | 29492 | 9 | ||
27418 | 6356 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1234X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001371.4698 | 2112650.1535 | 37.7810115248297 | -122.438889623593 | (37.7810115248297, -122.438889623593) | 15 | 5 | 11 | 29490 | 41 | |||
28287 | 10404 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1372 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 5999585.1964 | 2108804.377 | 37.7703502135529 | -122.444792689196 | (37.7703502135529, -122.444792689196) | 15 | 5 | 11 | 29492 | 9 | |||
28456 | 239669 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 89 Webster St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6004261.58964 | 2108988.28216 | 37.7711209334157 | -122.428630156483 | (37.7711209334157, -122.428630156483) | 7 | 9 | 11 | 29492 | 10 | |||
28691 | 10384 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5999747.97928 | 2108852.64514 | 37.7704920339747 | -122.44423309424 | (37.7704920339747, -122.44423309424) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
35143 | 10438 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1474 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5999064.8261 | 2108729.1491 | 37.770113946782 | -122.446587229644 | (37.770113946782, -122.446587229644) | 15 | 5 | 11 | 29492 | 9 | |||
35777 | 10458 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1568 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998619.39853 | 2108748.68603 | 37.7701421372022 | -122.448129358985 | (37.7701421372022, -122.448129358985) | 15 | 5 | 11 | 29492 | 9 | |||
36218 | 116694 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 536 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x4 | 6004835.97758 | 2110737.29191 | 37.7759557786585 | -122.426767902416 | (37.7759557786585, -122.426767902416) | 7 | 9 | 11 | 28852 | 10 | |||
37454 | 239698 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 157 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5997845.27898 | 2105913.04775 | 37.7623119120732 | -122.450602550973 | (37.7623119120732, -122.450602550973) | 15 | 5 | 11 | 29492 | 9 | |||
39490 | 215006 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1315 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5995155.47354 | 2106606.49729 | 37.764061618685 | -122.459955752961 | (37.764061618685, -122.459955752961) | 15 | 5 | 11 | 56 | 12 | |||
41029 | 67197 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 155 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30649 | 5997964.57682635 | 2106171.52478331 | 37.7630284524752 | -122.450208578402 | (37.7630284524752, -122.450208578402) | 15 | 5 | 11 | 29492 | 9 | ||
41227 | 27410 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2184 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1999 12:00:00 AM | 8 | 3X3 | 5997011.7697 | 2109487.1799 | 37.7720778184275 | -122.453743436192 | (37.7720778184275, -122.453743436192) | 15 | 5 | 11 | 29492 | 16 | ||
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 | |||
42392 | 245011 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1209 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6000668.5479 | 2109254.8115 | 37.7716487585204 | -122.441077707327 | (37.7716487585204, -122.441077707327) | 15 | 5 | 11 | 29492 | 9 | |||
43689 | 245039 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 17 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6000809.9165 | 2109164.6772 | 37.77140932347 | -122.440582240102 | (37.77140932347, -122.440582240102) | 15 | 5 | 11 | 29492 | 9 | |||
44097 | 96379 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 531 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 10 | 3x3 | Permit Number 768930 | 6005269 | 2111284 | 37.7774813787572 | -122.425308876718 | (37.7774813787572, -122.425308876718) | 7 | 9 | 11 | 28852 | 10 | |
46670 | 40143 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560X Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 2 | 3x3 | Permit Number 41343 | 5996910.70022428 | 2109465.35547876 | 37.7720120993682 | -122.454091465131 | (37.7720120993682, -122.454091465131) | 15 | 5 | 11 | 29492 | 16 | |
54668 | 22632 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1171 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6004419.15464 | 2112535.54329 | 37.7808697581914 | -122.428337997055 | (37.7808697581914, -122.428337997055) | 7 | 9 | 11 | 29490 | 41 | |||
56897 | 14749 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 940 McAllister St | 1 | 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 | |||
56958 | 10262 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 212 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005067.14002 | 2109566.55049 | 37.7727542742761 | -122.425884896112 | (37.7727542742761, -122.425884896112) | 7 | 9 | 11 | 28852 | 10 | |||
59824 | 40145 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 1 | 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 | |
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 | |||
60930 | 63546 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1374 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1994 12:00:00 AM | Permit Number 33370 | 6001184.87437591 | 2111109.12550893 | 37.7767696347038 | -122.439424651157 | (37.7767696347038, -122.439424651157) | 15 | 5 | 11 | 29492 | 41 | ||
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 | |||
65135 | 246583 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Waller St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6005277.33485 | 2109248.26095 | 37.7718922045878 | -122.425135156289 | (37.7718922045878, -122.425135156289) | 7 | 9 | 11 | 28852 | 10 | |||
77400 | 247279 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 403 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998855.5655 | 2109315.1105 | 37.7717108924434 | -122.447353237783 | (37.7717108924434, -122.447353237783) | 15 | 5 | 11 | 29492 | 9 | |||
78267 | 240528 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1206 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997448.87335 | 2105784.7399 | 37.7619369136818 | -122.451964305322 | (37.7619369136818, -122.451964305322) | 15 | 5 | 11 | 29492 | 9 | |||
79980 | 10424 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1417 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 5999343.5805 | 2108720.18711 | 37.7701052580123 | -122.445622380313 | (37.7701052580123, -122.445622380313) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |
84963 | 141901 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004790.1275 | 2111962.5056 | 37.7793173224289 | -122.427013793928 | (37.7793173224289, -122.427013793928) | 7 | 9 | 11 | 29490 | 41 | |||
86102 | 219588 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98x Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005256 | 2109297 | 37.7720248250001 | -122.42521242385 | (37.7720248250001, -122.42521242385) | 7 | 9 | 11 | 28852 | 10 | ||||
88229 | 246195 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 44 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999308.8379 | 2108061.5309 | 37.7682947708765 | -122.445695180439 | (37.7682947708765, -122.445695180439) | 15 | 5 | 11 | 29492 | 9 | |||
89421 | 50433 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 403 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47583 | 5998845.21508396 | 2109355.09330434 | 37.7718200835759 | -122.447391918702 | (37.7718200835759, -122.447391918702) | 15 | 5 | 11 | 29492 | 9 | |||
90324 | 239708 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 34 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5998365.05928 | 2106580.5131 | 37.7641743414968 | -122.448852913637 | (37.7641743414968, -122.448852913637) | 15 | 5 | 11 | 29492 | 9 | |||
91572 | 10522 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1855 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2017 12:00:00 AM | 14 | 3X3 | 5997273.9779 | 2108433.2536 | 37.7691990373323 | -122.452760361188 | (37.7691990373323, -122.452760361188) | 15 | 5 | 11 | 29492 | 9 | ||
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 |
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) );