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)
65 264979 4 35 2450 California St 1 Front Yard : Yard Tree 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
17997 122419 4 15 2200 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree 3       3x3   5998886 2091075 37.7216297132481 -122.445935857536 (37.7216297132481, -122.445935857536) 9 7 6 28861 25
20402 257888 8 28 155X Magellan Ave 1 Front Yard : Yard Tree 3       10x10   5995070 2100842 37.7482288640106 -122.459833790503 (37.7482288640106, -122.459833790503) 1 8 4 29491 40
36696 25401 7 14 495X Geneva Ave 1 Sidewalk: Curb side : Cutout Tree 3   06/28/1996 12:00:00 AM 8 3X3   5998682.3051661 2090785.318168 37.7208226804469 -122.446619141783 (37.7208226804469, -122.446619141783) 9 7 6 28861 25
52322 121200 1 384 423 18th Ave 1 Sidewalk: Curb side : Cutout Tree 3       3x3   5990242 2112483 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216) 11 6 2 55 26
54303 178335 6 15 401 Ocean Ave 1 Sidewalk: Property side : Yard Tree 3     33 Width 8ft   5998656.04486 2091523.12147 37.7228470175503 -122.446762975526 (37.7228470175503, -122.446762975526) 9 7 6 28861 25
90582 112375 6 127 801 ULLOA ST 1 Sidewalk: Curb side : Cutout Tree 3     42     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
95573 106226 4 53 350 Sutter St 1 Sidewalk: Curb side : Cutout Tree 3     22 3x5   6010879 2115572 37.7895705607022 -122.406204113006 (37.7895705607022, -122.406204113006) 5 1 10 28857 6
104414 120596 6 15 499x Ocean Ave 1 Sidewalk: Curb side : Cutout Tree 3     36 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
111666 225888 8 474 3255x 24th St 1 Front Yard : Cutout Tree 3     32 6x6   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
122810 251512 8 60 4116x 18th St 1 Back Yard : Yard Tree 3       3x3   6002190 2105341 37.7609889340227 -122.43553488468 (37.7609889340227, -122.43553488468) 15 4 5 28862 3
123567 116606 4 101 1325x 08TH AVE 1 Sidewalk: Property side : Cutout Tree 3       3x3   5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
124153 118318 8 58 20 Norton St 1 Front Yard : Yard Tree 3           6002015.68632 2092167.12899 37.7248066672809 -122.435195459751 (37.7248066672809, -122.435195459751) 9 7 6 28861 25
133848 27436 7 162 1690X Indiana St 1 Sidewalk: Curb side : Cutout Tree 3     6 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105) 10 3 8 58 1
141599 251417 9 56 418 19th Ave 1 Sidewalk: Curb side : Cutout Tree 3       3x3   5990003 2112517 37.7799925618685 -122.478208632121 (37.7799925618685, -122.478208632121) 11 6 2 55 26
143936 106224 4 53 340 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree 3     24 3x5   6010923.2 2115578.3 37.7895903312377 -122.406051628897 (37.7895903312377, -122.406051628897) 5 1 10 28857 6
152930 91827 7 148 1941 Harrison St 1 Sidewalk: Curb side : Cutout Tree 3   03/07/2007 12:00:00 AM 3 3x3   6008705.970676 2107189.131 37.7664314036014 -122.413129591178 (37.7664314036014, -122.413129591178) 8 4 7 28853 19
156649 251254 1 133 330 09th Ave 1 unknown : Cutout Tree 3       3x3   5993109 2113253 37.7821932251036 -122.467517213871 (37.7821932251036, -122.467517213871) 11 6 2 54 11
160410 116604 4 101 1325x 08TH AVE 1 Front Yard : Yard Tree 3           5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
179300 106217 1 38 585X Bush St 1 Sidewalk: Curb side : Cutout Tree 3     10 3x5   6010670.9358 2115847.83327 37.7903162925068 -122.406943445993 (37.7903162925068, -122.406943445993) 5 1 10 28857 6
183279 116347 4 60 4051X 24TH ST 1 Sidewalk: Curb side : Cutout Tree 3     10 3x3   6002850 2101803 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
20043 116577 6 66 3000x 19TH AVE 1 Sidewalk: Property side : Cutout Tree 3 DPW   30 3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
43131 116576 6 52 2500x OCEAN AVE 1 Sidewalk: Property side : Yard Tree 3 DPW   30 10X10   5991377 2094742 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256) 1 8 4 64 40
102606 116620 4 9 5732X GEARY BLVD 1 Front Yard : Cutout Tree 3 DPW   12 3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
135904 116578 6 62 2699x OCEAN AVE 1 Sidewalk: Property side : Cutout Tree 3 DPW   11 3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
22616 116522 1 62 324 08TH AVE 1 Sidewalk: Property side : Cutout Tree 3 DPW for City Agency   8 3x3   5993416 2113304 37.7823509768718 -122.466458848407 (37.7823509768718, -122.466458848407) 11 6 2 54 11
61507 116527 1 9 5732 GEARY BLVD 1 Sidewalk: Curb side : Yard Tree 3 DPW for City Agency     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
141285 120542 1 35 2450 California St 1 Front Yard : Yard Tree 3 DPW for City Agency         6002644.10897 2115479.97736 37.7888538273233 -122.434689351726 (37.7888538273233, -122.434689351726) 13 9 1 29490 27
46746 117011 4 58 457X CASTRO ST 1 Back Yard : Cutout Tree 3 Private   27 3x6   6002348 2105584 37.7616651256499 -122.435005811888 (37.7616651256499, -122.435005811888) 15 4 5 28862 3