trees
668 rows where qLegalStatus_id = 1 and qSpecies_id = 5 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12712 | 19967 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 STAIRWAY41 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
13041 | 19762 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 STAIRWAY16 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
9018 | 126003 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6007892.37102 | 2121599.81603 | 37.8059539308952 | -122.416964822665 | (37.8059539308952, -122.416964822665) | 5 | 1 | 10 | 308 | 23 | |||
19339 | 21778 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5X5 | 6008409.45282 | 2121407.87429 | 37.8054559800011 | -122.415161778523 | (37.8054559800011, -122.415161778523) | 5 | 1 | 10 | 308 | 23 | |||
23100 | 125989 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008326.45195 | 2121634.40634 | 37.8060733149832 | -122.41546506288 | (37.8060733149832, -122.41546506288) | 5 | 1 | 10 | 308 | 23 | |||
34503 | 21789 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/2015 12:00:00 AM | 3 | 4X4 | 6008161.90241 | 2121549.79462 | 37.8058317424248 | -122.41602851934 | (37.8058317424248, -122.41602851934) | 5 | 1 | 10 | 308 | 23 | ||
36850 | 21792 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2598 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.415074380155 | (37.8060518410095, -122.415074380155) | 3 | 1 | 10 | 308 | 23 | |||
37876 | 125979 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008389.02756 | 2121512.5692 | 37.8057422979318 | -122.41523987894 | (37.8057422979318, -122.41523987894) | 5 | 1 | 10 | 308 | 23 | |||
38272 | 125985 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6008371.27829 | 2121652.4837 | 37.8061254702907 | -122.415311214049 | (37.8061254702907, -122.415311214049) | 5 | 1 | 10 | 308 | 23 | |||
49612 | 125976 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007074.37921 | 2121877.42075 | 37.8066701158897 | -122.419815329109 | (37.8066701158897, -122.419815329109) | 5 | 1 | 1 | 28858 | 32 | |||
55436 | 126001 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007899.07258 | 2121560.79928 | 37.8058471777553 | -122.41693886466 | (37.8058471777553, -122.41693886466) | 5 | 1 | 10 | 308 | 23 | |||
59975 | 125986 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 6ft | 6008368.52895 | 2121668.47116 | 37.8061692132974 | -122.415321861121 | (37.8061692132974, -122.415321861121) | 5 | 1 | 10 | 308 | 23 | |||
67416 | 125984 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 6ft | 6008373.73288 | 2121637.11508 | 37.8060834098955 | -122.41530163086 | (37.8060834098955, -122.41530163086) | 5 | 1 | 10 | 308 | 23 | |||
67782 | 125998 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6007907.02571 | 2121498.39071 | 37.8056762669961 | -122.416906917118 | (37.8056762669961, -122.416906917118) | 5 | 1 | 10 | 308 | 23 | |||
69120 | 125994 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008347.52133 | 2121476.34798 | 37.8056405108592 | -122.415380951989 | (37.8056405108592, -122.415380951989) | 5 | 1 | 10 | 308 | 23 | |||
71054 | 21785 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008161.90241 | 2121549.79462 | 37.8058317424248 | -122.41602851934 | (37.8058317424248, -122.41602851934) | 5 | 1 | 10 | 308 | 23 | |||
75395 | 125996 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007913.10752 | 2121457.27998 | 37.8055637294392 | -122.41688295558 | (37.8055637294392, -122.41688295558) | 5 | 1 | 10 | 308 | 23 | |||
77396 | 125972 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006913.21617 | 2121857.59743 | 37.8066066057793 | -122.420371657826 | (37.8066066057793, -122.420371657826) | 5 | 1 | 1 | 28858 | 32 | |||
79309 | 125987 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6008367.52131 | 2121686.8739 | 37.8062196859398 | -122.415326651828 | (37.8062196859398, -122.415326651828) | 5 | 1 | 10 | 308 | 23 | |||
84314 | 125975 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007035.47478 | 2121873.14157 | 37.8066561746197 | -122.419949661756 | (37.8066561746197, -122.419949661756) | 5 | 1 | 1 | 28858 | 32 | |||
85002 | 125991 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008338.82398 | 2121554.95666 | 37.8058558616148 | -122.415416619107 | (37.8058558616148, -122.415416619107) | 5 | 1 | 10 | 308 | 23 | |||
85699 | 11179 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2750X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3x3 | 6006893.59102 | 2121789.4662 | 37.8064184289444 | -122.4204347354 | (37.8064184289444, -122.4204347354) | 5 | 1 | 1 | 28858 | 32 | |||
87824 | 125999 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007905.9664 | 2121521.7786 | 37.8057404246312 | -122.416912241104 | (37.8057404246312, -122.416912241104) | 5 | 1 | 10 | 308 | 23 | |||
95994 | 11181 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2750X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6006890.68476 | 2121823.94924 | 37.8065129467732 | -122.420447242256 | (37.8065129467732, -122.420447242256) | 5 | 1 | 1 | 28858 | 32 | |||
98799 | 126000 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6007902.73328 | 2121542.33791 | 37.8057966934257 | -122.416924887385 | (37.8057966934257, -122.416924887385) | 5 | 1 | 10 | 308 | 23 | |||
99094 | 21776 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008409.45282 | 2121407.87429 | 37.8054559800011 | -122.415161778523 | (37.8054559800011, -122.415161778523) | 5 | 1 | 10 | 308 | 23 | |||
100104 | 21793 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2598 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.415074380155 | (37.8060518410095, -122.415074380155) | 3 | 1 | 10 | 308 | 23 | |||
107672 | 125981 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 6ft | 6008384.91577 | 2121552.17509 | 37.8058508146246 | -122.415256913874 | (37.8058508146246, -122.415256913874) | 5 | 1 | 10 | 308 | 23 | |||
112246 | 125993 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008342.47163 | 2121500.19485 | 37.8057057045282 | -122.415400116539 | (37.8057057045282, -122.415400116539) | 5 | 1 | 10 | 308 | 23 | |||
122903 | 125992 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008341.11218 | 2121531.47257 | 37.8057915088426 | -122.415407036818 | (37.8057915088426, -122.415407036818) | 5 | 1 | 10 | 308 | 23 | |||
124920 | 125982 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 6ft | 6008379.56749 | 2121591.49972 | 37.8059584895516 | -122.415278208017 | (37.8059584895516, -122.415278208017) | 5 | 1 | 10 | 308 | 23 | |||
125848 | 125983 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6008377.32314 | 2121617.1276 | 37.8060287311026 | -122.415287790321 | (37.8060287311026, -122.415287790321) | 5 | 1 | 10 | 308 | 23 | |||
126551 | 125995 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008349.66203 | 2121453.17315 | 37.8055769989413 | -122.415371902112 | (37.8055769989413, -122.415371902112) | 5 | 1 | 10 | 308 | 23 | |||
131190 | 126002 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007897.34981 | 2121579.98706 | 37.8058997656297 | -122.416946186927 | (37.8058997656297, -122.416946186927) | 5 | 1 | 10 | 308 | 23 | |||
135227 | 21781 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2011 12:00:00 AM | 3 | 4x4 | 6008458.56586 | 2121488.77145 | 37.8056808631332 | -122.41499754514 | (37.8056808631332, -122.41499754514) | 3 | 1 | 10 | 308 | 23 | ||
140473 | 11180 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2750X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006892.18437 | 2121805.14198 | 37.806461391357 | -122.420440716763 | (37.806461391357, -122.420440716763) | 5 | 1 | 1 | 28858 | 32 | |||
142913 | 21795 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2598 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.415074380155 | (37.8060518410095, -122.415074380155) | 3 | 1 | 10 | 308 | 23 | |||
144028 | 125988 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008319.39655 | 2121673.00017 | 37.806178887323 | -122.415492213411 | (37.806178887323, -122.415492213411) | 5 | 1 | 10 | 308 | 23 | |||
145684 | 21794 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2598 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.415074380155 | (37.8060518410095, -122.415074380155) | 3 | 1 | 10 | 308 | 23 | |||
146048 | 125974 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007013.05823 | 2121870.81717 | 37.8066485294743 | -122.420027073604 | (37.8066485294743, -122.420027073604) | 5 | 1 | 1 | 28858 | 32 | |||
152398 | 125977 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008401.62888 | 2121444.29683 | 37.8055555474172 | -122.415191434251 | (37.8055555474172, -122.415191434251) | 5 | 1 | 10 | 308 | 23 | |||
154655 | 125978 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008392.85025 | 2121496.40648 | 37.8056981340166 | -122.415225505068 | (37.8056981340166, -122.415225505068) | 5 | 1 | 10 | 308 | 23 | |||
167066 | 125973 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006932.43872 | 2121860.17562 | 37.8066147680158 | -122.420305317544 | (37.8066147680158, -122.420305317544) | 5 | 1 | 1 | 28858 | 32 | |||
176301 | 21784 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550X Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2016 12:00:00 AM | 12 | 4X4 | 6008458.56586 | 2121488.77145 | 37.8056808631332 | -122.41499754514 | (37.8056808631332, -122.41499754514) | 3 | 1 | 10 | 308 | 23 | ||
178863 | 125997 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6007910.60432 | 2121475.90892 | 37.8056147389887 | -122.416892938958 | (37.8056147389887, -122.416892938958) | 5 | 1 | 10 | 308 | 23 | |||
188712 | 125990 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008335.58159 | 2121584.43449 | 37.8059366180507 | -122.415429928145 | (37.8059366180507, -122.415429928145) | 5 | 1 | 10 | 308 | 23 | |||
192924 | 125980 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008387.31056 | 2121533.89692 | 37.8058007619722 | -122.415247331605 | (37.8058007619722, -122.415247331605) | 5 | 1 | 10 | 308 | 23 | |||
75940 | 51298 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2004 12:00:00 AM | 7 | Permit Number 47670 | 6008009.38054 | 2112753.19289 | 37.7816698695126 | -122.415933029587 | (37.7816698695126, -122.415933029587) | 7 | 10 | 9 | 28852 | 36 | |
153705 | 51299 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2004 12:00:00 AM | 10 | Permit Number 47670 | 6008033.00976 | 2112757.64367 | 37.7816834187084 | -122.415851598691 | (37.7816834187084, -122.415851598691) | 7 | 10 | 9 | 28852 | 36 | |
167516 | 51302 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2004 12:00:00 AM | 12 | Permit Number 47670 | 6008052.8861 | 2112760.32075 | 37.7816918867218 | -122.415783025366 | (37.7816918867218, -122.415783025366) | 7 | 10 | 9 | 28852 | 36 | |
187721 | 125971 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008148.4886 | 2112831.14919 | 37.7818917385495 | -122.415457300812 | (37.7818917385495, -122.415457300812) | 7 | 10 | 9 | 28852 | 36 | |||
1800 | 189943 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014663.90287 | 2116268.03372 | 37.7916926905231 | -122.393157367813 | (37.7916926905231, -122.393157367813) | 12 | 2 | 9 | 28855 | 6 | |||
6962 | 189948 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6014781.22378 | 2116142.62721 | 37.7913548700732 | -122.392742658052 | (37.7913548700732, -122.392742658052) | 12 | 2 | 9 | 28855 | 6 | |||
9688 | 52724 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160@ HOWARD Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2006 12:00:00 AM | 7 | Permit Number 48777 | 6014638.31432 | 2116297.63809 | 37.791772555711 | -122.393247977227 | (37.791772555711, -122.393247977227) | 12 | 2 | 9 | 28855 | 6 | ||
12741 | 188474 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6007923.25888 | 2109012.80714 | 37.7713948192467 | -122.415966013116 | (37.7713948192467, -122.415966013116) | 8 | 2 | 9 | 28853 | 19 | |||
16430 | 119738 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6013480.63892 | 2116044.41356 | 37.7910128776808 | -122.397235794198 | (37.7910128776808, -122.397235794198) | 12 | 2 | 9 | 28855 | 6 | ||||
17034 | 96473 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Permit Number 767637 | 6014754.27658 | 2116074.97331 | 37.7911676114441 | -122.392831160352 | (37.7911676114441, -122.392831160352) | 12 | 2 | 9 | 28855 | 6 | ||
23322 | 189937 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013275.69539 | 2116164.65668 | 37.7913316253015 | -122.397953334494 | (37.7913316253015, -122.397953334494) | 12 | 2 | 9 | 28855 | 6 | |||
26958 | 188469 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6008084.26268 | 2108917.74209 | 37.771142843604 | -122.415402360325 | (37.771142843604, -122.415402360325) | 8 | 2 | 9 | 28853 | 19 | |||
34204 | 189929 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013297.80377 | 2116238.25932 | 37.7915349521343 | -122.397882004744 | (37.7915349521343, -122.397882004744) | 12 | 2 | 9 | 28855 | 6 | |||
35126 | 15121 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6013826.37134 | 2116069.93693 | 37.7911022004845 | -122.396041353962 | (37.7911022004845, -122.396041353962) | 12 | 2 | 9 | 28855 | 6 | |||
38377 | 189958 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010386.69691 | 2108550.07878 | 37.7702624648584 | -122.407412194212 | (37.7702624648584, -122.407412194212) | 8 | 2 | 9 | 28853 | 34 | |||
38483 | 189924 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6013405.38871 | 2116121.70148 | 37.7912209025705 | -122.397501581628 | (37.7912209025705, -122.397501581628) | 12 | 2 | 9 | 28855 | 6 | |||
47459 | 189921 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013437.41222 | 2116091.23603 | 37.7911390345977 | -122.397388642991 | (37.7911390345977, -122.397388642991) | 12 | 2 | 9 | 28855 | 6 | |||
52787 | 222885 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Valencia St | 3 | : | Tree | Private 2 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | 8 | 2 | 9 | 28853 | 19 | |||
53007 | 106030 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6014615.46906 | 2115943.46238 | 37.790798802166 | -122.393302227016 | (37.790798802166, -122.393302227016) | 12 | 2 | 9 | 28855 | 6 | |||
60278 | 189935 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013248.49941 | 2116191.11402 | 37.791402756277 | -122.398049289468 | (37.791402756277, -122.398049289468) | 12 | 2 | 9 | 28855 | 6 | |||
60927 | 189962 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010439.90597 | 2108494.60457 | 37.7701131234445 | -122.407224232334 | (37.7701131234445, -122.407224232334) | 8 | 2 | 9 | 28853 | 34 | |||
62178 | 189960 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010412.08756 | 2108524.30899 | 37.7701931280454 | -122.407322550708 | (37.7701931280454, -122.407322550708) | 8 | 2 | 9 | 28853 | 34 | |||
62483 | 119737 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6013490.74423 | 2116034.43287 | 37.7909860356216 | -122.397200129801 | (37.7909860356216, -122.397200129801) | 12 | 2 | 9 | 28855 | 6 | ||||
62803 | 189959 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010397.61848 | 2108539.03358 | 37.7702327485634 | -122.40737363759 | (37.7702327485634, -122.40737363759) | 8 | 2 | 9 | 28853 | 34 | |||
63341 | 189955 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 145 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6014561.09202 | 2115949.59191 | 37.790812611275 | -122.393490799583 | (37.790812611275, -122.393490799583) | 12 | 2 | 9 | 28855 | 6 | |||
67119 | 189932 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013255.69526 | 2116279.68267 | 37.7916463457648 | -122.398030607826 | (37.7916463457648, -122.398030607826) | 12 | 2 | 9 | 28855 | 6 | |||
68954 | 7418 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1090 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010342.8854 | 2110986.7114 | 37.7769504410171 | -122.407735574616 | (37.7769504410171, -122.407735574616) | 14 | 2 | 9 | 28853 | 34 | |||
69631 | 189954 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 145 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6014570.20304 | 2115942.2831 | 37.7907930492013 | -122.393458763924 | (37.7907930492013, -122.393458763924) | 12 | 2 | 9 | 28855 | 6 | |||
71028 | 189931 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013267.71842 | 2116267.46362 | 37.7916134647515 | -122.397988149957 | (37.7916134647515, -122.397988149957) | 12 | 2 | 9 | 28855 | 6 | |||
71893 | 189957 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 572 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011483.58307 | 2109635.35024 | 37.7733037049339 | -122.403694422077 | (37.7733037049339, -122.403694422077) | 14 | 2 | 9 | 28853 | 34 | |||
72220 | 189941 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013331.4553 | 2116106.58194 | 37.7911752709767 | -122.397756329903 | (37.7911752709767, -122.397756329903) | 12 | 2 | 9 | 28855 | 6 | |||
72975 | 15123 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 2X2 | 6013765.88916 | 2116013.74101 | 37.7909445343765 | -122.396246681474 | (37.7909445343765, -122.396246681474) | 12 | 2 | 9 | 28855 | 6 | |||
73221 | 189956 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 572 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011467.9689 | 2109652.48068 | 37.7733498689462 | -122.403749639528 | (37.7733498689462, -122.403749639528) | 14 | 2 | 9 | 28853 | 34 | |||
76472 | 225100 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 75 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6006056.75092 | 2109200.3154 | 37.7718045566698 | -122.422435689168 | (37.7718045566698, -122.422435689168) | 8 | 2 | 9 | 28853 | 19 | |||
80002 | 189928 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013312.71119 | 2116223.04908 | 37.7914940185848 | -122.397829357532 | (37.7914940185848, -122.397829357532) | 12 | 2 | 9 | 28855 | 6 | |||
80077 | 106029 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 14 | 3x3 | Permit Number 770222 | 6014636.89755 | 2115962.51686 | 37.7908523118267 | -122.393229418798 | (37.7908523118267, -122.393229418798) | 12 | 2 | 9 | 28855 | 6 | |
86068 | 188467 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6008105.35323 | 2108904.54782 | 37.77110780062 | -122.415328472924 | (37.77110780062, -122.415328472924) | 8 | 2 | 9 | 28853 | 19 | |||
88181 | 85254 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Permit Number 49553 | 6013520.55509 | 2116003.76772 | 37.7909034958536 | -122.397094833572 | (37.7909034958536, -122.397094833572) | 12 | 2 | 9 | 28855 | 6 | |||
88195 | 189918 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 338 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6013810.73123 | 2116050.81938 | 37.7910488379738 | -122.396094128247 | (37.7910488379738, -122.396094128247) | 12 | 2 | 9 | 28855 | 6 | |||
89800 | 188471 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6008055.90153 | 2108933.51614 | 37.7711845613454 | -122.415501579828 | (37.7711845613454, -122.415501579828) | 8 | 2 | 9 | 28853 | 19 | |||
92390 | 189934 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013232.87553 | 2116207.31651 | 37.7914463743094 | -122.398104485334 | (37.7914463743094, -122.398104485334) | 12 | 2 | 9 | 28855 | 6 | |||
93762 | 15124 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 2X2 | 6013752.67684 | 2116000.07901 | 37.7909062865319 | -122.396291437927 | (37.7909062865319, -122.396291437927) | 12 | 2 | 9 | 28855 | 6 | |||
95233 | 15122 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2X2 | 6013811.40838 | 2116056.32171 | 37.7910639837629 | -122.396092171091 | (37.7910639837629, -122.396092171091) | 12 | 2 | 9 | 28855 | 6 | |||
98740 | 189925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013397.06496 | 2116134.82312 | 37.7912564680486 | -122.397531302439 | (37.7912564680486, -122.397531302439) | 12 | 2 | 9 | 28855 | 6 | |||
98842 | 22886 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 95X Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6006042.93395 | 2109155.55847 | 37.7716808854236 | -122.422480302267 | (37.7716808854236, -122.422480302267) | 8 | 2 | 9 | 28853 | 19 | |||
99086 | 7417 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1090 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2003 12:00:00 AM | 6 | 3X3 | 6010360.059 | 2111002.9309 | 37.7769959373466 | -122.407677309481 | (37.7769959373466, -122.407677309481) | 14 | 2 | 9 | 28853 | 34 | ||
104489 | 189953 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014700.62775 | 2116023.46282 | 37.7910231956157 | -122.393013179512 | (37.7910231956157, -122.393013179512) | 12 | 2 | 9 | 28855 | 6 | |||
107019 | 225101 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 75 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6006050.3801 | 2109334.27291 | 37.7721720124675 | -122.422467246366 | (37.7721720124675, -122.422467246366) | 8 | 2 | 9 | 28853 | 19 | |||
107370 | 189952 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 6014715.63981 | 2116037.408 | 37.7910623197318 | -122.392962214036 | (37.7910623197318, -122.392962214036) | 12 | 2 | 9 | 28855 | 6 | |||
107461 | 85255 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Permit Number 49553 | 6013503.0525 | 2116024.16318 | 37.7909585226636 | -122.39715682295 | (37.7909585226636, -122.39715682295) | 12 | 2 | 9 | 28855 | 6 | |||
108171 | 188473 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6007942.65601 | 2109006.33264 | 37.7713781323189 | -122.415898458759 | (37.7713781323189, -122.415898458759) | 8 | 2 | 9 | 28853 | 19 | |||
109981 | 189920 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 338 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6013751.03466 | 2115995.67684 | 37.7908941078228 | -122.396296811166 | (37.7908941078228, -122.396296811166) | 12 | 2 | 9 | 28855 | 6 | |||
111186 | 189933 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013208.14765 | 2116234.45684 | 37.7915195179644 | -122.398191948892 | (37.7915195179644, -122.398191948892) | 12 | 2 | 9 | 28855 | 6 |
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) );