trees

Custom SQL query returning 31 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
502 251299 2 27 2190X Market St 3 Sidewalk: Curb side : Cutout Tree 2       4X4   6003624.7851 2107240.8343 37.7662868072343 -122.430708166736 (37.7662868072343, -122.430708166736) 7 4 5 28862 3
1810 253859 2 68 130 Graystone Ter 1 Front Yard : Yard Tree 2       6x6 Permit Number 780749 5998952.88335 2104176.47413 37.7576070480405 -122.446646826709 (37.7576070480405, -122.446646826709) 2 5 5 28862 3
26464 251519 2 11 173 Sanchez St 2 Sidewalk: Curb side : Cutout Tree 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
40639 251525 2 31 173 Sanchez St 8 Sidewalk: Curb side : Cutout Tree 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
58500 251298 2 27 2190X Market St 4 Sidewalk: Curb side : Cutout Tree 2       4X4   6003624.7851 2107240.8343 37.7662868072343 -122.430708166736 (37.7662868072343, -122.430708166736) 7 4 5 28862 3
69646 251523 2 11 173 Sanchez St 6 Sidewalk: Curb side : Cutout Tree 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
72617 251297 2 27 2190X Market St 5 Sidewalk: Curb side : Cutout Tree 2       4X4   6003624.7851 2107240.8343 37.7662868072343 -122.430708166736 (37.7662868072343, -122.430708166736) 7 4 5 28862 3
96451 225775 2 22 577 Castro St 2 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft Permit Number 782239 6002401.77617 2104846.28665 37.75964259654 -122.43476706624 (37.75964259654, -122.43476706624) 2 4 5 28862 3
110069 116528 2 45 125 CROWN TER 1 Sidewalk: Property side : Cutout Tree 2     3 3x3   5998841 2104182 37.7576158290564 -122.447034160915 (37.7576158290564, -122.447034160915) 2 5 5 28862 3
115253 251524 2 11 173 Sanchez St 7 Sidewalk: Curb side : Cutout Tree 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
129120 246406 2 11 173 Sanchez St 1 Sidewalk: Curb side : Cutout Tree 2     16 3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
132560 251521 2 11 173 Sanchez St 4 Sidewalk: Curb side : Cutout Tree 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
141915 225774 2 22 577 Castro St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft Permit Number 782239 6002400.68275 2104833.82508 37.7596083179996 -122.434769956692 (37.7596083179996, -122.434769956692) 2 4 5 28862 3
165093 251522 2 11 173 Sanchez St 5 Sidewalk: Curb side : Cutout Tree 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
166298 251296 2 27 2190X Market St 2 Sidewalk: Curb side : Cutout Tree 2       4X4   6003624.7851 2107240.8343 37.7662868072343 -122.430708166736 (37.7662868072343, -122.430708166736) 7 4 5 28862 3
194230 251520 2 11 173 Sanchez St 3 Sidewalk: Curb side : Cutout Tree 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
4743 167761 2 3 451 Buena Vista Ave East 1 Sidewalk: Curb side : Cutout Tree 2   01/24/2020 12:00:00 AM 3 4x4 Permit Number 780770 6000439.87639 2107208.3352 37.7660166188918 -122.441721798828 (37.7660166188918, -122.441721798828) 15 5 5 29492 3
83711 258012 2 1 238 Eureka St 1 Sidewalk: Curb side : Cutout Tree 2   02/12/2019 12:00:00 AM 3 3x3 Permit Number 781835 6001423.51445 2104434.57022 37.7584565353532 -122.438120885556 (37.7584565353532, -122.438120885556) 2 4 5 28862 3
124846 258137 2 22 460 Noe St 1 Sidewalk: Curb side : Cutout Tree 2   04/09/2019 12:00:00 AM 3 3x3 Permit Number 782442 6002949.79782 2105560.87431 37.7616357801338 -122.432922786357 (37.7616357801338, -122.432922786357) 15 4 5 28862 3
84485 240578 2 17 3636 21st St 1 Sidewalk: Curb side : Cutout Tree 2   04/17/2019 12:00:00 AM 3 4x4 Permit Number 782238 6004112.69332 2103663.95963 37.7564931932291 -122.428765570083 (37.7564931932291, -122.428765570083) 2 4 5 28862 3
100975 167561 2 22 435 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree 2   07/03/2018 12:00:00 AM 3 4x4 Permit Number 774490 6003882.17352 2108345.65445 37.7693349544628 -122.429896723864 (37.7693349544628, -122.429896723864) 7 9 5 28862 3
13014 167662 2 19 24 Ord St 1 Sidewalk: Curb side : Cutout Tree 2   07/12/2017 12:00:00 AM 3 3x6   6000818.42136 2106216.38176 37.7633145212709 -122.440341345773 (37.7633145212709, -122.440341345773) 15 5 5 28862 3
11143 258742 2 14 367 Liberty St 1 Sidewalk: Curb side : Cutout Tree 2   07/17/2019 12:00:00 AM 3 3x3 Permit Number 774042 6003945 2103884 37.7570878795298 -122.429361203627 (37.7570878795298, -122.429361203627) 2 4 5 28862 3
12677 259879 2 1 10 Romain St 1 Sidewalk: Curb side : Cutout Tree 2   08/01/2019 12:00:00 AM 3 3x3 Permit Number 776294 6001192.18773 2103413.52714 37.7556398401092 -122.438847746407 (37.7556398401092, -122.438847746407) 2 4 5 28862 3
41331 14313 2 27 2190X Market St 7 Sidewalk: Curb side : Cutout Tree 2   08/03/2018 12:00:00 AM 3 4x4 Permit Number 782146 6003603.86 2107219.9092 37.7662281664546 -122.430779049243 (37.7662281664546, -122.430779049243) 7 4 5 28862 3
133945 14312 2 27 2190X Market St 6 Sidewalk: Curb side : Cutout Tree 2   08/03/2018 12:00:00 AM 3 4x4 Permit Number 782146 6003624.7851 2107240.8343 37.7662868072343 -122.430708166736 (37.7662868072343, -122.430708166736) 7 4 5 28862 3
84809 167131 2 19 4540 19th St 1 Sidewalk: Curb side : Cutout Tree 2   09/20/2018 12:00:00 AM 3 3x3 Permit Number 780648 6000902.50099 2104660.33643 37.7590467894041 -122.439938965707 (37.7590467894041, -122.439938965707) 2 4 5 28862 3
34077 256492 2 36 280 Diamond St 2 Sidewalk: Curb side : Cutout Tree 2   10/17/2018 12:00:00 AM 3 3x3 Permit Number 780675 6001741.51076 2104267.16046 37.7580149486389 -122.437009129166 (37.7580149486389, -122.437009129166) 2 4 5 28862 3
38312 167082 2 36 280 Diamond St 1 Sidewalk: Curb side : Cutout Tree 2   10/17/2018 12:00:00 AM 3 3x3 Permit Number 780675 6001741.51076 2104267.16046 37.7580149486389 -122.437009129166 (37.7580149486389, -122.437009129166) 2 4 5 28862 3
761 224987 2 50 484 Sanchez St 2 Sidewalk: Curb side : Cutout Tree 2   11/12/2019 12:00:00 AM 3 4x4 Permit Number 782366 6003591.74199 2105457.02251 37.7613870178149 -122.430695151865 (37.7613870178149, -122.430695151865) 15 4 5 28862 3
4536 224986 2 50 484 Sanchez St 1 Sidewalk: Curb side : Cutout Tree 2   11/12/2019 12:00:00 AM 3 4x4 Permit Number 782366 6003589.47712 2105476.68017 37.7614408647212 -122.430704387917 (37.7614408647212, -122.430704387917) 15 4 5 28862 3