trees
155 rows where qSpecies_id = 109 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1654 | 19584 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY4 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
| 1935 | 19720 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY13 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
| 3100 | 19586 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY4 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
| 3296 | 19833 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY25 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60X | |||||||||||||
| 5828 | 19721 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY13 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
| 5903 | 19583 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY4 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
| 6107 | 19832 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY25 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60X | |||||||||||||
| 8596 | 19826 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY25 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
| 8827 | 19825 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 STAIRWAY25 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
| 162063 | 113132 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1375 FAIRFAX AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6016814 | 2097238 | 37.7395595104895 | -122.384391976269 | (37.7395595104895, -122.384391976269) | 10 | 3 | 8 | 58 | 1 | |||||
| 102464 | 248911 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1633 Oakdale Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6014844.92913 | 2095599.8976 | 37.7349525388235 | -122.391085759591 | (37.7349525388235, -122.391085759591) | 10 | 3 | 8 | 58 | 1 | |||||
| 70249 | 113112 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1633 OAKDALE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014731 | 2095647 | 37.7350755495662 | -122.391482947841 | (37.7350755495662, -122.391482947841) | 10 | 3 | 8 | 58 | 1 | |||||
| 23612 | 253210 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 567 Mississippi St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/02/2019 12:00:00 AM | 3 | 3x3 | 6014163 | 2104519 | 37.7594046471392 | -122.394067636073 | (37.7594046471392, -122.394067636073) | 10 | 3 | 8 | 28856 | 29 | ||
| 135623 | 258062 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 567 Mississippi St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/02/2019 12:00:00 AM | 3 | 3x3 | 6014163 | 2104519 | 37.7594046471392 | -122.394067636073 | (37.7594046471392, -122.394067636073) | 10 | 3 | 8 | 28856 | 29 | ||
| 75652 | 188435 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 47 Ceres St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6013897.60555 | 2093909.5086 | 37.730258461857 | -122.394242705643 | (37.730258461857, -122.394242705643) | 10 | 3 | 8 | 58 | 1 | |||
| 120016 | 188434 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 406 Arkansas St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 4ft | 6012917.44565 | 2105140.82493 | 37.7610427357449 | -122.398419034005 | (37.7610427357449, -122.398419034005) | 10 | 3 | 8 | 28856 | 29 | |||
| 69395 | 188432 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1 Jack Balestreri Way | 6 | Front Yard : Yard | Tree | Private 2 | 16 | 6012439.74697 | 2104738.60671 | 37.7599117105733 | -122.400042949735 | (37.7599117105733, -122.400042949735) | 10 | 3 | 8 | 28856 | 29 | ||||
| 25772 | 188433 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1 Jack Balestreri Way | 8 | Front Yard : Yard | Tree | Private 2 | 22 | 6012415.19625 | 2104737.50493 | 37.7599073164779 | -122.400127781893 | (37.7599073164779, -122.400127781893) | 10 | 3 | 8 | 28856 | 29 | ||||
| 70049 | 187545 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1399 Somerset St | 1 | Side Yard : Yard | Tree | Private 2 | 16 | 6011375.77756 | 2088317.82522 | 37.7147643480702 | -122.40256799691 | (37.7147643480702, -122.40256799691) | 10 | 7 | 8 | 309 | 39 | ||||
| 17652 | 187553 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 3960 Somerset St | 1 | Side Yard : Yard | Tree | Private 2 | 16 | 6011370.89706 | 2088323.01324 | 37.7147783208511 | -122.402585230642 | (37.7147783208511, -122.402585230642) | 10 | 7 | 8 | 309 | 39 | ||||
| 128435 | 187548 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1398 Somerset St | 2 | Side Yard : Yard | Tree | Private 2 | 13 | 6011346.78154 | 2088306.58257 | 37.7147318591505 | -122.402667429564 | (37.7147318591505, -122.402667429564) | 10 | 7 | 8 | 309 | 39 | ||||
| 39962 | 187547 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1398 Somerset St | 1 | Side Yard : Yard | Tree | Private 2 | 15 | 6011342.64618 | 2088318.49889 | 37.7147643480751 | -122.402682560663 | (37.7147643480751, -122.402682560663) | 10 | 7 | 8 | 309 | 39 | ||||
| 56151 | 187558 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 3959 Somerset St | 2 | Side Yard : Yard | Tree | Private 2 | 14 | 6011340.42145 | 2088314.93577 | 37.7147544402534 | -122.402689999868 | (37.7147544402534, -122.402689999868) | 10 | 7 | 8 | 309 | 39 | ||||
| 64212 | 187557 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 3959 Somerset St | 1 | Side Yard : Yard | Tree | Private 2 | 17 | 6011334.94928 | 2088323.74418 | 37.7147783208423 | -122.402709533143 | (37.7147783208423, -122.402709533143) | 10 | 7 | 8 | 309 | 39 | ||||
| 34735 | 249869 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 230 Greenwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 6011727.52121 | 2120455.9779 | 37.8030282150334 | -122.403612074753 | (37.8030282150334, -122.403612074753) | 3 | 1 | 10 | 308 | 23 | |||
| 55770 | 249867 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 230 Greenwich St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 0ft | 6011726.07393 | 2120469.26255 | 37.8030646105966 | -122.403618018374 | (37.8030646105966, -122.403618018374) | 3 | 1 | 10 | 28860 | 6 | |||
| 92202 | 249870 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 230 Greenwich St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 6011716.19315 | 2120469.03614 | 37.8030634369921 | -122.403652195296 | (37.8030634369921, -122.403652195296) | 3 | 1 | 10 | 28860 | 6 | |||
| 89352 | 249871 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 230 Greenwich St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 6011715.31721 | 2120468.19877 | 37.8030610888482 | -122.403655167571 | (37.8030610888482, -122.403655167571) | 3 | 1 | 10 | 28860 | 6 | |||
| 27427 | 188430 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 895 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6011323.63457 | 2104185.0777 | 37.7583295512927 | -122.403864109736 | (37.7583295512927, -122.403864109736) | 10 | 3 | 8 | 28856 | 29 | ||||
| 169082 | 108587 | Undocumented 4 | Cedrus deodara :: Deodar Cedar 109 | 950 Goettingen St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6011025 | 2090361 | 37.7203549001646 | -122.403924129148 | (37.7203549001646, -122.403924129148) | 10 | 7 | 8 | 309 | 28 | |||||
| 183281 | 188431 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 889 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6011294.06359 | 2104194.03596 | 37.7583524966 | -122.403967010163 | (37.7583524966, -122.403967010163) | 10 | 3 | 8 | 28856 | 29 | ||||
| 83233 | 249878 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 230 Greenwich St | 14 | Back Yard : Yard | Tree | Private 2 | 23 | Width 0ft | 6011550.21069 | 2120457.44752 | 37.8030223442537 | -122.404225768513 | (37.8030223442537, -122.404225768513) | 3 | 1 | 10 | 28860 | 6 | |||
| 133152 | 188429 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 449 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6011226.32469 | 2106249.13843 | 37.7639915632946 | -122.40434593142 | (37.7639915632946, -122.40434593142) | 8 | 3 | 8 | 28856 | 29 | |||
| 33226 | 188428 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 437 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6011224.31071 | 2106297.23257 | 37.7641235064287 | -122.404356282613 | (37.7641235064287, -122.404356282613) | 8 | 3 | 8 | 28856 | 29 | |||
| 181200 | 248088 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 14 Montcalm St | 2 | Side Yard : Yard | Tree | Private 2 | 21 | 6010648.22773 | 2100325.37229 | 37.7476938971542 | -122.405928083511 | (37.7476938971542, -122.405928083511) | 2 | 7 | 7 | 28859 | 2 | ||||
| 118458 | 248040 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 21 Rutledge St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | 6010515.95575 | 2099424.13934 | 37.7452119095038 | -122.406321984771 | (37.7452119095038, -122.406321984771) | 2 | 7 | 7 | 28859 | 2 | ||||
| 118182 | 247914 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 399 Franconia St | 5 | Side Yard : Yard | Tree | Private 2 | 22 | 6010000.52553 | 2098831.51714 | 37.7435558520369 | -122.408062476915 | (37.7435558520369, -122.408062476915) | 2 | 7 | 7 | 28859 | 2 | ||||
| 93858 | 222754 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1319 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009549.26243 | 2101463.40193 | 37.7507571508265 | -122.409808579911 | (37.7507571508265, -122.409808579911) | 2 | 4 | 7 | 28859 | 19 | |||
| 99985 | 101898 | Undocumented 4 | Cedrus deodara :: Deodar Cedar 109 | 99X MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | 5 | 1 | 10 | 308 | 32 | |||||
| 129291 | 101899 | Undocumented 4 | Cedrus deodara :: Deodar Cedar 109 | 99X MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | 5 | 1 | 10 | 308 | 32 | |||||
| 167667 | 125943 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 90 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 48 | 6008175.06816 | 2119117.82547 | 37.799154906033 | -122.415810641761 | (37.799154906033, -122.415810641761) | 5 | 1 | 10 | 308 | 32 | ||||
| 20813 | 248179 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 218 Esmeralda Ave | 8 | Side Yard : Yard | Tree | Private 2 | 23 | 6007450.1378 | 2098674.92433 | 37.7429827563392 | -122.416870017934 | (37.7429827563392, -122.416870017934) | 2 | 7 | 7 | 28859 | 2 | ||||
| 85861 | 116668 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100x Esmeralda Ave | 4 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 171826 | 116667 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100x Esmeralda Ave | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 5414 | 261208 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1131 Sutter St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2115019 | 37.7878442781586 | -122.418980353142 | (37.7878442781586, -122.418980353142) | 13 | 9 | 10 | 28858 | 21 | ||||
| 5014 | 125944 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 Alice B Toklas Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006919.44761 | 2114149.75866 | 37.7854431613244 | -122.419802815953 | (37.7854431613244, -122.419802815953) | 13 | 9 | 9 | 28858 | 36 | |||
| 193015 | 125945 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 Alice B Toklas Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006900.61191 | 2114145.75127 | 37.7854310968993 | -122.41986769754 | (37.7854310968993, -122.41986769754) | 13 | 9 | 9 | 28858 | 36 | |||
| 117634 | 125946 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 Alice B Toklas Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006887.30647 | 2114142.45385 | 37.7854212934049 | -122.419913496417 | (37.7854212934049, -122.419913496417) | 13 | 9 | 9 | 28858 | 36 | |||
| 74444 | 51490 | Permitted Site 7 | Cedrus deodara :: Deodar Cedar 109 | 1141 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2005 12:00:00 AM | Permit Number 47801 | 6006346.62176787 | 2120383.49035499 | 37.8025271407982 | -122.42222766993 | (37.8025271407982, -122.42222766993) | 5 | 9 | 1 | 28858 | 32 | |||
| 97164 | 222771 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 112 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6005731.8211 | 2100248.43843 | 37.7472064655097 | -122.422923303361 | (37.7472064655097, -122.422923303361) | 2 | 7 | 5 | 28859 | 22 | |||
| 78900 | 254971 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 972 Guerrero St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6005650 | 2103315 | 37.7556219192197 | -122.423424204919 | (37.7556219192197, -122.423424204919) | 2 | 4 | 5 | 28859 | 19 | ||||
| 43597 | 78107 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 970 GUERRERO ST | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6005649.9 | 2103318.5 | 37.7556315237614 | -122.423424799558 | (37.7556315237614, -122.423424799558) | 2 | 4 | 5 | 28859 | 19 | ||||
| 176130 | 222760 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 10x Benton Ave | 8 | Median : Yard | Tree | DPW 1 | 12 | 6004726.81144 | 2094996.18589 | 37.73272821244 | -122.426024717968 | (37.73272821244, -122.426024717968) | 2 | 7 | 7 | 28861 | 2 | ||||
| 59355 | 222755 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1201 San Jose Ave | 63 | Front Yard : Yard | Tree | Private 2 | 2 | 6004520.50239 | 2096106.24314 | 37.7357645179181 | -122.426817006298 | (37.7357645179181, -122.426817006298) | 2 | 7 | 5 | 28861 | 2 | ||||
| 93405 | 222762 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 310 Liberty St | 29 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6003941.63846 | 2103927.14529 | 37.7572061559584 | -122.429375905767 | (37.7572061559584, -122.429375905767) | 2 | 4 | 5 | 28862 | 3 | |||
| 48978 | 87197 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 617 Sanchez St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50213 | 6003760 | 2104634 | 37.7591367256626 | -122.430054504807 | (37.7591367256626, -122.430054504807) | 2 | 4 | 5 | 28862 | 3 | ||||
| 134875 | 222763 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 324 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003511.54798 | 2104505.04624 | 37.7587685751304 | -122.430904567088 | (37.7587685751304, -122.430904567088) | 2 | 4 | 5 | 28862 | 3 | |||
| 14318 | 222761 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 3995 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003074.11018 | 2104735.69559 | 37.7593770879038 | -122.43243390112 | (37.7593770879038, -122.43243390112) | 2 | 4 | 5 | 28862 | 3 | |||
| 110861 | 106342 | Permitted Site 7 | Cedrus deodara :: Deodar Cedar 109 | 497 VALLEY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2014 12:00:00 AM | 6 | Permit Number 770848 | 6002779 | 2099138 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | 2 | 7 | 5 | 63 | 22 | ||
| 133163 | 222756 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 483 Valley St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6002764.38109 | 2099167.98488 | 37.7440719045989 | -122.433107286485 | (37.7440719045989, -122.433107286485) | 2 | 7 | 5 | 63 | 22 | ||||
| 165366 | 4264 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 4175 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6002749.5486029 | 2100327.597901 | 37.7472550893281 | -122.433241415923 | (37.7472550893281, -122.433241415923) | 2 | 4 | 5 | 63 | 22 | |||
| 104420 | 67845 | Permitted Site 7 | Cedrus deodara :: Deodar Cedar 109 | 4175 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/1993 12:00:00 AM | 3x3 | Permit Number 767162 | 6002749.4858836 | 2100326.5930757 | 37.7472523267557 | -122.433241561015 | (37.7472523267557, -122.433241561015) | 2 | 4 | 5 | 63 | 22 | ||
| 97059 | 222768 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 79 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002832.56338 | 2108743.90779 | 37.7703689643988 | -122.433555737015 | (37.7703689643988, -122.433555737015) | 15 | 5 | 5 | 29492 | 9 | |||
| 145470 | 222769 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 81 Digby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6002596.69454 | 2097696.2545 | 37.740021361702 | -122.433581950462 | (37.740021361702, -122.433581950462) | 2 | 7 | 5 | 63 | 7 | ||||
| 85627 | 222770 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 81 Digby St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6002588.1649 | 2097709.69049 | 37.7400577698522 | -122.433612402404 | (37.7400577698522, -122.433612402404) | 2 | 7 | 5 | 63 | 7 | ||||
| 30713 | 99829 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 2398 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 191878 | 222758 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 671 28th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6001587.48028 | 2099382.86516 | 37.7445950851959 | -122.437192121419 | (37.7445950851959, -122.437192121419) | 2 | 7 | 5 | 63 | 22 | |||
| 74804 | 222757 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1351 Douglass St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 6ft | 6001399.79942 | 2099748.33907 | 37.7455879196477 | -122.437867255078 | (37.7455879196477, -122.437867255078) | 2 | 4 | 5 | 63 | 22 | |||
| 87221 | 222766 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 230 States St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6000813.28716 | 2106520.59939 | 37.7641495354877 | -122.440380922268 | (37.7641495354877, -122.440380922268) | 15 | 5 | 5 | 28862 | 3 | |||
| 137550 | 253388 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 30 Grand View Ave | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6000475 | 2103841 | 37.7567727470696 | -122.441358672007 | (37.7567727470696, -122.441358672007) | 2 | 4 | 5 | 28862 | 38 | ||||
| 191476 | 121091 | Undocumented 4 | Cedrus deodara :: Deodar Cedar 109 | 30X Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000475 | 2103841 | 37.7567727470696 | -122.441358672007 | (37.7567727470696, -122.441358672007) | 2 | 4 | 5 | 28862 | 38 | ||||
| 13663 | 258677 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 607 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 6000094 | 2095817 | 37.7347190533418 | -122.442100351643 | (37.7347190533418, -122.442100351643) | 9 | 7 | 4 | 63 | 40 | ||||
| 42557 | 101977 | Property Tree 8 | Cedrus deodara :: Deodar Cedar 109 | 601 Grand View Ave | Front Yard : Yard | Tree | Private 2 | 6000076.2 | 2101609.9 | 37.7506239629918 | -122.442577679409 | (37.7506239629918, -122.442577679409) | 2 | 4 | 5 | 28862 | 22 | ||||||
| 6682 | 222764 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 191 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6000158.84379 | 2105641.525 | 37.76169853039 | -122.442581324981 | (37.76169853039, -122.442581324981) | 15 | 5 | 5 | 28862 | 3 | |||
| 42128 | 102522 | Undocumented 4 | Cedrus deodara :: Deodar Cedar 109 | 1X 31st St | 2 | Unaccepted Street : Yard | Tree | Private 2 | 5999966.2 | 2097547.4 | 37.7394630398899 | -122.442666404233 | (37.7394630398899, -122.442666404233) | 9 | 7 | 4 | 59 | 40 | |||||
| 74277 | 251372 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1526 Masonic Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/01/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779800 | 5999767 | 2107205 | 37.7659690994291 | -122.444048894864 | (37.7659690994291, -122.444048894864) | 15 | 5 | 5 | 29492 | 9 | |
| 160978 | 112451 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1526 MASONIC AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x6 | 5999767 | 2107205 | 37.7659690994291 | -122.444048894864 | (37.7659690994291, -122.444048894864) | 15 | 5 | 5 | 29492 | 9 | ||||
| 134272 | 253984 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 450X Detroit St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5999472 | 2094602 | 37.7313474818721 | -122.44416353259 | (37.7313474818721, -122.44416353259) | 9 | 7 | 4 | 63 | 40 | ||||
| 48358 | 112182 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 301x CORBETT AVE | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 5999677 | 2105220 | 37.760513648973 | -122.444217531177 | (37.760513648973, -122.444217531177) | 15 | 5 | 5 | 28862 | 3 | ||||
| 113943 | 222765 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 272 Corbett Ave | 1 | Side Yard : Yard | Tree | Private 2 | 16 | Width 3ft | 5999637.29501 | 2105376.06979 | 37.760939912666 | -122.444366068238 | (37.760939912666, -122.444366068238) | 15 | 5 | 5 | 28862 | 3 | |||
| 194175 | 116308 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 699X DETROIT ST | 9 | Back Yard : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
| 39009 | 255287 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 2758 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999862 | 2117824 | 37.7951315610034 | -122.444483561153 | (37.7951315610034, -122.444483561153) | 13 | 9 | 1 | 57 | 17 | ||||
| 56487 | 222767 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 301 Upper Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5999265.86502 | 2105880.94381 | 37.7623049720107 | -122.445686985283 | (37.7623049720107, -122.445686985283) | 15 | 5 | 5 | 29492 | 3 | |||
| 124217 | 109412 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 24 DELMAR ST | 1 | Front Yard : Yard | Tree | Private 2 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774367 | 5999307.7 | 2108197.1 | 37.7686669444558 | -122.445708866914 | (37.7686669444558, -122.445708866914) | 15 | 5 | 11 | 29492 | 9 | |
| 471 | 205972 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 400x Marietta Dr | 49 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5998976.04571 | 2096922.6715 | 37.7376911903888 | -122.446044988292 | (37.7376911903888, -122.446044988292) | 9 | 7 | 4 | 59 | 40 | |||
| 115960 | 205971 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 400x Marietta Dr | 50 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 5998959.86382 | 2096907.26724 | 37.7376479698832 | -122.446099828942 | (37.7376479698832, -122.446099828942) | 9 | 7 | 4 | 59 | 40 | |||
| 91073 | 205974 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 645 Edna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5998776.7097 | 2095073.04363 | 37.732601166099 | -122.446601147923 | (37.732601166099, -122.446601147923) | 9 | 7 | 4 | 59 | 40 | ||||
| 16617 | 205970 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 Bella Vista Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998533.62176 | 2097061.44244 | 37.7380469478033 | -122.447584640212 | (37.7380469478033, -122.447584640212) | 9 | 7 | 4 | 59 | 40 | |||
| 164452 | 117027 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 731 CLAYTON ST | 1 | Front Yard : Cutout | Tree | Private 2 | 5998515 | 2108057 | 37.7682369747157 | -122.448440651351 | (37.7682369747157, -122.448440651351) | 15 | 5 | 11 | 29492 | 9 | |||||
| 175617 | 222759 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 25 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5997031.40026 | 2106439.64122 | 37.7637111852528 | -122.453455459504 | (37.7637111852528, -122.453455459504) | 15 | 5 | 11 | 29492 | 12 | |||
| 42238 | 26408 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 34 Maple St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996561.99823 | 2116111.65083 | 37.7902410678174 | -122.455778167326 | (37.7902410678174, -122.455778167326) | 11 | 6 | 1 | 54 | 31 | |||
| 30134 | 101033 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1010X Portola Dr | 7 | Front Yard : Yard | Tree | DPW 1 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||||
| 180388 | 122533 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 330 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 5996206.76468 | 2115142.22456 | 37.7875588910678 | -122.456937093983 | (37.7875588910678, -122.456937093983) | 11 | 6 | 1 | 54 | 31 | |||
| 26724 | 125941 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 330 Cherry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5996203.89662 | 2115167.13558 | 37.7876271253444 | -122.456948819342 | (37.7876271253444, -122.456948819342) | 11 | 6 | 1 | 54 | 31 | |||
| 152519 | 125942 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 330 Cherry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5996200.38714 | 2115190.83306 | 37.7876919907308 | -122.456962676089 | (37.7876919907308, -122.456962676089) | 11 | 6 | 1 | 54 | 31 | |||
| 41783 | 205963 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 1575 Plymouth Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 3ft | 5995549.16241 | 2094435.18175 | 37.730664862776 | -122.4577133537 | (37.730664862776, -122.4577133537) | 9 | 7 | 4 | 28861 | 40 | |||
| 191394 | 205961 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 600x Wildwood Way | 1 | Median : Yard | Tree | DPW 1 | 16 | 5995381.06521 | 2093316.38835 | 37.7275832683311 | -122.458213544042 | (37.7275832683311, -122.458213544042) | 9 | 7 | 4 | 28861 | 40 | ||||
| 194504 | 265143 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 333 Lansdale Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995416 | 2096422 | 37.7361125310636 | -122.458317465478 | (37.7361125310636, -122.458317465478) | 9 | 7 | 4 | 59 | 40 | ||||
| 139583 | 205962 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 338 Juanita Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 5994999.30482 | 2097584.25699 | 37.7392798481851 | -122.459842304373 | (37.7392798481851, -122.459842304373) | 9 | 7 | 4 | 59 | 40 | |||
| 102066 | 205973 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 100 Edgehill Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994796.55724 | 2098924.8239 | 37.7429490497539 | -122.460640430205 | (37.7429490497539, -122.460640430205) | 1 | 8 | 4 | 59 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );