trees

Custom SQL query returning 25 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
6420 26181 1 299 480 Castro St 2 Sidewalk: Curb side : Cutout Tree 2   11/28/2006 12:00:00 AM 3 2x2 Permit Number 772904 6002282 2105385 37.7611149721712 -122.435219844509 (37.7611149721712, -122.435219844509) 15 4 5 28862 3
10628 28714 1 299 495 Castro St 1 Sidewalk: Curb side : Cutout Tree 2   04/07/2004 12:00:00 AM 3 3x3 Permit Number 772904 6002370.93683 2105344.55131 37.7610089599056 -122.434909357897 (37.7610089599056, -122.434909357897) 15 4 5 28862 3
18727 245360 1 299 427 Castro St 1 Sidewalk: Curb side : Cutout Tree 1   04/23/2018 12:00:00 AM 3 6x5   6002354.10634 2105669.80304 37.7619010667053 -122.434990829274 (37.7619010667053, -122.434990829274) 15 4 5 28862 3
24950 123160 1 299 475 10th Ave 3 Sidewalk: Property side : Yard Tree 2     5 Width 6ft   5992783.47528 2112204.70134 37.7792960831388 -122.468567076178 (37.7792960831388, -122.468567076178) 11 6 2 54 11
29385 221180 1 299 337 Shotwell St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6007817.66801 2105929.51758 37.7629228899011 -122.416112860719 (37.7629228899011, -122.416112860719) 8 4 7 28859 19
29444 221181 1 299 3390 22nd St 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6005792.21376 2103175.01124 37.7552455682348 -122.422922435533 (37.7552455682348, -122.422922435533) 2 4 5 28859 19
30012 221183 1 299 3484 16th St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6003685.99525 2106582.50887 37.7644826722523 -122.430449475988 (37.7644826722523, -122.430449475988) 8 4 5 28862 3
32411 221182 1 299 205 Montcalm St 1 Sidewalk: Property side : Yard Tree 2     9 Width 3ft   6010035.74465 2099690.44727 37.7459162585454 -122.408001257372 (37.7459162585454, -122.408001257372) 2 7 7 28859 2
34816 218218 1 299 399 Wawona St 2 Sidewalk: Curb side : Yard Tree 2     4 Width 4ft   5991827.81177 2097037.50439 37.73759570307 -122.470767994372 (37.73759570307, -122.470767994372) 1 8 4 59 40
66006 53249 1 299 348 Texas St 1 Sidewalk: Curb side : Cutout Tree 2   07/21/1969 12:00:00 AM 3   Permit Number 6134 6013733.31387 2105486.4947 37.7620372852031 -122.39562149856 (37.7620372852031, -122.39562149856) 10 3 8 28856 29
71034 188233 1 299 1301 Minnesota St 77 Front Yard : Yard Tree 2     6     6015365.73564 2102250.10516 37.7532415189935 -122.389749475967 (37.7532415189935, -122.389749475967) 10 3 8 28856 29
76362 247215 1 299 800 Duboce Ave 10 Sidewalk: Property side : Yard Tree 2     10 Width 6ft   6001826.705 2108295.2361 37.7690799013478 -122.437002868995 (37.7690799013478, -122.437002868995) 15 5 5 29492 9
79346 188238 1 299 1799 Revere Ave 5 Sidewalk: Curb side : Yard Tree 2     20     6014043.66547 2095150.32578 37.7336736103466 -122.393824573063 (37.7336736103466, -122.393824573063) 10 3 8 58 1
110226 221179 1 299 1706 Dolores St 2 Sidewalk: Property side : Yard Tree 2     7 Width 3ft   6005259.96974 2098394.13511 37.7420883355977 -122.424423058674 (37.7420883355977, -122.424423058674) 2 7 5 63 7
112153 120846 1 299 295 19th Ave 5 Sidewalk: Property side : Yard Tree 2     4 Width 2ft   5989915.56794 2113413.68819 37.7824495421017 -122.478576688059 (37.7824495421017, -122.478576688059) 11 6 2 55 26
113763 188236 1 299 1108 Rhode Island St 4 Sidewalk: Curb side : Yard Tree 2     4 Width 5ft   6011896.7371 2103246.34422 37.755783996849 -122.401816071954 (37.755783996849, -122.401816071954) 10 3 8 28856 29
119565 205610 1 299 120 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 2ft   5994595.146 2093153.51245 37.7270908589421 -122.460918655266 (37.7270908589421, -122.460918655266) 9 8 4 28861 40
127609 39589 1 299 1108 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/29/1998 12:00:00 AM 8   Permit Number 41000 6011896.10584 2103264.60859 37.7558341115663 -122.40181953886 (37.7558341115663, -122.40181953886) 10 3 8 28856 29
144532 98359 7 299 1250 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2   02/28/2012 12:00:00 AM   3x5 Permit Number 768652 6008140.4 2116796.9 37.7927802707336 -122.415766176937 (37.7927802707336, -122.415766176937) 5 1 10 28858 21
149875 188237 1 299 1740 20th St 4 Sidewalk: Property side : Yard Tree 2     11 Width 3ft   6012748.31397 2104746.48388 37.759950538805 -122.398976312419 (37.759950538805, -122.398976312419) 10 3 8 28856 29
155212 188234 1 299 1108 Rhode Island St 2 Sidewalk: Curb side : Yard Tree 2     4 Width 5ft   6011896.09568 2103259.40011 37.7558198096579 -122.401819207896 (37.7558198096579, -122.401819207896) 10 3 8 28856 29
172145 188235 1 299 1108 Rhode Island St 3 Sidewalk: Curb side : Yard Tree 2     4 Width 5ft   6011896.48245 2103252.68741 37.7558013996435 -122.40181739848 (37.7558013996435, -122.40181739848) 10 3 8 28856 29
175556 92081 7 299 25 Mirabel Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/23/2009 12:00:00 AM   3x3 Permit Number 52194 6007436.7 2099911.5 37.7463773607013 -122.41700407936 (37.7463773607013, -122.41700407936) 2 7 7 28859 2
178563 246275 1 299 338 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   6002907.6704 2106201.8811 37.7633934402788 -122.433114288821 (37.7633934402788, -122.433114288821) 15 4 5 28862 3
193368 246750 1 299 178 Ripley St 2 Sidewalk: Curb side : Pot Tree 2     4 Width 4ft   6009174.6087 2099095.18815 37.744233556835 -122.410936923308 (37.744233556835, -122.410936923308) 2 7 7 28859 2