trees
858 rows where qSpecies_id = 85 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17041 | 197764 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 9 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015565.1078 | 2103547.12613 | 37.7568139175333 | -122.389150557161 | (37.7568139175333, -122.389150557161) | 10 | 3 | 8 | 28856 | 29 | |||
35774 | 136578 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Jefferson St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008572.42572 | 2122428.93464 | 37.808268711206 | -122.414670090059 | (37.808268711206, -122.414670090059) | 3 | 1 | 10 | 308 | 23 | |||
48698 | 108284 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1 HENRY ADAMS ST | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | |||
110441 | 51820 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 13 | Permit Number 48062 | 6008882.21436 | 2109841.08005 | 37.7737229301921 | -122.412707492378 | (37.7737229301921, -122.412707492378) | 8 | 2 | 9 | 28853 | 34 | ||
127738 | 51712 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | Permit Number 47987 | 6012686.20544956 | 2110082.45661085 | 37.7745984647237 | -122.399565756547 | (37.7745984647237, -122.399565756547) | 14 | 2 | 9 | 28856 | 20 | |||
168748 | 215150 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 484 Faxon Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994798.27726 | 2091789.17136 | 37.7233563935592 | -122.460117638123 | (37.7233563935592, -122.460117638123) | 9 | 8 | 4 | 28861 | 24 | |||
38658 | 179604 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998666.20237 | 2089602.87221 | 37.7175750361301 | -122.446589774218 | (37.7175750361301, -122.446589774218) | 9 | 7 | 6 | 28861 | 25 | |||
45093 | 136531 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2200 Beach St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5999585.07501 | 2120878.20565 | 37.8035017881435 | -122.445661503881 | (37.8035017881435, -122.445661503881) | 13 | 9 | 1 | 57 | 17 | |||
79636 | 51823 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 13 | Permit Number 48062 | 6008893.04946 | 2109829.84045 | 37.7736926770172 | -122.412669217211 | (37.7736926770172, -122.412669217211) | 8 | 2 | 9 | 28853 | 34 | ||
94951 | 40575 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 16 | Permit Number 42197 | 6011865.56753 | 2107924.68372 | 37.7686279344547 | -122.402252780039 | (37.7686279344547, -122.402252780039) | 8 | 2 | 8 | 28853 | 20 | |
99543 | 136577 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Jefferson St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6008571.571 | 2122426.85002 | 37.8082629393464 | -122.414672900433 | (37.8082629393464, -122.414672900433) | 3 | 1 | 10 | 308 | 23 | |||
128451 | 240863 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1706 Dolores St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6005261.4426 | 2098375.64329 | 37.7420376444291 | -122.424416651004 | (37.7420376444291, -122.424416651004) | 2 | 7 | 5 | 63 | 7 | |||
174603 | 179628 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6010332.78013 | 2091733.53575 | 37.7240849010885 | -122.406413580748 | (37.7240849010885, -122.406413580748) | 10 | 3 | 7 | 309 | 28 | |||
190305 | 51716 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 15 | Permit Number 47987 | 6012715.82138 | 2110122.77746 | 37.7747108273731 | -122.399466139876 | (37.7747108273731, -122.399466139876) | 14 | 2 | 9 | 28856 | 20 | ||
59868 | 184889 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1201 Sunset Blvd | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984679.4382 | 2106701.786 | 37.7637151826251 | -122.496195774698 | (37.7637151826251, -122.496195774698) | 1 | 8 | 3 | 56 | 35 | |||
849 | 51822 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 11 | Permit Number 48062 | 6008911.92726 | 2109811.9687 | 37.7736446648878 | -122.412602652111 | (37.7736446648878, -122.412602652111) | 8 | 2 | 9 | 28853 | 34 | ||
3332 | 259568 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 200 Public Park | 7 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
11004 | 51713 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2019 12:00:00 AM | 3 | Permit Number 47987 | 6012693.61148 | 2110101.74925 | 37.7746518507372 | -122.399541492249 | (37.7746518507372, -122.399541492249) | 14 | 2 | 9 | 28856 | 20 | ||
23221 | 131948 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2101 Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | |||
34040 | 215141 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 600 Portola Dr | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997116.2143 | 2099688.39867 | 37.7451788225419 | -122.452674834471 | (37.7451788225419, -122.452674834471) | 1 | 7 | 4 | 59 | 40 | |||
42424 | 197761 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 7 | : | Tree | Private 2 | 7 | Width 3ft | 6010003.68567 | 2109694.36237 | 37.773382957679 | -122.408817777045 | (37.773382957679, -122.408817777045) | 14 | 2 | 9 | 28853 | 34 | |||
53722 | 240870 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1720 Dolores St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005279.68731 | 2098305.03098 | 37.7418447893069 | -122.424348545374 | (37.7418447893069, -122.424348545374) | 2 | 7 | 5 | 63 | 7 | |||
103161 | 179627 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6010336.72583 | 2091718.34914 | 37.7240434225456 | -122.406398871428 | (37.7240434225456, -122.406398871428) | 10 | 3 | 7 | 309 | 28 | |||
129206 | 40576 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 16 | Permit Number 42197 | 6011845.30553 | 2107921.74272 | 37.7686187280976 | -122.402322658262 | (37.7686187280976, -122.402322658262) | 8 | 2 | 8 | 28853 | 20 | |
158223 | 179567 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5998654.86652 | 2088353.61348 | 37.7141442097611 | -122.446539128875 | (37.7141442097611, -122.446539128875) | 9 | 7 | 6 | 28861 | 25 | |||
18467 | 51710 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2019 12:00:00 AM | 3 | Permit Number 47987 | 6012671.60652 | 2110080.29176 | 37.7745917067712 | -122.399616105424 | (37.7745917067712, -122.399616105424) | 14 | 2 | 9 | 28856 | 20 | ||
22653 | 247213 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 800 Duboce Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6001852.54114 | 2108296.01305 | 37.7690835031293 | -122.436913559108 | (37.7690835031293, -122.436913559108) | 15 | 5 | 5 | 29492 | 9 | |||
58591 | 240869 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1720 Dolores St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005279.8956 | 2098315.15915 | 37.7418726107263 | -122.424348545375 | (37.7418726107263, -122.424348545375) | 2 | 7 | 5 | 63 | 7 | |||
70886 | 246457 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 405 Duncan St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6003845.17231 | 2099806.01088 | 37.7458850250928 | -122.429415642312 | (37.7458850250928, -122.429415642312) | 2 | 7 | 5 | 63 | 22 | |||
71102 | 179603 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998658.1578 | 2089592.85208 | 37.7175470636356 | -122.446616859994 | (37.7175470636356, -122.446616859994) | 9 | 7 | 6 | 28861 | 25 | |||
74181 | 40602 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 15 | Permit Number 47084 | 6011826.18199 | 2107919.61674 | 37.7686118231125 | -122.40238865592 | (37.7686118231125, -122.40238865592) | 8 | 2 | 8 | 28853 | 20 | |
79981 | 197760 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 6009984.84437 | 2109679.97053 | 37.773342385672 | -122.408881936452 | (37.773342385672, -122.408881936452) | 14 | 2 | 9 | 28853 | 34 | ||||
96464 | 136576 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Jefferson St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008548.79083 | 2122424.56718 | 37.8082553913493 | -122.41475157585 | (37.8082553913493, -122.41475157585) | 3 | 1 | 10 | 308 | 23 | |||
103211 | 136552 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 535 Post St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009695.68796 | 2115014.2038 | 37.7879727267153 | -122.410258865966 | (37.7879727267153, -122.410258865966) | 5 | 1 | 10 | 28852 | 36 | |||
109277 | 215149 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 484 Faxon Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994795.24722 | 2091767.07997 | 37.7232955616276 | -122.460126512638 | (37.7232955616276, -122.460126512638) | 9 | 8 | 4 | 28861 | 24 | |||
109883 | 240849 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 450 Florida St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6009178.7151 | 2106293.81333 | 37.7639995951253 | -122.411431189821 | (37.7639995951253, -122.411431189821) | 8 | 4 | 7 | 28859 | 19 | ||||
120773 | 179607 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 247 Mount Vernon Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5998695.31967 | 2089579.5071 | 37.7175125440582 | -122.44648744935 | (37.7175125440582, -122.44648744935) | 9 | 7 | 6 | 28861 | 25 | ||||
137182 | 50003 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1101X 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 11 | 0 | Permit Number 46740 | 6014266.61344 | 2105244.3143 | 37.7614019609488 | -122.393760055695 | (37.7614019609488, -122.393760055695) | 10 | 3 | 8 | 28856 | 29 |
147824 | 197780 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1809 19th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6012306.16888 | 2105129.4527 | 37.7609774386872 | -122.40053238957 | (37.7609774386872, -122.40053238957) | 10 | 3 | 8 | 28856 | 29 | |||
153108 | 215158 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 494 Victoria St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5993274.39312 | 2090442.46947 | 37.7195709087624 | -122.465287603165 | (37.7195709087624, -122.465287603165) | 9 | 8 | 6 | 64 | 24 | |||
169825 | 51821 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008924.41107 | 2109799.01878 | 37.77360980807 | -122.412558552943 | (37.77360980807, -122.412558552943) | 8 | 2 | 9 | 28853 | 34 | ||
170775 | 179626 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6010345.77162 | 2091690.1629 | 37.7239665350232 | -122.406365616296 | (37.7239665350232, -122.406365616296) | 10 | 3 | 7 | 309 | 28 | |||
177191 | 240862 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1706 Dolores St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6005277.47916 | 2098381.07997 | 37.7420534778916 | -122.424361588223 | (37.7420534778916, -122.424361588223) | 2 | 7 | 5 | 63 | 7 | |||
100832 | 197769 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1301 Minnesota St | 54 | Front Yard : Yard | Tree | Private 2 | 7 | 6015357.64937 | 2102415.32545 | 37.7536947305524 | -122.389788979575 | (37.7536947305524, -122.389788979575) | 10 | 3 | 8 | 28856 | 29 | ||||
6527 | 40000 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 14 | Permit Number 41257 | 6019376.91864 | 2094304.02926 | 37.7316447838739 | -122.375327100491 | (37.7316447838739, -122.375327100491) | 10 | 3 | 8 | 58 | 1 | |
9268 | 245287 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 717 Duncan St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6001940.90402 | 2099694.09971 | 37.7454697460299 | -122.435992320586 | (37.7454697460299, -122.435992320586) | 2 | 7 | 5 | 63 | 22 | |||
12232 | 240848 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 450 Florida St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6009181.67793 | 2106295.69441 | 37.7640049263208 | -122.411421075131 | (37.7640049263208, -122.411421075131) | 8 | 4 | 7 | 28859 | 19 | ||||
23586 | 51714 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 14 | Permit Number 47987 | 6012645.95948 | 2110058.2702 | 37.7745298109235 | -122.399703277606 | (37.7745298109235, -122.399703277606) | 14 | 2 | 9 | 28856 | 20 | ||
27810 | 179583 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 299 Lathrop Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012138.53838 | 2086862.1031 | 37.7108097799129 | -122.399829404828 | (37.7108097799129, -122.399829404828) | 10 | 3 | 8 | 309 | 1 | |||
32439 | 136549 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1160 Polk St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6006876.35083 | 2114950.02533 | 37.7876380691922 | -122.420008729221 | (37.7876380691922, -122.420008729221) | 13 | 9 | 10 | 28858 | 21 | |||
43628 | 136547 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1127 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006861.97682 | 2114694.93906 | 37.7869368551843 | -122.42004035118 | (37.7869368551843, -122.42004035118) | 13 | 9 | 10 | 28858 | 21 | |||
45632 | 240989 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2423 Market St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 8ft | 6002119.69058 | 2105763.49027 | 37.7621449961121 | -122.435808283336 | (37.7621449961121, -122.435808283336) | 15 | 4 | 5 | 28862 | 3 | |||
56716 | 179573 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 205 Seneca Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5999821.83375 | 2090347.39989 | 37.7196852827387 | -122.442648723777 | (37.7196852827387, -122.442648723777) | 9 | 7 | 6 | 28861 | 25 | |||
57890 | 240993 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 5 Beaver St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6002842.00094 | 2106779.76706 | 37.7649764495406 | -122.433382715554 | (37.7649764495406, -122.433382715554) | 15 | 5 | 5 | 28862 | 3 | |||
61990 | 40622 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |||
69879 | 136542 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1234 Polk St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 4ft | 6006831.91851 | 2115273.77419 | 37.7885245003562 | -122.4201854424 | (37.7885245003562, -122.4201854424) | 13 | 9 | 10 | 28858 | 21 | |||
70125 | 136575 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Jefferson St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6008547.84348 | 2122425.87999 | 37.8082589427652 | -122.414754947386 | (37.8082589427652, -122.414754947386) | 3 | 1 | 10 | 308 | 23 | |||
74461 | 245302 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 379 Laidley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003842.11696 | 2096596.26066 | 37.7370716150486 | -122.429197378665 | (37.7370716150486, -122.429197378665) | 2 | 7 | 5 | 63 | 7 | |||
76285 | 240860 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005814.59305 | 2106796.61369 | 37.7651909018693 | -122.423102448325 | (37.7651909018693, -122.423102448325) | 8 | 4 | 5 | 28853 | 19 | |||
100432 | 225144 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Albion St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6005929.78452 | 2106396.85276 | 37.764099752624 | -122.422675617489 | (37.764099752624, -122.422675617489) | 8 | 4 | 5 | 28859 | 19 | |||
104595 | 50002 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1101X 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014257.86563 | 2105244.06654 | 37.7614007945303 | -122.393790293612 | (37.7614007945303, -122.393790293612) | 10 | 3 | 8 | 28856 | 29 |
106399 | 179602 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998651.59561 | 2089580.85001 | 37.7175137338593 | -122.446638679342 | (37.7175137338593, -122.446638679342) | 9 | 7 | 6 | 28861 | 25 | |||
109720 | 179566 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5998660.62804 | 2088348.62653 | 37.7141308458255 | -122.446518856356 | (37.7141308458255, -122.446518856356) | 9 | 7 | 6 | 28861 | 25 | |||
113598 | 51831 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 12 | Permit Number 48062 | 6008936.17347 | 2109786.08328 | 37.7735749503435 | -122.41251695031 | (37.7735749503435, -122.41251695031) | 8 | 2 | 9 | 28853 | 34 | ||
113645 | 179580 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 210 Tocoloma Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012727.00999 | 2087491.1806 | 37.7125698916572 | -122.397839596325 | (37.7125698916572, -122.397839596325) | 10 | 3 | 8 | 309 | 1 | |||
115518 | 104848 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 395X Laidley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003932.8304 | 2096688.95118 | 37.7373312570435 | -122.428890347629 | (37.7373312570435, -122.428890347629) | 2 | 7 | 5 | 63 | 7 | |||
122872 | 197759 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1275 Harrison St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 6009794.14273 | 2110264.73929 | 37.7749373405286 | -122.409582883362 | (37.7749373405286, -122.409582883362) | 8 | 2 | 9 | 28853 | 34 | ||||
124241 | 240861 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1706 Dolores St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6005275.96554 | 2098387.85198 | 37.7420719868226 | -122.424367303401 | (37.7420719868226, -122.424367303401) | 2 | 7 | 5 | 63 | 7 | |||
127491 | 215142 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 600 Portola Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997147.4382 | 2099712.0801 | 37.745245634988 | -122.452568576882 | (37.745245634988, -122.452568576882) | 1 | 7 | 4 | 59 | 40 | |||
129371 | 50009 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.76129 | 2105171.60414 | 37.7612048790107 | -122.393595359241 | (37.7612048790107, -122.393595359241) | 10 | 3 | 8 | 28856 | 29 |
133663 | 179625 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6010348.90515 | 2091680.51921 | 37.7239402307466 | -122.406354104951 | (37.7239402307466, -122.406354104951) | 10 | 3 | 7 | 309 | 28 | |||
136249 | 215148 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 484 Faxon Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994798.31225 | 2091770.42438 | 37.723304920868 | -122.46011615966 | (37.723304920868, -122.46011615966) | 9 | 8 | 4 | 28861 | 24 | |||
139752 | 40581 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 18 | Permit Number 47084 | 6011805.12388 | 2107918.92734 | 37.7686087546157 | -122.402461446151 | (37.7686087546157, -122.402461446151) | 8 | 2 | 8 | 28853 | 20 | |
149745 | 240853 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2801 Mariposa St | 5 | : | Tree | Private 2 | 13 | Width 3ft | 6009171.61206 | 2105893.21544 | 37.7628992467128 | -122.41142745404 | (37.7628992467128, -122.41142745404) | 8 | 4 | 7 | 28859 | 19 | |||
151259 | 142855 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1234 POLK ST | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006830.2557 | 2115271.8515 | 37.7885191274317 | -122.420191058967 | (37.7885191274317, -122.420191058967) | 13 | 9 | 10 | 28858 | 21 | |||
158430 | 136573 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2617 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008287.6646 | 2121918.27349 | 37.8068505621804 | -122.415619404506 | (37.8068505621804, -122.415619404506) | 5 | 1 | 10 | 308 | 23 | |||
160082 | 240965 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 95 Eagle St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999852.33649 | 2104454.38191 | 37.7584214521011 | -122.443556125313 | (37.7584214521011, -122.443556125313) | 2 | 4 | 5 | 28862 | 3 | |||
169297 | 95130 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2200 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 12 | 5999609.56609 | 2120881.60586 | 37.8035125224368 | -122.445576996387 | (37.8035125224368, -122.445576996387) | 13 | 9 | 1 | 57 | 17 | |||
175585 | 113230 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1150 Polk St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | 13 | 9 | 10 | 28858 | 21 | ||||
175666 | 103771 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1288 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | ||
191724 | 104336 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1X Beaver St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6002844 | 2106791 | 37.7650074058753 | -122.433376604069 | (37.7650074058753, -122.433376604069) | 15 | 5 | 5 | 28862 | 3 | ||||
4561 | 245236 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 53 Dearborn St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005838.90196 | 2105786.95682 | 37.7624199943988 | -122.422946603908 | (37.7624199943988, -122.422946603908) | 8 | 4 | 5 | 28859 | 19 | |||
8387 | 240964 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 95 Eagle St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999841.6611 | 2104454.60365 | 37.7584214521056 | -122.443593061365 | (37.7584214521056, -122.443593061365) | 2 | 4 | 5 | 28862 | 3 | |||
8388 | 179624 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6010352.88812 | 2091667.17419 | 37.7239038109035 | -122.406339396551 | (37.7239038109035, -122.406339396551) | 10 | 3 | 7 | 309 | 28 | |||
30893 | 179612 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 Excelsior Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6004345.82316 | 2091535.07257 | 37.7232032246197 | -122.4270954535 | (37.7232032246197, -122.4270954535) | 9 | 7 | 6 | 28861 | 5 | |||
31721 | 245299 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 4308 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001090.90021 | 2103332.76548 | 37.75541232504 | -122.439192241532 | (37.75541232504, -122.439192241532) | 2 | 4 | 5 | 28862 | 38 | |||
33485 | 215143 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 600 Portola Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5997162.83414 | 2099722.45046 | 37.7452749915648 | -122.452516088848 | (37.7452749915648, -122.452516088848) | 1 | 7 | 4 | 59 | 40 | |||
34870 | 136541 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1234 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6006833.25641 | 2115260.36214 | 37.7884877495592 | -122.420179861217 | (37.7884877495592, -122.420179861217) | 13 | 9 | 10 | 28858 | 21 | |||
35261 | 197796 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1938 Quesada Ave | 4 | : | Tree | Private 2 | 11 | Width 2ft | 6013463.04553 | 2095982.9565 | 37.7359275587079 | -122.395890286113 | (37.7359275587079, -122.395890286113) | 10 | 3 | 8 | 58 | 1 | |||
37599 | 51826 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008951.49863 | 2109770.91917 | 37.7735341733012 | -122.412462865995 | (37.7735341733012, -122.412462865995) | 8 | 2 | 9 | 28853 | 34 | ||
38102 | 136540 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2960 Broadway | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 5999430.14581 | 2117046.26527 | 37.7929714572124 | -122.445921873796 | (37.7929714572124, -122.445921873796) | 13 | 9 | 1 | 57 | 27 | |||
42732 | 103772 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1288 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | ||
43126 | 240859 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005815.33313 | 2106780.63921 | 37.7651470814965 | -122.423098753019 | (37.7651470814965, -122.423098753019) | 8 | 4 | 5 | 28853 | 19 | |||
43497 | 197813 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1548 La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015877.12645 | 2095949.17922 | 37.7359688205142 | -122.387541417306 | (37.7359688205142, -122.387541417306) | 10 | 3 | 8 | 58 | 1 | |||
47458 | 113229 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1150 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | 13 | 9 | 10 | 28858 | 21 | ||||
48314 | 136554 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 900 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006026.16604 | 2113167.48716 | 37.7826957225725 | -122.422823475034 | (37.7826957225725, -122.422823475034) | 7 | 9 | 11 | 28858 | 41 | |||
52431 | 142854 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1234 POLK ST | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006834.6673 | 2115255.4083 | 37.7884742270331 | -122.42017462803 | (37.7884742270331, -122.42017462803) | 13 | 9 | 10 | 28858 | 21 | |||
58437 | 50007 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.7489 | 2105179.47261 | 37.7612264834299 | -122.393595952812 | (37.7612264834299, -122.393595952812) | 10 | 3 | 8 | 28856 | 29 |
64188 | 40003 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019368.47353 | 2094309.06128 | 37.7316581360927 | -122.375356645916 | (37.7316581360927, -122.375356645916) | 10 | 3 | 8 | 58 | 1 | |
76253 | 104335 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1X Beaver St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6002844 | 2106791 | 37.7650074058753 | -122.433376604069 | (37.7650074058753, -122.433376604069) | 15 | 5 | 5 | 28862 | 3 |
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) );