trees

8,298 rows where qLegalStatus_id = 4 sorted by TreeID

✎ View and edit SQL

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)
77118 100396 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 500X Oak Park Dr 1 Sidewalk: Property side : Yard Tree Private 2   09/18/2012 12:00:00 AM 3 3x9 Permit Number 769101 5994983.3 2103652.8 37.7559416221353 -122.460337221652 (37.7559416221353, -122.460337221652) 1 5 4 63 12
28626 100399 Undocumented 4 Ficus nitida :: Laurel Fig 53 900 Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 4x4   6011664 2118384 37.7973355180624 -122.403686018548 (37.7973355180624, -122.403686018548) 3 1 10 308 23
543 100400 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 88 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 6x3   6008223 2099495 37.7452779444232 -122.414255673266 (37.7452779444232, -122.414255673266) 2 7 7 28859 2
146086 100401 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 91 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 6x4.5   6008260 2099484 37.7452498191594 -122.414126954963 (37.7452498191594, -122.414126954963) 2 7 7 28859 2
118586 100402 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 70 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 8.5x4.5   6008217 2099607 37.7455851344824 -122.414284343223 (37.7455851344824, -122.414284343223) 2 7 7 28859 2
85194 100418 Undocumented 4 Rhaphiolepis indica :: India Hawthorn 293 1658 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2           5999871 2110573 37.7752227103974 -122.443931190755 (37.7752227103974, -122.443931190755) 15 5 11 29492 16
124986 100419 Undocumented 4 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 760 Duboce Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           6002024.1 2108325.5 37.7691742163209 -122.436322258742 (37.7691742163209, -122.436322258742) 15 5 5 29492 9
152523 100460 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 24 Woodland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997085.6 2106503.4 37.7638893573064 -122.453272603676 (37.7638893573064, -122.453272603676) 15 5 11 29492 12
117867 100461 Undocumented 4 Leptospermum scoparium :: New Zealand Tea Tree 157 236 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2           5992450 2097712 37.7394836593705 -122.468665877071 (37.7394836593705, -122.468665877071) 1 8 4 59 40
93538 100462 Undocumented 4 Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 236 Wawona St 2 Sidewalk: Curb side : Cutout Tree Private 2           5992450 2097712 37.7394836593705 -122.468665877071 (37.7394836593705, -122.468665877071) 1 8 4 59 40
171128 100463 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 197 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           6000813.5 2094900.3 37.732242985333 -122.439547106485 (37.732242985333, -122.439547106485) 9 7 4 63 40
177897 100470 Undocumented 4 Ficus nitida :: Laurel Fig 53 5X Pearl St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6005567.3 2108720.4 37.7704592014806 -122.424094599295 (37.7704592014806, -122.424094599295) 8 2 5 28853 19
148177 100480 Undocumented 4 Ficus nitida :: Laurel Fig 53 245 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6007080 2107899 37.7682891227663 -122.418803888241 (37.7682891227663, -122.418803888241) 8 4 7 28853 19
150296 100481 Undocumented 4 Ficus nitida :: Laurel Fig 53 1849 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 26048 6008683 2107773 37.7680332828269 -122.413250335235 (37.7680332828269, -122.413250335235) 8 4 7 28853 19
133574 100482 Undocumented 4 Ficus nitida :: Laurel Fig 53 1849 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008683 2107773 37.7680332828269 -122.413250335235 (37.7680332828269, -122.413250335235) 8 4 7 28853 19
117580 100483 Undocumented 4 Ficus nitida :: Laurel Fig 53 1849 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008683 2107773 37.7680332828269 -122.413250335235 (37.7680332828269, -122.413250335235) 8 4 7 28853 19
139080 100484 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1817X Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008768.3 2108132.4 37.7690249002263 -122.412980705199 (37.7690249002263, -122.412980705199) 8 4 7 28853 19
158015 100485 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1817X Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008768.3 2108132.4 37.7690249002263 -122.412980705199 (37.7690249002263, -122.412980705199) 8 4 7 28853 19
151957 100486 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1717X Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008671 2108256 37.7693588146768 -122.413326002916 (37.7693588146768, -122.413326002916) 8 4 7 28853 19
131311 100487 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1717X Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008671 2108256 37.7693588146768 -122.413326002916 (37.7693588146768, -122.413326002916) 8 4 7 28853 19
111510 100488 Undocumented 4 Maytenus boaria :: Mayten 58 104 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004291 2109102 37.7714348393367 -122.428536532108 (37.7714348393367, -122.428536532108) 7 9 11 28852 10
141894 100489 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3855 California St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5995841 2114493 37.7857552845664 -122.458155553502 (37.7857552845664, -122.458155553502) 11 6 1 54 31
58182 100492 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1899X Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008683 2107773 37.7680332828269 -122.413250335235 (37.7680332828269, -122.413250335235) 8 4 7 28853 19
7219 100493 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1899X Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008692.6 2107433.7 37.7671021827668 -122.413193133966 (37.7671021827668, -122.413193133966) 8 4 7 28853 19
15564 100494 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1899X Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008692.6 2107433.7 37.7671021827668 -122.413193133966 (37.7671021827668, -122.413193133966) 8 4 7 28853 19
100173 100495 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1899X Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008692.6 2107433.7 37.7671021827668 -122.413193133966 (37.7671021827668, -122.413193133966) 8 4 7 28853 19
113000 100496 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1899X Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008692.6 2107433.7 37.7671021827668 -122.413193133966 (37.7671021827668, -122.413193133966) 8 4 7 28853 19
34532 100497 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1899X Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008692.6 2107433.7 37.7671021827668 -122.413193133966 (37.7671021827668, -122.413193133966) 8 4 7 28853 19
75533 100498 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1899X Harrison St 7 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008692.6 2107433.7 37.7671021827668 -122.413193133966 (37.7671021827668, -122.413193133966) 8 4 7 28853 19
63163 100499 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 201X Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x15   6008884.6 2107581.7 37.7675193335945 -122.412539495737 (37.7675193335945, -122.412539495737) 8 4 7 28853 19
102006 100500 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 201X Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x15   6008884.6 2107581.7 37.7675193335945 -122.412539495737 (37.7675193335945, -122.412539495737) 8 4 7 28853 19
180516 100501 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 201X Alabama St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x15   6008884.6 2107581.7 37.7675193335945 -122.412539495737 (37.7675193335945, -122.412539495737) 8 4 7 28853 19
9855 100502 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 201X Alabama St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x15   6008884.6 2107581.7 37.7675193335945 -122.412539495737 (37.7675193335945, -122.412539495737) 8 4 7 28853 19
135841 100503 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 201X Alabama St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 3x15   6008884.6 2107581.7 37.7675193335945 -122.412539495737 (37.7675193335945, -122.412539495737) 8 4 7 28853 19
64101 100504 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 201X Alabama St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 3x15   6008884.6 2107581.7 37.7675193335945 -122.412539495737 (37.7675193335945, -122.412539495737) 8 4 7 28853 19
96842 100505 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 201X Alabama St 7 Sidewalk: Curb side : Cutout Tree Private 2     3 3x15   6008884.6 2107581.7 37.7675193335945 -122.412539495737 (37.7675193335945, -122.412539495737) 8 4 7 28853 19
87256 100506 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 201X Alabama St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 3x15   6008884.6 2107581.7 37.7675193335945 -122.412539495737 (37.7675193335945, -122.412539495737) 8 4 7 28853 19
87592 100507 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 201X Alabama St 9 Sidewalk: Curb side : Cutout Tree Private 2     3 3x15   6008884.6 2107581.7 37.7675193335945 -122.412539495737 (37.7675193335945, -122.412539495737) 8 4 7 28853 19
164211 100508 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 201X Alabama St 10 Sidewalk: Curb side : Cutout Tree Private 2     3 3x15   6008884.6 2107581.7 37.7675193335945 -122.412539495737 (37.7675193335945, -122.412539495737) 8 4 7 28853 19
87584 100509 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1X Treat Ave 1 Sidewalk: Property side : Cutout Tree Private 2     3 18x18   6009122.9 2107982.7 37.7686337575832 -122.411743582031 (37.7686337575832, -122.411743582031) 8 4 7 28853 19
103614 100510 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1X Treat Ave 2 Sidewalk: Property side : Cutout Tree Private 2     3 18x18   6009122.9 2107982.7 37.7686337575832 -122.411743582031 (37.7686337575832, -122.411743582031) 8 4 7 28853 19
50026 100511 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1X Treat Ave 3 Sidewalk: Property side : Cutout Tree Private 2     3 18x18   6009122.9 2107982.7 37.7686337575832 -122.411743582031 (37.7686337575832, -122.411743582031) 8 4 7 28853 19
106604 100512 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1X Treat Ave 4 Sidewalk: Property side : Cutout Tree Private 2     3 18x18   6009122.9 2107982.7 37.7686337575832 -122.411743582031 (37.7686337575832, -122.411743582031) 8 4 7 28853 19
182555 100513 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1X Treat Ave 5 Sidewalk: Property side : Cutout Tree Private 2     3 18x18   6009122.9 2107982.7 37.7686337575832 -122.411743582031 (37.7686337575832, -122.411743582031) 8 4 7 28853 19
17822 100515 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1X Treat Ave 7 Sidewalk: Property side : Cutout Tree Private 2     3 18x18   6009122.9 2107982.7 37.7686337575832 -122.411743582031 (37.7686337575832, -122.411743582031) 8 4 7 28853 19
137135 100516 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1X Treat Ave 8 Sidewalk: Property side : Cutout Tree Private 2     3 18x18   6009122.9 2107982.7 37.7686337575832 -122.411743582031 (37.7686337575832, -122.411743582031) 8 4 7 28853 19
57633 100517 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6009099.31879 2107996.81824 37.7686712001098 -122.411826145608 (37.7686712001098, -122.411826145608) 8 4 7 28853 19
37661 100520 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X Florida St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6009099.31879 2107996.81824 37.7686712001098 -122.411826145608 (37.7686712001098, -122.411826145608) 8 4 7 28853 19
159948 100521 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X Florida St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6009099.31879 2107996.81824 37.7686712001098 -122.411826145608 (37.7686712001098, -122.411826145608) 8 4 7 28853 19
186675 100522 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2601 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008910 2103320 37.7558191060193 -122.412150412844 (37.7558191060193, -122.412150412844) 2 4 7 28859 19
191099 100527 Undocumented 4 Ficus nitida :: Laurel Fig 53 1728 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2       4.5x6   6008341 2118363 37.7970916696404 -122.415182998934 (37.7970916696404, -122.415182998934) 5 1 10 308 21
54753 100531 Undocumented 4 Cordyline australis :: Dracena Palm 64 689 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003067 2104228 37.7579826742399 -122.432422230009 (37.7579826742399, -122.432422230009) 2 4 5 28862 3
147648 100532 Undocumented 4 Cordyline australis :: Dracena Palm 64 685 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003065 2104250 37.7580429675673 -122.432430718154 (37.7580429675673, -122.432430718154) 2 4 5 28862 3
10813 100543 Undocumented 4 Acer spp :: Maple 88 290X Tehama St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x4                      
115446 100544 Undocumented 4 Rhaphiolepis indica :: India Hawthorn 293 95 Eagle St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6000135 2104379 37.7582305885461 -122.442573139957 (37.7582305885461, -122.442573139957) 2 4 5 28862 3
158688 100545 Undocumented 4 Rhaphiolepis indica :: India Hawthorn 293 95 Eagle St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5999799.7 2104413.1 37.7583051000651 -122.443735199357 (37.7583051000651, -122.443735199357) 2 4 5 28862 3
22842 100546 Undocumented 4 Rhaphiolepis indica :: India Hawthorn 293 95 Eagle St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5999799.7 2104413.1 37.7583051000651 -122.443735199357 (37.7583051000651, -122.443735199357) 2 4 5 28862 3
35333 100547 Undocumented 4 Rhaphiolepis indica :: India Hawthorn 293 95 Eagle St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5999799.7 2104413.1 37.7583051000651 -122.443735199357 (37.7583051000651, -122.443735199357) 2 4 5 28862 3
142505 100548 Undocumented 4 Rhaphiolepis indica :: India Hawthorn 293 95 Eagle St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5999799.7 2104413.1 37.7583051000651 -122.443735199357 (37.7583051000651, -122.443735199357) 2 4 5 28862 3
767 100549 Undocumented 4 Acer spp :: Maple 88 290X Tehama St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x4                      
144530 100554 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1050X Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007651 2109542 37.7728325469688 -122.416945272606 (37.7728325469688, -122.416945272606) 8 2 9 28853 19
77729 100555 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 1050X Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007651 2109542 37.7728325469688 -122.416945272606 (37.7728325469688, -122.416945272606) 8 2 9 28853 19
47442 100558 Undocumented 4 Maytenus boaria :: Mayten 58 30X Lafayette St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6007462.6 2109664.1 37.7731572051684 -122.417605627114 (37.7731572051684, -122.417605627114) 8 2 9 28853 19
99694 100559 Undocumented 4 Maytenus boaria :: Mayten 58 30X Lafayette St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007462.6 2109664.1 37.7731572051684 -122.417605627114 (37.7731572051684, -122.417605627114) 8 2 9 28853 19
80965 100560 Undocumented 4 Maytenus boaria :: Mayten 58 30X Lafayette St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007462.6 2109664.1 37.7731572051684 -122.417605627114 (37.7731572051684, -122.417605627114) 8 2 9 28853 19
63153 100561 Undocumented 4 Maytenus boaria :: Mayten 58 30X Lafayette St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007462.6 2109664.1 37.7731572051684 -122.417605627114 (37.7731572051684, -122.417605627114) 8 2 9 28853 19
176029 100562 Undocumented 4 Tree(s) :: 17 54 Lafayette St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6007557 2109603 37.7729947504972 -122.417274753769 (37.7729947504972, -122.417274753769) 8 2 9 28853 19
174676 100563 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 284 O'Farrell St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6009946.4 2114395 37.7862865916342 -122.409347728871 (37.7862865916342, -122.409347728871) 5 10 10 28852 36
68872 100564 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 312 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009858 2114440 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
159847 100565 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 312 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009858 2114440 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
33897 100566 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 312 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009858 2114440 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
34017 100567 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 312 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009858 2114440 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
113362 100569 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1529 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   5997859 2105434 37.7609973530127 -122.450520558131 (37.7609973530127, -122.450520558131) 15 5 11 29492 12
144921 100570 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1529 Shrader St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5997859 2105434 37.7609973530127 -122.450520558131 (37.7609973530127, -122.450520558131) 15 5 11 29492 12
55911 100649 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 50 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003141 2108015 37.7683850571797 -122.432436785894 (37.7683850571797, -122.432436785894) 15 5 5 28862 3
54213 100653 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1594 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x4   5992503 2104630 37.7584817696578 -122.468985951036 (37.7584817696578, -122.468985951036) 1 8 4 56 12
115503 100654 Undocumented 4 Tree(s) :: 17 590X Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2017 12:00:00 AM 3   Permit Number 778778 5992503 2104630 37.7584817696578 -122.468985951036 (37.7584817696578, -122.468985951036) 1 8 4 56 12
106719 100655 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 590X Lawton St 2 Sidewalk: Curb side : Cutout Tree Private 2           5992492.1 2104587.3 37.7583638968548 -122.469020540261 (37.7583638968548, -122.469020540261) 1 8 4 56 12
181165 100656 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 590X Lawton St 3 Sidewalk: Curb side : Cutout Tree Private 2           5992503 2104630 37.7584817696578 -122.468985951036 (37.7584817696578, -122.468985951036) 1 8 4 56 12
23377 100670 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
80554 100671 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
138476 100672 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
10172 100673 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
78061 100680 Undocumented 4 Myoporum laetum :: Myoporum 62 387 Beacon St   Front Yard : Cutout Tree Private 2         7' wide public RoW 6002378 2098199 37.7413893731095 -122.434374040118 (37.7413893731095, -122.434374040118) 2 7 5 63 7
233 100684 Undocumented 4 Tree(s) :: 17 400 California St 3 Sidewalk: Curb side : Pot Tree Private 2           6012367 2116823 37.7930886299645 -122.401143699021 (37.7930886299645, -122.401143699021) 4 1 10 28854 6
176215 100692 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 685X Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM 10 4x4 Permit Number 769119 6012690.8 2113888.8 37.7850500640854 -122.399817195016 (37.7850500640854, -122.399817195016) 6 2 9 28853 6
119771 100702 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 685X Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4   6012690.8 2113888.8 37.7850500640854 -122.399817195016 (37.7850500640854, -122.399817195016) 6 2 9 28853 6
119864 100703 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 685X Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4   6012690.8 2113888.8 37.7850500640854 -122.399817195016 (37.7850500640854, -122.399817195016) 6 2 9 28853 6
98811 100704 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 685X Howard St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4   6012690.8 2113888.8 37.7850500640854 -122.399817195016 (37.7850500640854, -122.399817195016) 6 2 9 28853 6
153180 100709 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 685X Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4   6012690.8 2113888.8 37.7850500640854 -122.399817195016 (37.7850500640854, -122.399817195016) 6 2 9 28853 6
95570 100719 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
13754 100722 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
107239 100723 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
90819 100724 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
130202 100725 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
109073 100726 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
142966 100727 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
83671 100728 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
175956 100729 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34
64137 100730 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1445X Harrison St 10 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009133 2108884.6 37.7711107319532 -122.411772383651 (37.7711107319532, -122.411772383651) 8 2 9 28853 34

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);