trees

Custom SQL query returning 29 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
99367 176074 1 133 786 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 2ft   6001892.13578 2089268.05693 37.7168394482606 -122.435415271495 (37.7168394482606, -122.435415271495) 9 7 6 28861 5
124950 176073 1 133 774 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 2ft   6001923.16259 2089317.3719 37.7169766182659 -122.43531155268 (37.7169766182659, -122.43531155268) 9 7 6 28861 5
136667 206535 1 133 665 Miramar Ave 3 Sidewalk: Curb side : Cutout Tree 2     5 Width 2ft   5995362.41808 2093767.65006 37.7288212525964 -122.458310655534 (37.7288212525964, -122.458310655534) 9 7 4 28861 40
128797 206534 1 133 665 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 2ft   5995362.10243 2093779.40423 37.7288535085691 -122.458312597175 (37.7288535085691, -122.458312597175) 9 7 4 28861 40
126152 206533 1 133 665 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 2ft   5995361.50595 2093791.16395 37.7288857636427 -122.458315510062 (37.7288857636427, -122.458315510062) 9 7 4 28861 40
126227 206696 1 133 230 Baden St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 2ft   6000774.6257 2094855.98841 37.7321191034008 -122.439678327791 (37.7321191034008, -122.439678327791) 9 7 4 63 40
76572 223055 1 133 42 Sussex St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 2ft   6002598.631 2096412.43412 37.7364963969952 -122.433483533142 (37.7364963969952, -122.433483533142) 2 7 5 63 7
140979 206548 1 133 160 Dorantes Ave 3 Sidewalk: Curb side : Cutout Tree 2     8 Width 2ft   5993741.10567 2099827.07051 37.7453656117262 -122.464355354239 (37.7453656117262, -122.464355354239) 1 8 4 29491 40
14448 206509 1 133 1023 Lawton St 2 Sidewalk: Curb side : Cutout Tree 2     1 Width 2ft   5990938.9472 2104480.79856 37.7579816107664 -122.474384202485 (37.7579816107664, -122.474384202485) 1 8 4 56 12
159595 206508 1 133 1023 Lawton St 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 2ft   5990927.20691 2104481.04629 37.7579816107755 -122.474424823051 (37.7579816107755, -122.474424823051) 1 8 4 56 12
43073 206510 1 133 1023 Lawton St 3 Sidewalk: Curb side : Cutout Tree 2     2 Width 2ft   5990951.63934 2104480.53076 37.7579816107816 -122.474340288587 (37.7579816107816, -122.474340288587) 1 8 4 56 12
63353 206511 1 133 1023 Lawton St 4 Sidewalk: Curb side : Cutout Tree 2     2 Width 2ft   5990966.24876 2104480.85465 37.7579833464788 -122.474289787164 (37.7579833464788, -122.474289787164) 1 8 4 56 12
130434 206512 1 133 1023 Lawton St 5 Sidewalk: Curb side : Cutout Tree 2     3 Width 2ft   5990980.22345 2104481.19226 37.7579850830548 -122.474241481884 (37.7579850830548, -122.474241481884) 1 8 4 56 12
117905 206513 1 133 1023 Lawton St 6 Sidewalk: Curb side : Cutout Tree 2     3 Width 2ft   5990992.34085 2104483.78156 37.757992894562 -122.47419976413 (37.757992894562, -122.47419976413) 1 8 4 56 12
155534 206514 1 133 1023 Lawton St 7 Sidewalk: Curb side : Cutout Tree 2     4 Width 2ft   5991006.3222 2104484.4348 37.7579954981234 -122.474151458838 (37.7579954981234, -122.474151458838) 1 8 4 56 12
22339 206516 1 133 1019 Lawton St 3 Sidewalk: Curb side : Cutout Tree 2     1 Width 2ft   5991047.26108 2104483.88717 37.7579963659448 -122.474009836278 (37.7579963659448, -122.474009836278) 1 8 4 56 12
181480 206515 1 133 1019 Lawton St 2 Sidewalk: Curb side : Cutout Tree 2     3 Width 2ft   5991033.61709 2104484.17502 37.7579963659675 -122.474057043516 (37.7579963659675, -122.474057043516) 1 8 4 56 12
73036 206517 1 133 1019 Lawton St 4 Sidewalk: Curb side : Cutout Tree 2     2 Width 2ft   5991060.29058 2104484.56084 37.7579989703891 -122.473964824336 (37.7579989703891, -122.473964824336) 1 8 4 56 12
167985 206518 1 133 1019 Lawton St 5 Sidewalk: Curb side : Cutout Tree 2     2 Width 2ft   5991072.98938 2104484.60902 37.7579998382313 -122.473920910448 (37.7579998382313, -122.473920910448) 1 8 4 56 12
114669 206502 1 133 245 Lawton St 5 Sidewalk: Curb side : Cutout Tree 2     4 Width 2ft   5993453.26762 2104570.92091 37.7583744121607 -122.465695235269 (37.7583744121607, -122.465695235269) 1 8 4 56 12
114457 206501 1 133 245 Lawton St 4 Sidewalk: Curb side : Cutout Tree 2     4 Width 2ft   5993462.44278 2104571.82213 37.7583774159051 -122.465663569242 (37.7583774159051, -122.465663569242) 1 8 4 56 12
35595 206499 1 133 245 Lawton St 2 Sidewalk: Curb side : Cutout Tree 2     3 Width 2ft   5993488.07663 2104571.64852 37.7583784177465 -122.46557490416 (37.7583784177465, -122.46557490416) 1 8 4 56 12
32203 206500 1 133 245 Lawton St 3 Sidewalk: Curb side : Cutout Tree 2     4 Width 2ft   5993474.54652 2104572.66216 37.7583804205467 -122.465621770525 (37.7583804205467, -122.465621770525) 1 8 4 56 12
62155 206498 1 133 245 Lawton St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 2ft   5993516.66966 2104572.87128 37.7583834242608 -122.465476106443 (37.7583834242608, -122.465476106443) 1 8 4 56 12
119257 223030 1 133 125 Belgrave Ave 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   5997950.67072 2104889.0935 37.7595064230002 -122.450164233094 (37.7595064230002, -122.450164233094) 15 5 11 28862 12
192064 223029 1 133 170 Belgrave Ave 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 2ft   5997728.70717 2104908.9589 37.75954826396 -122.450933321612 (37.75954826396, -122.450933321612) 15 5 11 29492 12
8606 190946 1 133 40 Bluxome St 6 Sidewalk: Curb side : Cutout Tree 2     2 Width 2ft   6013405.51497 2110852.0091 37.7767515500726 -122.397131477343 (37.7767515500726, -122.397131477343) 6 2 9 28856 34
114901 126377 1 133 122 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 2ft   6001345.97363 2121147.25207 37.8043408951819 -122.439587150049 (37.8043408951819, -122.439587150049) 13 9 1 57 17
59033 126376 1 133 122 Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 2ft   6001336.2876 2121154.5777 37.8043604581295 -122.439621194774 (37.8043604581295, -122.439621194774) 13 9 1 57 17