trees
858 rows where qSpecies_id = 85 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
763 | 81425 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 940 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | 6008220.47523 | 2115740.61826 | 37.7898844812376 | -122.415414298837 | (37.7898844812376, -122.415414298837) | 5 | 1 | 10 | 28858 | 21 | ||
5526 | 71641 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1327 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011027.0266 | 2119468.0848 | 37.800276548465 | -122.405966529737 | (37.800276548465, -122.405966529737) | 3 | 1 | 10 | 308 | 23 | |||
7978 | 81424 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 936 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008224.91775 | 2115730.6565 | 37.7898573783726 | -122.415398222545 | (37.7898573783726, -122.415398222545) | 5 | 1 | 10 | 28858 | 21 | |||
14590 | 142982 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2331 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6008422.9305 | 2120909.8092 | 37.8040891760793 | -122.415079860656 | (37.8040891760793, -122.415079860656) | 5 | 1 | 10 | 308 | 23 | |||
24695 | 136564 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 780 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007032.14373 | 2121235.03543 | 37.8049039103473 | -122.419915879607 | (37.8049039103473, -122.419915879607) | 5 | 1 | 1 | 28858 | 32 | |||
25892 | 136559 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1200 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009435.38581 | 2117472.07438 | 37.794706848389 | -122.411333170001 | (37.794706848389, -122.411333170001) | 3 | 1 | 10 | 28857 | 4 | |||
26447 | 42664 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 780 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2011 12:00:00 AM | 6 | Permit Number 768090 | 6007065.06318 | 2121240.35517 | 37.8049203715397 | -122.419802335728 | (37.8049203715397, -122.419802335728) | 5 | 1 | 1 | 28858 | 32 | ||
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 | |||
36408 | 83343 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1327 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50763 | 6011023.37395305 | 2119422.18641329 | 37.8001503184077 | -122.405975934235 | (37.8001503184077, -122.405975934235) | 3 | 1 | 10 | 308 | 23 | ||
41912 | 136569 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2617 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6008276.62811 | 2122005.04702 | 37.8070881999362 | -122.415663746486 | (37.8070881999362, -122.415663746486) | 5 | 1 | 10 | 308 | 23 | |||
44614 | 136571 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2617 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008282.41711 | 2121963.57618 | 37.8069746569262 | -122.415640774196 | (37.8069746569262, -122.415640774196) | 5 | 1 | 10 | 308 | 23 | |||
52724 | 250213 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 300 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011356.8747 | 2120078.79875 | 37.8019718623651 | -122.404868140773 | (37.8019718623651, -122.404868140773) | 3 | 1 | 10 | 308 | 23 | |||
56629 | 136558 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 945 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007692.42532 | 2115699.65568 | 37.7897423145977 | -122.417238404529 | (37.7897423145977, -122.417238404529) | 13 | 1 | 10 | 28858 | 21 | |||
59554 | 136565 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1218 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007807.75264 | 2118217.01551 | 37.7966608503694 | -122.41701782152 | (37.7966608503694, -122.41701782152) | 5 | 1 | 10 | 28858 | 32 | |||
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 | |||
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 | |||
79080 | 64359 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 369 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 11 | Permit Number 25197 | 6011195.22959 | 2119324.38957 | 37.7998914022152 | -122.405374352958 | (37.7998914022152, -122.405374352958) | 3 | 1 | 10 | 308 | 23 | |
89739 | 136572 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2617 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008286.12433 | 2121941.05643 | 37.8069130317845 | -122.41562634907 | (37.8069130317845, -122.41562634907) | 5 | 1 | 10 | 308 | 23 | |||
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 | |||
96554 | 49572 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1250 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2003 12:00:00 AM | 7 | Permit Number 46457 | 6008112 | 2116793 | 37.7927679657247 | -122.41586416619 | (37.7927679657247, -122.41586416619) | 5 | 1 | 10 | 28858 | 21 | ||
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 | |||
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 | |||
107604 | 136557 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 837 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6007687.79617 | 2114390.45453 | 37.7861473079843 | -122.417161613215 | (37.7861473079843, -122.417161613215) | 13 | 1 | 9 | 28858 | 36 | |||
111540 | 136568 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2500 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007491.24914 | 2120995.37952 | 37.8042717301083 | -122.418310088837 | (37.8042717301083, -122.418310088837) | 5 | 1 | 1 | 308 | 32 | |||
115412 | 45711 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1202X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 14 | 3x3 | Permit Number 47519 | 6008066 | 2116562 | 37.7921311104068 | -122.416006962529 | (37.7921311104068, -122.416006962529) | 5 | 1 | 10 | 28858 | 21 | |
123485 | 40625 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 4 | 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 | |||
126882 | 117576 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 100 Waverly Pl | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 3x3 | 6010746.80079 | 2117296.55701 | 37.7942983844173 | -122.406783100465 | (37.7942983844173, -122.406783100465) | 3 | 1 | 10 | 28857 | 4 | |||
135737 | 142983 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2331 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6008427.2872 | 2120882.2163 | 37.8040136577388 | -122.415062829674 | (37.8040136577388, -122.415062829674) | 5 | 1 | 10 | 308 | 23 | |||
137724 | 136566 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1218 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007796.91649 | 2118215.26217 | 37.796655426568 | -122.41705519284 | (37.796655426568, -122.41705519284) | 5 | 1 | 10 | 28858 | 32 | |||
138759 | 40621 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 2 | 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 | |||
148657 | 136551 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 535 Post St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009633.52573 | 2115005.6617 | 37.7879457875105 | -122.410473333578 | (37.7879457875105, -122.410473333578) | 5 | 1 | 10 | 28852 | 36 | |||
156211 | 142981 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2331 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6008417.8476 | 2120947.5679 | 37.804192566337 | -122.415100124758 | (37.804192566337, -122.415100124758) | 5 | 1 | 10 | 308 | 23 | |||
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 | |||
159816 | 136567 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2500 Leavenworth St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6007492.17185 | 2120992.00241 | 37.8042625093597 | -122.418306656128 | (37.8042625093597, -122.418306656128) | 5 | 1 | 1 | 308 | 32 | |||
160684 | 136570 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2617 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6008280.33532 | 2121982.52726 | 37.8070265747706 | -122.415649321353 | (37.8070265747706, -122.415649321353) | 5 | 1 | 10 | 308 | 23 | |||
177121 | 136574 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Jefferson St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008546.66406 | 2122423.80202 | 37.8082531709192 | -122.414758881938 | (37.8082531709192, -122.414758881938) | 3 | 1 | 10 | 308 | 23 | |||
179646 | 40623 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 1 | 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 | |||
182993 | 45710 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1202X Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 14 | 3x3 | Permit Number 47519 | 6008066 | 2116562 | 37.7921311104068 | -122.416006962529 | (37.7921311104068, -122.416006962529) | 5 | 1 | 10 | 28858 | 21 | |
186907 | 136550 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 535 Post St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009600.17955 | 2115001.02836 | 37.7879311960125 | -122.410588378478 | (37.7879311960125, -122.410588378478) | 5 | 1 | 10 | 28852 | 36 | |||
193960 | 40624 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2675 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | 14 | 3x3 | Permit Number 41626 | 6008278.01579529 | 2121980.95813259 | 37.8070221359583 | -122.415657237402 | (37.8070221359583, -122.415657237402) | 5 | 1 | 10 | 308 | 23 | |
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 | ||
8080 | 75081 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 172 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 8x9 | 6010488.28034 | 2111342.37314 | 37.7779351433246 | -122.407257684389 | (37.7779351433246, -122.407257684389) | 14 | 2 | 9 | 28853 | 34 | |||
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 | ||
16391 | 197750 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 772 Bryant St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6012005.03317 | 2110833.59776 | 37.7766229335303 | -122.401974894942 | (37.7766229335303, -122.401974894942) | 14 | 2 | 9 | 28856 | 34 | |||
17510 | 70565 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 210 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6014527.51657 | 2111489.70716 | 37.7785649223813 | -122.39329474466 | (37.7785649223813, -122.39329474466) | 6 | 2 | 9 | 28856 | 34 | |||
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 | ||
19679 | 40601 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 13 | Permit Number 47084 | 6011717.76597 | 2107914.27714 | 37.7685911090192 | -122.402763284706 | (37.7685911090192, -122.402763284706) | 8 | 2 | 8 | 28853 | 20 | |
19979 | 41630 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 11 | Permit Number 47987 | 6012549.77298 | 2109959.42064 | 37.7742530301757 | -122.400029064208 | (37.7742530301757, -122.400029064208) | 14 | 2 | 9 | 28856 | 20 | ||
22257 | 197762 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 967 Natoma St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6008013.25237 | 2109878.84045 | 37.7737778014386 | -122.41571605105 | (37.7737778014386, -122.41571605105) | 8 | 2 | 9 | 28853 | 34 | |||
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 | ||
27267 | 73457 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2015 12:00:00 AM | 3 | Permit Number 774688 | 6009719.27808 | 2110896.03825 | 37.7766665443529 | -122.40988643061 | (37.7766665443529, -122.40988643061) | 8 | 2 | 9 | 28853 | 34 | ||
27271 | 50760 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47299 | 6009900.23371634 | 2109608.97618966 | 37.7731427119765 | -122.409169607112 | (37.7731427119765, -122.409169607112) | 14 | 2 | 9 | 28853 | 34 | |||
33843 | 51717 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 12 | Permit Number 47987 | 6012600.34291 | 2110009.85826 | 37.7743943397653 | -122.399857674991 | (37.7743943397653, -122.399857674991) | 14 | 2 | 9 | 28856 | 20 | ||
34629 | 197801 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 816 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011521.16357 | 2109490.57736 | 37.7729082910133 | -122.403554237551 | (37.7729082910133, -122.403554237551) | 14 | 2 | 9 | 28853 | 34 | |||
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 | ||
39190 | 41631 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 175 Bluxome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | 13 | Permit Number 47987 | 6012575.96802 | 2109987.3858 | 37.7743312765925 | -122.399940414441 | (37.7743312765925, -122.399940414441) | 14 | 2 | 9 | 28856 | 20 | ||
41360 | 197804 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 850 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6011235.3992 | 2109217.88632 | 37.7721435776893 | -122.404523536758 | (37.7721435776893, -122.404523536758) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
44332 | 197798 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 444 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6013857.66162 | 2111727.99067 | 37.7791819571277 | -122.395628745281 | (37.7791819571277, -122.395628745281) | 6 | 2 | 9 | 28856 | 34 | |||
46814 | 51711 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 175@ 6th ST Bluxome St | 10 | 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 | |||
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 | |||
49411 | 51824 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 12 | Permit Number 48062 | 6008839.3407 | 2109885.31137 | 37.7738419725734 | -122.412858927409 | (37.7738419725734, -122.412858927409) | 8 | 2 | 9 | 28853 | 34 | ||
49931 | 50761 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | Permit Number 47299 | 6009900.23371634 | 2109608.97618966 | 37.7731427119765 | -122.409169607112 | (37.7731427119765, -122.409169607112) | 14 | 2 | 9 | 28853 | 34 | |||
49993 | 197756 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6009912.73431 | 2109600.17323 | 37.7731192414011 | -122.409125744471 | (37.7731192414011, -122.409125744471) | 14 | 2 | 9 | 28853 | 34 | |||
52108 | 197809 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008647.67456 | 2110087.31944 | 37.77438587894 | -122.413536223923 | (37.77438587894, -122.413536223923) | 8 | 2 | 9 | 28853 | 34 | |||
54197 | 51828 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 11 | Permit Number 48062 | 6008816.98399 | 2109909.48162 | 37.7739070834758 | -122.412937972431 | (37.7739070834758, -122.412937972431) | 8 | 2 | 9 | 28853 | 34 | ||
56442 | 197808 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008660.65845 | 2110075.31719 | 37.7743536526336 | -122.413490461037 | (37.7743536526336, -122.413490461037) | 8 | 2 | 9 | 28853 | 34 | |||
58846 | 51534 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 772 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 10 | Permit Number 47835 | 6012007.91318 | 2110835.16017 | 37.7766273842858 | -122.401965041949 | (37.7766273842858, -122.401965041949) | 14 | 2 | 9 | 28856 | 34 | ||
59274 | 85361 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 30 Dore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | 12 | Permit Number 49638 | 6008746.14707 | 2109938.9547 | 37.7739840330773 | -122.413185094432 | (37.7739840330773, -122.413185094432) | 8 | 2 | 9 | 28853 | 34 | ||
64630 | 197753 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 477 Morris St | 3 | : | Tree | Private 2 | 14 | Width 3ft | 6011938.94359 | 2110826.29932 | 37.7765992049252 | -122.402203006171 | (37.7765992049252, -122.402203006171) | 14 | 2 | 9 | 28856 | 34 | |||
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 | |
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 | ||
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 | ||||
80860 | 33863 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 281 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1997 12:00:00 AM | 9 | Permit Number 37859 | 6011402.4962 | 2111360.89694 | 37.7780371282385 | -122.404096375858 | (37.7780371282385, -122.404096375858) | 14 | 2 | 9 | 28856 | 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 | |
98061 | 100791 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769131 | 6009961 | 2109679 | 37.773338385175 | -122.408964349313 | (37.773338385175, -122.408964349313) | 14 | 2 | 9 | 28853 | 34 | |
108295 | 197811 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008628.59591 | 2110107.11154 | 37.7744391520861 | -122.413603620921 | (37.7744391520861, -122.413603620921) | 8 | 2 | 9 | 28853 | 34 | |||
109641 | 197751 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 477 Morris St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6011923.70688 | 2110840.70923 | 37.7766379207291 | -122.402256728071 | (37.7766379207291, -122.402256728071) | 14 | 2 | 9 | 28856 | 34 | |||
110157 | 197806 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 850 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011212.56245 | 2109198.11372 | 37.7720880103782 | -122.404601139252 | (37.7720880103782, -122.404601139252) | 14 | 2 | 9 | 28853 | 34 | |||
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 | ||
112406 | 197749 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 285 Clara St | 1 | : | Tree | Private 2 | 11 | Width 2ft | 6011375.02403 | 2111337.26592 | 37.7779707079309 | -122.404189748854 | (37.7779707079309, -122.404189748854) | 14 | 2 | 9 | 28856 | 34 | |||
112644 | 51825 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 9 | Permit Number 48062 | 6008869.29878 | 2109856.43438 | 37.7737643646643 | -122.412753255267 | (37.7737643646643, -122.412753255267) | 8 | 2 | 9 | 28853 | 34 | ||
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 | ||
117787 | 51830 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008991.04076 | 2109728.43276 | 37.7734197345703 | -122.41232307986 | (37.7734197345703, -122.41232307986) | 8 | 2 | 9 | 28853 | 34 | ||
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 | ||||
123546 | 197800 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 633 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012543.89196 | 2109939.0367 | 37.774196732621 | -122.400047976054 | (37.774196732621, -122.400047976054) | 14 | 2 | 9 | 28856 | 20 | |||
124586 | 197802 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 816 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011487.83724 | 2109458.15845 | 37.7728174145236 | -122.403667236476 | (37.7728174145236, -122.403667236476) | 14 | 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 | |||
128350 | 70674 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 Rausch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2015 12:00:00 AM | 3 | Permit Number 774688 | 6009713.37345 | 2110904.22061 | 37.7766886802763 | -122.409907434288 | (37.7766886802763, -122.409907434288) | 8 | 2 | 9 | 28853 | 34 | ||
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 | |
130774 | 197755 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6009884.52157 | 2109578.01203 | 37.7730568113471 | -122.409221772263 | (37.7730568113471, -122.409221772263) | 14 | 2 | 9 | 28853 | 34 | |||
131971 | 40579 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 14 | Permit Number 47084 | 6011781.78779 | 2107916.60765 | 37.7686010824916 | -122.402542001114 | (37.7686010824916, -122.402542001114) | 8 | 2 | 8 | 28853 | 20 | |
133443 | 197810 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008638.52776 | 2110098.76438 | 37.7744167904456 | -122.413568674158 | (37.7744167904456, -122.413568674158) | 8 | 2 | 9 | 28853 | 34 | |||
133819 | 197757 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6009931.91498 | 2109631.18124 | 37.7732054566946 | -122.409061584123 | (37.7732054566946, -122.409061584123) | 14 | 2 | 9 | 28853 | 34 | |||
138467 | 40600 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 16 | Permit Number 47084 | 6011742.75079 | 2107914.88662 | 37.768594177497 | -122.402676906637 | (37.768594177497, -122.402676906637) | 8 | 2 | 8 | 28853 | 20 | |
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 | |
141254 | 92895 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1247 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009778 | 2109505 | 37.7728503689602 | -122.409585091202 | (37.7728503689602, -122.409585091202) | 14 | 2 | 9 | 28853 | 34 | |||||
149495 | 197758 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6009958.32307 | 2109652.80645 | 37.7732663138222 | -122.408971760735 | (37.7732663138222, -122.408971760735) | 14 | 2 | 9 | 28853 | 34 | |||
153088 | 197752 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 477 Morris St | 2 | : | Tree | Private 2 | 14 | Width 3ft | 6011931.78644 | 2110833.72253 | 37.7766191878522 | -122.402228287011 | (37.7766191878522, -122.402228287011) | 14 | 2 | 9 | 28856 | 34 | |||
153181 | 40599 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 15 | Permit Number 47084 | 6011762.41247 | 2107915.88375 | 37.7685980131212 | -122.402608968236 | (37.7685980131212, -122.402608968236) | 8 | 2 | 8 | 28853 | 20 |
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) );