trees

Custom SQL query returning 35 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
14802 11429 1 53 810X Mendell St 2 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6016007.44377 2096780.42114 37.7382584597776 -122.387148815626 (37.7382584597776, -122.387148815626) 10 3 8 58 1
14874 6756 1 53 1215 Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree 1     18 3x3 Permit Number 769095 6017521.0990665 2096743.3718322 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319) 10 3 8 58 1
19076 99594 4 53 1855X Evans Ave 9 Sidewalk: Curb side : Cutout Tree 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
27391 6825 7 53 1450X Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
28345 6727 1 53 1200X Fairfax Ave 24 Sidewalk: Curb side : Cutout Tree 1     16 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
29445 26153 7 53 1500 Oakdale Ave 24 Sidewalk: Curb side : Cutout Tree 5     12 3X3   6015586.3934773 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626) 10 3 8 58 1
37080 6828 7 53 1450X Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
39117 14994 1 53 1459X Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6016235.7427248 2097702.9858463 37.7408042749191 -122.38642376985 (37.7408042749191, -122.38642376985) 10 3 8 58 1
41806 6719 1 53 1200X Fairfax Ave 16 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
46216 6816 7 53 1400X Fairfax Ave 8 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1
52126 22281 7 53 4755X 03rd St 5 Sidewalk: Curb side : Cutout Tree 19     18 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
52462 116125 4 53 2500X Keith St 1 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
63265 6801 7 53 1385 Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6016634.4993322 2097405.4643513 37.7400094064471 -122.385024282227 (37.7400094064471, -122.385024282227) 10 3 8 58 1
66362 6799 1 53 1375 Fairfax Ave 8 Sidewalk: Curb side : Cutout Tree 1     12 3x9   6016685.6205969 2097367.3215875 37.7399075017412 -122.384844867735 (37.7399075017412, -122.384844867735) 10 3 8 58 1
72329 6726 1 53 1200X Fairfax Ave 23 Sidewalk: Curb side : Cutout Tree 1     16 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
74408 6773 1 53 1355 Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6016787.8631263 2097291.0360599 37.7397036915046 -122.384486040227 (37.7397036915046, -122.384486040227) 10 3 8 58 1
78348 6705 1 53 1200X Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
89965 116128 4 53 2500X Keith St 4 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
101295 29407 7 53 2801X Ingalls St 1 Sidewalk: Curb side : Cutout Tree 2     9 3X3   6014804.18454 2090650.03815 37.7213589569903 -122.390880803843 (37.7213589569903, -122.390880803843) 10 3 8 58 1
102193 6752 1 53 1215 Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree 1     16 3x3   6017539.76894 2096719.16796 37.738175006759 -122.381846478456 (37.738175006759, -122.381846478456) 10 3 8 58 1
110376 25995 1 53 1781 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree 1     12 2X2   6014085.16035 2096167.03762 37.7364675981514 -122.39375225191 (37.7364675981514, -122.39375225191) 10 3 8 58 1
115268 6817 7 53 1400X Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1
122922 99595 4 53 1855X Evans Ave 10 Sidewalk: Curb side : Cutout Tree 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
122954 6709 1 53 1200X Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
129171 27857 7 53 1450X Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
142509 6722 1 53 1200X Fairfax Ave 19 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
149060 6808 1 53 1395 Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6016583.3780675 2097443.6071151 37.7401113108781 -122.385203697211 (37.7401113108781, -122.385203697211) 10 3 8 58 1
150567 25558 1 53 50X Industrial St 3 Sidewalk: Curb side : Cutout Tree 1   01/23/2001 12:00:00 AM 8 4X4   6012204.29417 2097469.52586 37.7399392564551 -122.400346698766 (37.7399392564551, -122.400346698766) 10 3 8 58 1
158152 6829 7 53 1450X Fairfax Ave 11 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
163580 116126 4 53 2500X Keith St 2 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
169622 6721 1 53 1200X Fairfax Ave 18 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
174144 116127 4 53 2500X Keith St 3 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
188021 6788 1 53 1390 Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6016787.1910829 2097353.9213772 37.7398763247169 -122.384492742853 (37.7398763247169, -122.384492742853) 10 3 8 58 1
188909 6818 7 53 1400X Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1
190734 6815 7 53 1400X Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1