trees
1,069 rows where qSpecies_id = 93 sorted by qAddress
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7784 | 197575 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1121 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6013269.3073 | 2090137.6242 | 37.7198666867704 | -122.396150589498 | (37.7198666867704, -122.396150589498) | 10 | 3 | 8 | 58 | 1 | ||||
152373 | 197576 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1121 Jamestown Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6013293.0543 | 2090118.55817 | 37.7198156565414 | -122.396067168381 | (37.7198156565414, -122.396067168381) | 10 | 3 | 8 | 58 | 1 | ||||
160176 | 217708 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1125 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5996389.2535 | 2091794.3451 | 37.7234619803781 | -122.454618335706 | (37.7234619803781, -122.454618335706) | 9 | 8 | 4 | 28861 | 24 | |||
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 | |||
118609 | 136401 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007893.03777 | 2115514.03443 | 37.7892439283227 | -122.416531148891 | (37.7892439283227, -122.416531148891) | 13 | 1 | 10 | 28858 | 21 | |||
170405 | 136402 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1128 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007876.49139 | 2115513.01244 | 37.7892401916349 | -122.416588325105 | (37.7892401916349, -122.416588325105) | 13 | 1 | 10 | 28858 | 21 | |||
73836 | 215019 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 113 Stillings Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 10ft | 6000031.68078 | 2095690.19732 | 37.7343673311927 | -122.442306709796 | (37.7343673311927, -122.442306709796) | 9 | 7 | 4 | 63 | 40 | |||
143516 | 239710 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1132 Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5997732.52597 | 2106583.54789 | 37.7641464813941 | -122.451040872449 | (37.7641464813941, -122.451040872449) | 15 | 5 | 11 | 29492 | 9 | |||
147782 | 240586 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 2 | Width 3ft | Permit Number 37769 | 6003553.87833 | 2108799.61563 | 37.770562824039 | -122.431064686005 | (37.770562824039, -122.431064686005) | 15 | 9 | 11 | 29492 | 10 | |
93783 | 179490 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002435.0144 | 2087009.10974 | 37.7106676924198 | -122.433377477905 | (37.7106676924198, -122.433377477905) | 9 | 7 | 6 | 28861 | 5 | |||
186974 | 179491 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002422.82198 | 2087024.8993 | 37.7107103553801 | -122.433420745181 | (37.7107103553801, -122.433420745181) | 9 | 7 | 6 | 28861 | 5 | |||
186845 | 141832 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1171 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6004383.2413 | 2112546.5688 | 37.7808979992964 | -122.428463024993 | (37.7808979992964, -122.428463024993) | 7 | 9 | 11 | 29490 | 41 | |||
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 | |||
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 | |||
121835 | 46759 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 2 | 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 | |||
147347 | 46758 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1180X Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44858 | 6007776.04474552 | 2115482.02501481 | 37.7891494581332 | -122.416933662921 | (37.7891494581332, -122.416933662921) | 13 | 1 | 10 | 28858 | 21 | |||
188949 | 141831 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1181 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6004346.382 | 2112542.3961 | 37.7808844562183 | -122.42859024189 | (37.7808844562183, -122.42859024189) | 7 | 9 | 11 | 29490 | 41 | |||
187896 | 22636 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1181 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 3X3 | 6004533.51826 | 2112418.26728 | 37.7805542178607 | -122.427933997943 | (37.7805542178607, -122.427933997943) | 7 | 9 | 11 | 29490 | 41 | |||
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 | |||
152092 | 50629 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 2 | 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 | |||
38007 | 217714 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1199 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5996346.1405 | 2091806.7339 | 37.7234935241877 | -122.454768263296 | (37.7234935241877, -122.454768263296) | 9 | 8 | 4 | 28861 | 24 | |||
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 | |||
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 | |||
97645 | 179431 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 121 Blythdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006605.70519 | 2086910.12298 | 37.7106316305231 | -122.418955592547 | (37.7106316305231, -122.418955592547) | 9 | 7 | 8 | 309 | 39 | |||
161000 | 239709 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 121 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999261.27725 | 2107669.14595 | 37.7672146651436 | -122.445831464074 | (37.7672146651436, -122.445831464074) | 15 | 5 | 5 | 29492 | 9 | |||
2071 | 179437 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 121 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6006551.53826 | 2086713.55756 | 37.7100888527847 | -122.419128872099 | (37.7100888527847, -122.419128872099) | 9 | 7 | 8 | 309 | 39 | |||
149071 | 239711 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1210 Shrader St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5997773.63679 | 2106292.89727 | 37.763350781929 | -122.450877723736 | (37.763350781929, -122.450877723736) | 15 | 5 | 11 | 29492 | 9 | |||
1203 | 179432 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6006549.42501 | 2086808.72834 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | 9 | 7 | 8 | 309 | 39 | |||
2724 | 179436 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006488.6944 | 2086721.59328 | 37.7101073779209 | -122.419346642943 | (37.7101073779209, -122.419346642943) | 9 | 7 | 8 | 309 | 39 | |||
50406 | 179433 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006535.42412 | 2086786.75181 | 37.7102889213719 | -122.419189754426 | (37.7102889213719, -122.419189754426) | 9 | 7 | 8 | 309 | 39 | |||
91581 | 179435 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006500.60842 | 2086740.91409 | 37.710161099825 | -122.41930683535 | (37.710161099825, -122.41930683535) | 9 | 7 | 8 | 309 | 39 | |||
186007 | 179434 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 6006514.55403 | 2086760.19323 | 37.7102148217155 | -122.419260003144 | (37.7102148217155, -122.419260003144) | 9 | 7 | 8 | 309 | 39 | |||
127036 | 245017 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1221 Page St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 6000631.5454 | 2109250.0676 | 37.7716336252812 | -122.441205360431 | (37.7716336252812, -122.441205360431) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
176752 | 64740 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1225 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25701 | 6000702.83668032 | 2109256.16819914 | 37.7716544366578 | -122.440959198032 | (37.7716544366578, -122.440959198032) | 15 | 5 | 11 | 29492 | 9 | ||
156932 | 245018 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1227 Page St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 6000617.788 | 2109248.6444 | 37.7716289338677 | -122.441252845835 | (37.7716289338677, -122.441252845835) | 15 | 5 | 11 | 29492 | 9 | |||
85062 | 87200 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 123 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 2 | 3x3 | 5995204.25641 | 2110758.61891 | 37.7754650638757 | -122.460087853041 | (37.7754650638757, -122.460087853041) | 11 | 6 | 2 | 54 | 11 | ||
144377 | 2754 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 123 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3X3 | 5995213.94147 | 2110758.8179 | 37.7754661672939 | -122.460054364765 | (37.7754661672939, -122.460054364765) | 11 | 6 | 2 | 54 | 11 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
20507 | 2755 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 124 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5995208.65957 | 2110814.76075 | 37.7756194677712 | -122.460076689691 | (37.7756194677712, -122.460076689691) | 11 | 6 | 2 | 54 | 11 | |||
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 | ||
137317 | 245128 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1260 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000529.8828 | 2109280.0723 | 37.7717102191807 | -122.441559169968 | (37.7717102191807, -122.441559169968) | 15 | 5 | 11 | 29492 | 9 | |||
174056 | 179446 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 127 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6006032.90525 | 2087456.20206 | 37.712098777304 | -122.420974066009 | (37.712098777304, -122.420974066009) | 9 | 7 | 8 | 309 | 39 | |||
146996 | 5639 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1273 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 106 | 6X6 | 6005219.14783 | 2100952.73682 | 37.7491113654052 | -122.424746185103 | (37.7491113654052, -122.424746185103) | 2 | 4 | 5 | 28859 | 19 | |||
4042 | 197511 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | 6009774.86658 | 2109479.23633 | 37.7727794523332 | -122.409594111377 | (37.7727794523332, -122.409594111377) | 14 | 2 | 9 | 28853 | 34 | ||||
20754 | 197513 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | 6009803.31754 | 2109510.05508 | 37.7728656676608 | -122.409497871353 | (37.7728656676608, -122.409497871353) | 14 | 2 | 9 | 28853 | 34 | ||||
79165 | 197509 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | 6009753.46902 | 2109444.94334 | 37.7726840927246 | -122.40966570733 | (37.7726840927246, -122.40966570733) | 14 | 2 | 9 | 28853 | 34 | ||||
93637 | 197515 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | 6009794.12284 | 2109513.93692 | 37.7728758110884 | -122.409529951052 | (37.7728758110884, -122.409529951052) | 14 | 2 | 9 | 28853 | 34 | ||||
94986 | 197510 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | 6009757.95432 | 2109468.49949 | 37.7727490237764 | -122.409651855072 | (37.7727490237764, -122.409651855072) | 14 | 2 | 9 | 28853 | 34 | ||||
105208 | 197514 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | 6009780.84318 | 2109499.43172 | 37.7728352390743 | -122.409574863193 | (37.7728352390743, -122.409574863193) | 14 | 2 | 9 | 28853 | 34 | ||||
118151 | 197516 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 11 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 6009818.3758 | 2109520.83011 | 37.7728960971219 | -122.409446543433 | (37.7728960971219, -122.409446543433) | 14 | 2 | 9 | 28853 | 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 | |
143552 | 197507 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6009714.36956 | 2109423.21347 | 37.7726222364622 | -122.409799423029 | (37.7726222364622, -122.409799423029) | 14 | 2 | 9 | 28853 | 34 | |||
170927 | 197512 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | 6009788.18393 | 2109495.5877 | 37.7728250956205 | -122.409549199229 | (37.7728250956205, -122.409549199229) | 14 | 2 | 9 | 28853 | 34 | ||||
188249 | 197508 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | 6009725.72224 | 2109430.36659 | 37.7726425134742 | -122.409760657749 | (37.7726425134742, -122.409760657749) | 14 | 2 | 9 | 28853 | 34 | ||||
126956 | 94034 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1300X Lane St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 6015674.4242 | 2095246.7836 | 37.7340289546749 | -122.388193241926 | (37.7340289546749, -122.388193241926) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
16169 | 105247 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1301X COLE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x 5 | 5998246 | 2105821 | 37.7620821004846 | -122.44920998149 | (37.7620821004846, -122.44920998149) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | |||
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 | |||
72102 | 239740 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1314 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2017 12:00:00 AM | 3 | 6x6 | 6003222.89805 | 2100527.56399 | 37.7478309907011 | -122.431618884227 | (37.7478309907011, -122.431618884227) | 2 | 4 | 5 | 63 | 22 | ||
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 | |||
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 | ||
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 | |||
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 | |||
175855 | 10385 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/17/2017 12:00:00 AM | 24 | 3X3 | 5999759.298 | 2108827.6222 | 37.7704239730353 | -122.444192144461 | (37.7704239730353, -122.444192144461) | 15 | 5 | 11 | 29492 | 9 | ||
168629 | 214171 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1337 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994229.27069 | 2106420.50927 | 37.7634976322383 | -122.46314569683 | (37.7634976322383, -122.46314569683) | 1 | 5 | 11 | 56 | 12 | |||
58515 | 22676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1340 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003587.61727 | 2112577.28894 | 37.7809372939052 | -122.431217671135 | (37.7809372939052, -122.431217671135) | 15 | 9 | 11 | 29490 | 41 | |||
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 | |||
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 | |||
134565 | 114875 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1362 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3x3 | 5999587.7 | 2108019.3 | 37.7681947328922 | -122.444727590707 | (37.7681947328922, -122.444727590707) | 15 | 5 | 11 | 29492 | 9 | |||
169518 | 246203 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1362 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999565.7884 | 2108011.1099 | 37.7681709945121 | -122.444802791675 | (37.7681709945121, -122.444802791675) | 15 | 5 | 11 | 29492 | 9 | |||
155923 | 214172 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1370 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5992428.9422 | 2106122.35536 | 37.76257510589 | -122.469350698796 | (37.76257510589, -122.469350698796) | 1 | 8 | 11 | 56 | 12 | |||
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 | |||
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 | ||
43916 | 98255 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1375 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 5x5 | Permit Number 25808 | 6003289 | 2100236 | 37.7470341706262 | -122.431369496968 | (37.7470341706262, -122.431369496968) | 2 | 7 | 5 | 63 | 22 | ||
145601 | 239737 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1375 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6003294.62667 | 2100231.18022 | 37.7470212555198 | -122.431349696436 | (37.7470212555198, -122.431349696436) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | |||
109902 | 62343 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 14 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22485 | 6005822.8575705 | 2099672.01958419 | 37.7456288871148 | -122.422567552448 | (37.7456288871148, -122.422567552448) | 2 | 7 | 5 | 28859 | 22 | ||
121929 | 239680 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 14 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005352.16587 | 2103533.57017 | 37.7562052473857 | -122.424469755997 | (37.7562052473857, -122.424469755997) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
21972 | 197530 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1400 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6013404.894 | 2105708.82045 | 37.7626294689928 | -122.396772970689 | (37.7626294689928, -122.396772970689) | 14 | 3 | 8 | 28856 | 29 | |||
64596 | 52688 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1401@ RIVOLI Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | Permit Number 48758 | 5997782.1418349 | 2105912.5855129 | 37.76230702883 | -122.450820884323 | (37.76230702883, -122.450820884323) | 15 | 5 | 11 | 29492 | 9 | |||
29321 | 701 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1401X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005272.9475237 | 2100137.7446563 | 37.7468766226068 | -122.424502181659 | (37.7468766226068, -122.424502181659) | 2 | 7 | 5 | 28859 | 22 | |||
883 | 240584 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 141 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000210.52128 | 2106191.60222 | 37.7632118519771 | -122.442442087458 | (37.7632118519771, -122.442442087458) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
125228 | 245993 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1419 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999291.5767 | 2108712.9163 | 37.7700823250716 | -122.445801737198 | (37.7700823250716, -122.445801737198) | 15 | 5 | 11 | 29492 | 9 | |||
141318 | 10425 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1419 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 5999323.0709 | 2108716.5502 | 37.7700941010229 | -122.445693060933 | (37.7700941010229, -122.445693060933) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
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 | |||
11285 | 239736 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1449 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003357 | 2099848 | 37.7459726666437 | -122.431106669912 | (37.7459726666437, -122.431106669912) | 2 | 7 | 5 | 63 | 22 | |||
94623 | 239735 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1449 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003316.0935 | 2099809.08635 | 37.7458635007156 | -122.431245341826 | (37.7458635007156, -122.431245341826) | 2 | 7 | 5 | 63 | 22 | |||
102585 | 214200 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 145 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994280.88933 | 2095617.06263 | 37.7338370774039 | -122.462183616499 | (37.7338370774039, -122.462183616499) | 9 | 8 | 4 | 59 | 40 |
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) );