trees
1,069 rows where qSpecies_id = 93 sorted by qAddress descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76658 | 215016 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Rosewood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994826.24251 | 2095308.69182 | 37.7330217520514 | -122.460275845063 | (37.7330217520514, -122.460275845063) | 9 | 8 | 4 | 59 | 40 | |||
39658 | 215015 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Fernwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994765.23071 | 2095304.12361 | 37.7330056991393 | -122.460486446495 | (37.7330056991393, -122.460486446495) | 9 | 8 | 4 | 59 | 40 | |||
20607 | 123755 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 4ft | 5995425.06371 | 2110766.64717 | 37.7754998049095 | -122.459324614731 | (37.7754998049095, -122.459324614731) | 11 | 6 | 2 | 54 | 11 | |||
75705 | 123754 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 4ft | 5995442.56449 | 2110764.47311 | 37.7754948416879 | -122.459263918278 | (37.7754948416879, -122.459263918278) | 11 | 6 | 2 | 54 | 11 | |||
98015 | 123756 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 4 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 16 | Width 4ft | 5995405.24475 | 2110764.0495 | 37.7754915329037 | -122.459392984631 | (37.7754915329037, -122.459392984631) | 11 | 6 | 2 | 54 | 11 | |||
113228 | 123753 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 4ft | 5995463.5723 | 2110766.04178 | 37.7755003566036 | -122.459191361341 | (37.7755003566036, -122.459191361341) | 11 | 6 | 2 | 54 | 11 | |||
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 | ||||
117810 | 240556 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 985 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003810.48686 | 2102527.46633 | 37.7533555422307 | -122.429729650524 | (37.7533555422307, -122.429729650524) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
60334 | 240558 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 983 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003807.25002 | 2102556.49662 | 37.7534350692835 | -122.429742914602 | (37.7534350692835, -122.429742914602) | 2 | 4 | 5 | 28862 | 22 | |||
168390 | 240557 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 983 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003809.26979 | 2102545.95171 | 37.753406229815 | -122.429735177759 | (37.753406229815, -122.429735177759) | 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 | |||
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 | |||
181408 | 197520 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Lafayette St | 5 | : | Tree | Private 2 | 22 | Width 3ft | 6007717.24028 | 2109472.44967 | 37.7726453040621 | -122.416711211162 | (37.7726453040621, -122.416711211162) | 8 | 2 | 9 | 28853 | 19 | |||
41485 | 123746 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 5995436.31203 | 2110822.24381 | 37.7756531053071 | -122.459289731361 | (37.7756531053071, -122.459289731361) | 11 | 6 | 2 | 54 | 11 | |||
81264 | 123747 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 4ft | 5995457.51702 | 2110823.60741 | 37.7756580685065 | -122.459216477329 | (37.7756580685065, -122.459216477329) | 11 | 6 | 2 | 54 | 11 | |||
97689 | 44030 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 96 Lafayette St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52444 | 6007681.41962 | 2109502.84398 | 37.7727267448872 | -122.416837272729 | (37.7727267448872, -122.416837272729) | 8 | 2 | 9 | 28853 | 19 | |
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 | |||
174395 | 65162 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 957 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 14 | 4x12 | Permit Number 27142 | 6000403.82793053 | 2102538.64719816 | 37.7531927484611 | -122.441511357285 | (37.7531927484611, -122.441511357285) | 2 | 4 | 5 | 28862 | 22 |
71403 | 14754 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 950X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
141721 | 98795 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 950@Washington Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | |||
172287 | 24345 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 95 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6006134.19272 | 2108466.72229 | 37.7697946537198 | -122.422115687012 | (37.7697946537198, -122.422115687012) | 8 | 4 | 7 | 28853 | 19 | |||
181312 | 24344 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 95 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6006121.89128 | 2108467.81183 | 37.7697969514995 | -122.422158314852 | (37.7697969514995, -122.422158314852) | 8 | 4 | 7 | 28853 | 19 | |||
67016 | 179457 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 949 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 1ft | 6002045.64816 | 2088406.8974 | 37.714483612097 | -122.434823106621 | (37.714483612097, -122.434823106621) | 9 | 7 | 6 | 28861 | 5 | |||
108178 | 12645 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 944 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5992509.49668 | 2114843.34604 | 37.7865252483142 | -122.469707022996 | (37.7865252483142, -122.469707022996) | 11 | 6 | 1 | 54 | 11 | |||
131098 | 12646 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 944 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 5992487.23998 | 2114843.45413 | 37.7865242586719 | -122.469784032853 | (37.7865242586719, -122.469784032853) | 11 | 6 | 1 | 54 | 11 | |||
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 | |||
141904 | 14751 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 940 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
179654 | 14752 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 940 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
120349 | 71234 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 921 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1989 12:00:00 AM | 6000521.03642361 | 2102545.13668815 | 37.7532172438785 | -122.441106493393 | (37.7532172438785, -122.441106493393) | 2 | 4 | 5 | 28862 | 22 | ||||
126222 | 239725 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 921 Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6000349.32495 | 2102545.17891 | 37.7532075776886 | -122.441700307737 | (37.7532075776886, -122.441700307737) | 2 | 4 | 5 | 28862 | 22 | |||
97960 | 14745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 910 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
3780 | 14742 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004772.182 | 2111961.3352 | 37.7793130940377 | -122.427075791541 | (37.7793130940377, -122.427075791541) | 7 | 9 | 11 | 29490 | 41 | |||
26019 | 14743 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 McAllister St | 3 | 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 | |||
37191 | 14744 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
10308 | 141912 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6004447.1952 | 2111915.047 | 37.7791676154415 | -122.42819675688 | (37.7791676154415, -122.42819675688) | 7 | 9 | 11 | 29490 | 41 | |||
38038 | 141910 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6004551.4043 | 2111926.6796 | 37.7792054513567 | -122.427837083851 | (37.7792054513567, -122.427837083851) | 7 | 9 | 11 | 29490 | 41 | |||
59514 | 141904 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004738.7382 | 2111954.0648 | 37.7792912400822 | -122.427190969626 | (37.7792912400822, -122.427190969626) | 7 | 9 | 11 | 29490 | 41 | |||
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 | |||
96485 | 141902 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004761.5188 | 2111959.3964 | 37.7793071675848 | -122.427112541879 | (37.7793071675848, -122.427112541879) | 7 | 9 | 11 | 29490 | 41 | |||
101602 | 141908 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004604.7205 | 2111934.4347 | 37.7792297609062 | -122.427653193772 | (37.7792297609062, -122.427653193772) | 7 | 9 | 11 | 29490 | 41 | |||
112659 | 141903 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004752.7943 | 2111956.4883 | 37.7792986892944 | -122.427142516377 | (37.7792986892944, -122.427142516377) | 7 | 9 | 11 | 29490 | 41 | |||
159229 | 141911 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004522.3227 | 2111922.8021 | 37.7791931595072 | -122.427937412735 | (37.7791931595072, -122.427937412735) | 7 | 9 | 11 | 29490 | 41 | |||
31319 | 179463 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 90 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6000843.6616 | 2089782.45527 | 37.7181922687385 | -122.439076170523 | (37.7181922687385, -122.439076170523) | 9 | 7 | 6 | 28861 | 5 | |||
167640 | 179462 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 90 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000856.84082 | 2089774.26479 | 37.7181705294179 | -122.43903002902 | (37.7181705294179, -122.43903002902) | 9 | 7 | 6 | 28861 | 5 | |||
165340 | 215013 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 9 Locksley Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994094.36202 | 2104778.03714 | 37.7589800579143 | -122.463493095026 | (37.7589800579143, -122.463493095026) | 1 | 5 | 4 | 56 | 12 | |||
36543 | 136404 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 897 Green St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6008943.49637 | 2119016.81507 | 37.7989207252599 | -122.413144462145 | (37.7989207252599, -122.413144462145) | 3 | 1 | 10 | 308 | 21 | |||
62159 | 136406 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 897 Green St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6008985.36131 | 2119021.64248 | 37.7989363302909 | -122.412999936617 | (37.7989363302909, -122.412999936617) | 3 | 1 | 10 | 308 | 21 | |||
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 | |||
145189 | 136407 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 897 Green St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6009007.21718 | 2119024.81228 | 37.7989462606223 | -122.412924532036 | (37.7989462606223, -122.412924532036) | 3 | 1 | 10 | 308 | 21 | |||
153125 | 136405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 897 Green St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6008967.16736 | 2119019.94772 | 37.7989306555735 | -122.413062774033 | (37.7989306555735, -122.413062774033) | 3 | 1 | 10 | 308 | 21 | |||
32927 | 179473 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 890 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011506.9921 | 2090808.93918 | 37.7216117663527 | -122.402289508352 | (37.7216117663527, -122.402289508352) | 10 | 3 | 7 | 309 | 28 | |||
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 | |
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 | |||
143267 | 116981 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 89 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004230 | 2108988 | 37.7711183708566 | -122.428739406059 | (37.7711183708566, -122.428739406059) | 7 | 9 | 11 | 29492 | 10 | |||||
65438 | 239712 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 88 Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006164.57012 | 2097549.79113 | 37.7398209981319 | -122.421235287575 | (37.7398209981319, -122.421235287575) | 2 | 7 | 7 | 28859 | 2 | |||
173802 | 239715 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 875 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000941.552 | 2099644.41912 | 37.745276511409 | -122.439444352976 | (37.745276511409, -122.439444352976) | 2 | 4 | 5 | 63 | 22 | |||
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 | |||
49397 | 240526 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 872 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999192.4287 | 2107247.1158 | 37.766051945173 | -122.446039241644 | (37.766051945173, -122.446039241644) | 15 | 5 | 5 | 29492 | 9 | |||
129814 | 47778 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 872 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | Permit Number 45554 | 5999190.57637215 | 2107256.51251673 | 37.7660776404196 | -122.446046324392 | (37.7660776404196, -122.446046324392) | 15 | 5 | 5 | 29492 | 9 | |||
70824 | 240525 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 870 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5999190.09937 | 2107262.31066 | 37.7660935334247 | -122.446048391324 | (37.7660935334247, -122.446048391324) | 15 | 5 | 5 | 29492 | 9 | |||
118409 | 124347 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 850 Balboa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 5992970.95796 | 2111419.69143 | 37.7771514865391 | -122.467861389315 | (37.7771514865391, -122.467861389315) | 11 | 6 | 2 | 54 | 11 | |||
110275 | 51012 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 85 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2016 12:00:00 AM | 3 | Permit Number 778086 | 6001486.35916374 | 2107715.14620283 | 37.7674677672856 | -122.438138542404 | (37.7674677672856, -122.438138542404) | 15 | 5 | 5 | 29492 | 3 | ||
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 | ||
187655 | 136409 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 842 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006660.27823 | 2121526.69808 | 37.8056837844424 | -122.421223486682 | (37.8056837844424, -122.421223486682) | 5 | 1 | 1 | 28858 | 32 | |||
37678 | 240590 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 84 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004278.14417 | 2097692.06256 | 37.7401051119636 | -122.427767890078 | (37.7401051119636, -122.427767890078) | 2 | 7 | 5 | 63 | 7 | |||
135321 | 34446 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 84 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38190 | 6004274.31729793 | 2097673.91474862 | 37.7400550657314 | -122.427779829106 | (37.7400550657314, -122.427779829106) | 2 | 7 | 5 | 63 | 7 | ||
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 | ||
113094 | 247472 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 838 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002550.7646 | 2109563.4235 | 37.772603159446 | -122.434589085205 | (37.772603159446, -122.434589085205) | 15 | 5 | 11 | 29492 | 9 | |||
128574 | 239716 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 833 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001151.75386 | 2099655.0922 | 37.7453177777039 | -122.438718276345 | (37.7453177777039, -122.438718276345) | 2 | 4 | 5 | 63 | 22 | |||
54243 | 215017 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 832 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999463.89862 | 2095685.88724 | 37.7343231196096 | -122.444269401028 | (37.7343231196096, -122.444269401028) | 9 | 7 | 4 | 63 | 40 | |||
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 | ||
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 | |||
178006 | 5514 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 827 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X5 | 6005075.88619 | 2103522.47666 | 37.7561591814037 | -122.425424436705 | (37.7561591814037, -122.425424436705) | 2 | 4 | 5 | 28859 | 19 | |||
175032 | 239717 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 819 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001263.11303 | 2099661.60656 | 37.7453419991489 | -122.438333682174 | (37.7453419991489, -122.438333682174) | 2 | 4 | 5 | 63 | 22 | |||
50109 | 197570 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011756.09586 | 2113120.18338 | 37.7828874706141 | -122.402996914199 | (37.7828874706141, -122.402996914199) | 6 | 2 | 9 | 28853 | 34 | |||
96924 | 197573 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011805.47785 | 2113169.35516 | 37.7830252422689 | -122.402829531459 | (37.7830252422689, -122.402829531459) | 6 | 2 | 9 | 28853 | 34 | |||
106282 | 197571 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011772.19211 | 2113135.08358 | 37.7829292819051 | -122.402942275888 | (37.7829292819051, -122.402942275888) | 6 | 2 | 9 | 28853 | 34 | |||
130739 | 197574 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011821.05226 | 2113183.26768 | 37.7830643124058 | -122.402776628832 | (37.7830643124058, -122.402776628832) | 6 | 2 | 9 | 28853 | 34 | |||
141730 | 197572 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011789.60702 | 2113153.20247 | 37.7829800045728 | -122.40288330192 | (37.7829800045728, -122.40288330192) | 6 | 2 | 9 | 28853 | 34 | |||
153856 | 86882 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49807 | 6011833 | 2113224.2 | 37.7831773700909 | -122.402738173851 | (37.7831773700909, -122.402738173851) | 6 | 2 | 9 | 28853 | 34 | |||
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 | |||
187563 | 214202 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 80 El Verano Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5994588.98117 | 2094805.70057 | 37.7316270105613 | -122.461059668986 | (37.7316270105613, -122.461059668986) | 9 | 8 | 4 | 59 | 40 | |||
169326 | 240582 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 8 Sharon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | 15 | Width 3ft | Permit Number 9985 | 6003834.4345 | 2107034.98465 | 37.7657334691548 | -122.429968344076 | (37.7657334691548, -122.429968344076) | 8 | 4 | 5 | 28862 | 3 | |
158647 | 69407 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 795 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 12 | Permit Number 33511 | 6002413.58939 | 2087078.56796 | 37.7108571939861 | -122.43345648782 | (37.7108571939861, -122.43345648782) | 9 | 7 | 6 | 28861 | 5 | |
10705 | 72398 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 791 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5990047.51543 | 2110000.36847 | 37.7730851702984 | -122.477870609559 | (37.7730851702984, -122.477870609559) | 11 | 6 | 2 | 55 | 26 | |||
69697 | 69405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 11 | Permit Number 33509 | 6002439.0824 | 2087100.62464 | 37.7109192031396 | -122.43336995327 | (37.7109192031396, -122.43336995327) | 9 | 7 | 6 | 28861 | 5 | |
156434 | 179492 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6002448.84708 | 2087107.83027 | 37.7109395422009 | -122.433336718839 | (37.7109395422009, -122.433336718839) | 9 | 7 | 6 | 28861 | 5 | |||
180689 | 179493 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6002457.74986 | 2087117.22162 | 37.710965833866 | -122.433306619399 | (37.710965833866, -122.433306619399) | 9 | 7 | 6 | 28861 | 5 | |||
146534 | 104774 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 781 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | Permit Number 778365 | 6002484.5 | 2103704 | 37.7565108482623 | -122.434399295862 | (37.7565108482623, -122.434399295862) | 2 | 4 | 5 | 28862 | 3 | ||
20265 | 240589 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 78 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004277.11991 | 2097713.84146 | 37.7401648539148 | -122.42777298294 | (37.7401648539148, -122.42777298294) | 2 | 7 | 5 | 63 | 7 | |||
25848 | 34445 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 78 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38189 | 6004271.49317697 | 2097724.19157363 | 37.7401929546681 | -122.427793175192 | (37.7401929546681, -122.427793175192) | 2 | 7 | 5 | 63 | 7 | ||
123099 | 240539 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 78 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6005465.00298 | 2099647.78115 | 37.7455421387592 | -122.423803237831 | (37.7455421387592, -122.423803237831) | 2 | 7 | 5 | 28859 | 22 | |||
79942 | 35125 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 766 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 5 | Permit Number 38660 | 6001731.36417 | 2089519.53162 | 37.7175208097275 | -122.43598896344 | (37.7175208097275, -122.43598896344) | 9 | 7 | 6 | 28861 | 5 | |
172022 | 35126 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 766 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 7 | Permit Number 38660 | 6001721.91154 | 2089504.55342 | 37.7174791459225 | -122.43602056561 | (37.7174791459225, -122.43602056561) | 9 | 7 | 6 | 28861 | 5 | |
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 | |||
167813 | 5499 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 761 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 5X5 | 6005058.9801366 | 2103927.2718726 | 37.7572696989713 | -122.42551171102 | (37.7572696989713, -122.42551171102) | 2 | 4 | 5 | 28859 | 19 | |||
66788 | 179470 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 755 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6002483.16702 | 2089112.03412 | 37.7164445928267 | -122.43336122534 | (37.7164445928267, -122.43336122534) | 9 | 7 | 6 | 28861 | 5 | |||
20431 | 248436 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 755 Ashbury St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5999049.7676 | 2107927.8319 | 37.7679128724009 | -122.446581655831 | (37.7679128724009, -122.446581655831) | 15 | 5 | 11 | 29492 | 9 | |||
129821 | 35123 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 752 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 9 | Permit Number 38658 | 6001767.50485 | 2089578.0778 | 37.7176836175692 | -122.435868228557 | (37.7176836175692, -122.435868228557) | 9 | 7 | 6 | 28861 | 5 |
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) );