trees
527 rows where SiteOrder = 1 and qSpecies_id = 93 sorted by Police 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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
36565 | 109296 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 8 | 2 | 8 | 28853 | 20 | ||||
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 | |||
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 | |||
70094 | 28530 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | Permit Number 769387 | 6010745.98493 | 2111818.73382 | 37.7792575379423 | -122.406399762653 | (37.7792575379423, -122.406399762653) | 14 | 2 | 9 | 28853 | 34 | ||
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 | |||
102509 | 197554 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Kansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 4ft | 6011382.26351 | 2107407.34025 | 37.7671804369461 | -122.403888089262 | (37.7671804369461, -122.403888089262) | 8 | 2 | 8 | 28853 | 20 | |||
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 | |
133546 | 51034 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2004 12:00:00 AM | 13 | Permit Number 47509 | 6009703.0212 | 2109410.10707 | 37.7725856133573 | -122.409837753032 | (37.7725856133573, -122.409837753032) | 14 | 2 | 9 | 28853 | 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 | ||
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 | |||
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 | |||
186613 | 50160 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50543 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | 8 | 2 | 8 | 28853 | 20 | ||
1613 | 112905 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Bancroft Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 25 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||
6032 | 50628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
11444 | 261994 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
21269 | 197529 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1399 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013534.71133 | 2105671.72801 | 37.7625348459264 | -122.396321376134 | (37.7625348459264, -122.396321376134) | 14 | 3 | 8 | 28856 | 29 | |||
44049 | 26131 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | 10 | 3 | 8 | 58 | 1 | |||
48484 | 108585 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 36 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009820.40384 | 2094253.93436 | 37.7309767080873 | -122.408362486264 | (37.7309767080873, -122.408362486264) | 10 | 3 | 7 | 309 | 28 | |||
59121 | 119660 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
60920 | 98610 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1537 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6015377.6336 | 2094141.2385 | 37.7309769017577 | -122.389142180051 | (37.7309769017577, -122.389142180051) | 10 | 3 | 8 | 58 | 1 | |||
84700 | 197537 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 266 Bridgeview Dr | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6012934.68235 | 2095259.36475 | 37.7339113173389 | -122.397666323936 | (37.7339113173389, -122.397666323936) | 10 | 3 | 8 | 58 | 1 | |||
91855 | 197531 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2006 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6012046.11634 | 2103763.76948 | 37.7572130681337 | -122.401335827695 | (37.7572130681337, -122.401335827695) | 10 | 3 | 8 | 28856 | 29 | |||
133863 | 200066 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1563 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6015094.0337 | 2094004.9347 | 37.7305869134552 | -122.390113122096 | (37.7305869134552, -122.390113122096) | 10 | 3 | 8 | 58 | 1 | |||
143988 | 179489 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 36 Goettingen St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6009813.803 | 2094277.07127 | 37.7310398674871 | -122.408386937928 | (37.7310398674871, -122.408386937928) | 10 | 3 | 7 | 309 | 28 | |||
149532 | 16559 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 702X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015638.3263 | 2097400.20162 | 37.7399398030878 | -122.388468300865 | (37.7399398030878, -122.388468300865) | 10 | 3 | 8 | 58 | 1 | |||
160392 | 122800 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1223 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6017230.3941 | 2093111.7012 | 37.7282525286375 | -122.382665199331 | (37.7282525286375, -122.382665199331) | 10 | 3 | 8 | 58 | 1 | |||
162517 | 104734 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 5490x 03RD ST | 1 | Median : Cutout | Tree | DPW 1 | 40 | 9x9 | 6014203 | 2093127 | 37.7281268221954 | -122.393132175736 | (37.7281268221954, -122.393132175736) | 10 | 3 | 8 | 58 | 1 | |||
162841 | 179488 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1309 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006965.96518 | 2093139.94616 | 37.7277576792711 | -122.418151834246 | (37.7277576792711, -122.418151834246) | 9 | 3 | 7 | 309 | 5 | |||
171923 | 49833 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 418@ 19th ST Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 12 | Permit Number 46616 | 6014316.07851 | 2105148.78787 | 37.7611424148166 | -122.393582289386 | (37.7611424148166, -122.393582289386) | 10 | 3 | 8 | 28856 | 29 | |
177148 | 22364 | Landmark tree 11 | Schinus terebinthifolius :: Brazilian Pepper 93 | 5490X 03rd St | 1 | Median : Cutout | Tree | DPW 1 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | 10 | 3 | 8 | 58 | 1 | |||
177149 | 47230 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 890 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 6 | Permit Number 46770 | 6011503.10296 | 2090822.57098 | 37.7216489793918 | -122.40230391012 | (37.7216489793918, -122.40230391012) | 10 | 3 | 7 | 309 | 28 | |
177569 | 200829 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1550 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6011839.8305 | 2107032.5363 | 37.7661768622321 | -122.402279068281 | (37.7661768622321, -122.402279068281) | 8 | 3 | 8 | 28853 | 20 | |||
189391 | 22196 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4049 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015606.879 | 2097560.5249 | 37.7403782752921 | -122.38858822178 | (37.7403782752921, -122.38858822178) | 10 | 3 | 8 | 58 | 1 | |||
7442 | 240565 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 131 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000404.48259 | 2104877.48466 | 37.7596146626978 | -122.441676928051 | (37.7596146626978, -122.441676928051) | 2 | 4 | 5 | 28862 | 3 | |||
9502 | 65156 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 832 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27135 | 6001006.03746235 | 2102623.98500372 | 37.7534613558838 | -122.439434917257 | (37.7534613558838, -122.439434917257) | 2 | 4 | 5 | 28862 | 22 | ||
14741 | 33010 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3622 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42195 | 6005636.60974519 | 2102002.04320044 | 37.7520160884207 | -122.423377179853 | (37.7520160884207, -122.423377179853) | 2 | 4 | 5 | 28859 | 19 | ||
16168 | 4153 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3721-3721 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/1989 12:00:00 AM | 6 | 3X3 | 6005701.8016 | 2100493.99134 | 37.7478790037267 | -122.423044558975 | (37.7478790037267, -122.423044558975) | 2 | 4 | 5 | 28859 | 22 | ||
17604 | 261710 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3555 16th St | 1 | Front Yard : Yard | Tree | Public Library 12 | 8x8 | 6003221.95473 | 2106496.25325 | 37.7642195378276 | -122.432048304209 | (37.7642195378276, -122.432048304209) | 15 | 4 | 5 | 28862 | 3 | ||||
20356 | 39764 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 670 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41130 | 6003007.22096458 | 2104433.1722566 | 37.7585426381862 | -122.432643626683 | (37.7585426381862, -122.432643626683) | 2 | 4 | 5 | 28862 | 3 | ||
20931 | 39484 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3828 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46800 | 6004242.77277465 | 2102507.2235091 | 37.7533244292691 | -122.428233272856 | (37.7533244292691, -122.428233272856) | 2 | 4 | 5 | 28862 | 22 | ||
24448 | 239724 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 957 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000323.35632 | 2102545.02834 | 37.7532056846093 | -122.441790101437 | (37.7532056846093, -122.441790101437) | 2 | 4 | 5 | 28862 | 22 | |||
25673 | 4159 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3736-3738 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1989 12:00:00 AM | 23 | 3X3 | 6005622.07663 | 2100534.07243 | 37.7479845580381 | -122.4233230934 | (37.7479845580381, -122.4233230934) | 2 | 4 | 5 | 28859 | 19 | ||
27845 | 5359 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 233 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6004883.71893 | 2107010.19311 | 37.7657247654982 | -122.426337327709 | (37.7657247654982, -122.426337327709) | 8 | 4 | 5 | 28853 | 19 | |||
29006 | 240570 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 387 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001514.84125 | 2103575.85133 | 37.7561038947038 | -122.437743536251 | (37.7561038947038, -122.437743536251) | 2 | 4 | 5 | 28862 | 3 | |||
31257 | 92610 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3971 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2009 12:00:00 AM | 3x3 | Permit Number 52921 | 6003876 | 2104198 | 37.7579461423488 | -122.429622225876 | (37.7579461423488, -122.429622225876) | 2 | 4 | 5 | 28862 | 3 | ||
31790 | 93029 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 45 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5x6 | undocumented | 6004830 | 2101620 | 37.7509215289079 | -122.426139360449 | (37.7509215289079, -122.426139360449) | 2 | 4 | 5 | 28862 | 22 | ||
33159 | 67820 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 133 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31476 | 6004140.16165068 | 2102371.71829749 | 37.7529465572746 | -122.428578465138 | (37.7529465572746, -122.428578465138) | 2 | 4 | 5 | 28862 | 22 | ||
34589 | 5333 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 135 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6004851.68413 | 2107592.33342 | 37.7673213724137 | -122.426489583844 | (37.7673213724137, -122.426489583844) | 8 | 4 | 5 | 28862 | 19 | |||
37368 | 240575 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3971 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003902.14198 | 2104194.35497 | 37.7579376141555 | -122.429531555935 | (37.7579376141555, -122.429531555935) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||
38500 | 50055 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 646 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46785 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341 | (37.7605408596837, -122.42837316341) | 2 | 4 | 5 | 28862 | 3 | |||
44524 | 106689 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3756 22ND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x5 | 6003424 | 2103059.4 | 37.7547942135386 | -122.431104165828 | (37.7547942135386, -122.431104165828) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
47750 | 240576 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3959 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003949.10391 | 2104197.56099 | 37.7579490759979 | -122.429369370405 | (37.7579490759979, -122.429369370405) | 2 | 4 | 5 | 28862 | 3 | |||
50254 | 239671 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 761 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6005055.20153 | 2103892.32562 | 37.7571735312626 | -122.425522291914 | (37.7571735312626, -122.425522291914) | 2 | 4 | 5 | 28859 | 19 | |||
55892 | 240569 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 22 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000897.89001 | 2104935.427 | 37.7598018583783 | -122.439974637337 | (37.7598018583783, -122.439974637337) | 2 | 4 | 5 | 28862 | 3 | |||
60627 | 240555 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 133 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6004136.97088 | 2102299.45232 | 37.752747951271 | -122.428584348611 | (37.752747951271, -122.428584348611) | 2 | 4 | 5 | 28862 | 22 | |||
63953 | 240580 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3570 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004566.70015 | 2103688.08598 | 37.7565851237183 | -122.427197171329 | (37.7565851237183, -122.427197171329) | 2 | 4 | 5 | 28862 | 3 | |||
64694 | 240561 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3920 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003501.01364 | 2104802.03657 | 37.7595834427499 | -122.430962195664 | (37.7595834427499, -122.430962195664) | 2 | 4 | 5 | 28862 | 3 | |||
65095 | 101807 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 733 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 19463 | 6008567.7 | 2104253 | 37.7583616995478 | -122.413400180344 | (37.7583616995478, -122.413400180344) | 2 | 4 | 7 | 28859 | 19 | ||||
66810 | 51492 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 375 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2005 12:00:00 AM | Permit Number 47803 | 6003974.63917877 | 2102132.0432857 | 37.7522790972887 | -122.429133785293 | (37.7522790972887, -122.429133785293) | 2 | 4 | 5 | 28862 | 22 | ||
68293 | 4163 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3755 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/1989 12:00:00 AM | 12 | 3X3 | 6005492.3082 | 2100481.88372 | 37.7478339350877 | -122.423768117516 | (37.7478339350877, -122.423768117516) | 2 | 4 | 5 | 28859 | 22 | ||
70797 | 239676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1356 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010842.92295 | 2102014.50671 | 37.7523427770036 | -122.405373771977 | (37.7523427770036, -122.405373771977) | 10 | 4 | 8 | 28859 | 19 | |||
71020 | 197528 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010653.38226 | 2106522.32736 | 37.7647096449648 | -122.406346829457 | (37.7647096449648, -122.406346829457) | 8 | 4 | 8 | 28853 | 19 | |||
72079 | 240535 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3256 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006601.37219 | 2103804.03084 | 37.7570183352502 | -122.420168759998 | (37.7570183352502, -122.420168759998) | 2 | 4 | 7 | 28859 | 19 | |||
75286 | 240549 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 426 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6003562.13775 | 2103342.68871 | 37.7555798840224 | -122.430646661337 | (37.7555798840224, -122.430646661337) | 2 | 4 | 5 | 28862 | 22 | |||
77584 | 240559 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 981 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003807.83193 | 2102569.21574 | 37.7534700259438 | -122.42974180935 | (37.7534700259438, -122.42974180935) | 2 | 4 | 5 | 28862 | 22 | |||
80174 | 239691 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3591 21st St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 17 | Width 4ft | 6004486.51598 | 2103644.80101 | 37.756461738522 | -122.427471393514 | (37.756461738522, -122.427471393514) | 2 | 4 | 5 | 28862 | 22 | |||
82956 | 239718 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4818 25th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 10ft | 5999936.37047 | 2101089.09136 | 37.7491859767553 | -122.443023822014 | (37.7491859767553, -122.443023822014) | 2 | 4 | 5 | 28862 | 22 | |||
83999 | 240562 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3818 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004117.0123 | 2105424.98126 | 37.761328784908 | -122.428876176805 | (37.761328784908, -122.428876176805) | 8 | 4 | 5 | 28862 | 3 | |||
85542 | 10223 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1377X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6005871.04446 | 2100967.56548 | 37.7491888788632 | -122.42249296967 | (37.7491888788632, -122.42249296967) | 2 | 4 | 5 | 28859 | 19 | |||
88665 | 5559 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 984 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005041.33516 | 2102650.51852 | 37.7537630358578 | -122.425481873703 | (37.7537630358578, -122.425481873703) | 2 | 4 | 5 | 28862 | 22 | |||
91787 | 239683 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3681 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 7ft | 6005263.58065 | 2101933.28194 | 37.7518062252985 | -122.424662279246 | (37.7518062252985, -122.424662279246) | 2 | 4 | 5 | 28859 | 19 | |||
95412 | 239742 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 832 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6000856.10408 | 2102607.88191 | 37.75340860674 | -122.439952263112 | (37.75340860674, -122.439952263112) | 2 | 4 | 5 | 28862 | 22 | |||
100452 | 240545 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4390 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001366.11149 | 2101175.74148 | 37.749505311641 | -122.438085972914 | (37.749505311641, -122.438085972914) | 2 | 4 | 5 | 28862 | 22 | |||
102826 | 239681 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3616 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6005642.96525 | 2101995.98753 | 37.7519998196473 | -122.423354771113 | (37.7519998196473, -122.423354771113) | 2 | 4 | 5 | 28859 | 19 | |||
106600 | 5405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 381 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2016 12:00:00 AM | 3X3 | 6004938.1878622 | 2106152.8168866 | 37.7633736936511 | -122.426087889681 | (37.7633736936511, -122.426087889681) | 8 | 4 | 5 | 28859 | 19 | |||
108226 | 239714 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 872 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000978.62192 | 2099691.67862 | 37.745408384388 | -122.43931955855 | (37.745408384388, -122.43931955855) | 2 | 4 | 5 | 63 | 22 |
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) );