trees

Custom SQL query returning 57 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
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
196 116631 4 9 5732X GEARY BLVD 12 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
416 116621 4 9 5732X GEARY BLVD 2 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
6720 116625 4 9 5732X GEARY BLVD 6 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
34791 116627 4 9 5732X GEARY BLVD 8 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
36632 116630 4 9 5732X GEARY BLVD 11 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
85516 116628 4 9 5732X GEARY BLVD 9 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
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
107761 116629 4 9 5732X GEARY BLVD 10 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
134678 116624 4 9 5732X GEARY BLVD 5 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
148169 116626 4 60 5732X GEARY BLVD 7 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
167673 116622 4 9 5732X GEARY BLVD 3 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
174243 116623 4 9 5732X GEARY BLVD 4 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
2069 116350 4 212 4051X 24TH ST 4 Sidewalk: Curb side : Cutout Tree 3       3x3   6002850 2101803 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
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
23271 91828 7 148 1941 Harrison St 2 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
32163 116349 4 60 4051X 24TH ST 3 Sidewalk: Curb side : Cutout Tree 3       3x3   6002850 2101803 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
39321 120597 6 15 499x Ocean Ave 5 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
43658 116348 4 60 4051X 24TH ST 2 Sidewalk: Curb side : Cutout Tree 3       3x3   6002850 2101803 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
44800 120594 6 15 499x Ocean Ave 2 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 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
80257 122411 6 57 499x Ocean Ave 8 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
82544 91762 7 32 1940 Harrison St   Sidewalk: Curb side : Cutout Tree 3   03/07/2007 12:00:00 AM 3 3x3   6008660.813755 2107281.610975 37.7666827970273 -122.413292321769 (37.7666827970273, -122.413292321769) 8 4 7 28853 19
87948 116353 4 60 4051X 24TH ST 7 Sidewalk: Curb side : Cutout Tree 3       3x3   6002850 2101803 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
92548 122410 6 57 499x Ocean Ave 7 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
95104 120593 6 16 499x Ocean Ave 4 Sidewalk: Curb side : Cutout Tree 3     34 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
100401 116352 4 60 4051X 24TH ST 6 Sidewalk: Curb side : Cutout Tree 3       3x3   6002850 2101803 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
102801 122418 6 57 499x Ocean Ave 15 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
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
116578 120595 6 15 499x Ocean Ave 3 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
136955 122414 6 57 499x Ocean Ave 11 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
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
141801 122417 6 57 499x Ocean Ave 14 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
145690 116607 4 101 1325x 08TH AVE 2 Sidewalk: Curb side : Cutout Tree 3       3x3   5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
146536 91829 7 148 1941 Harrison St 3 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
148884 122413 6 57 499x Ocean Ave 10 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
149548 122416 6 57 499x Ocean Ave 13 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
151876 116351 4 60 4051X 24TH ST 5 Sidewalk: Curb side : Cutout Tree 3       3x3   6002850 2101803 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
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
153596 116608 4 101 1325x 08TH AVE 3 Sidewalk: Curb side : Cutout Tree 3       3x3   5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
156105 122412 6 57 499x Ocean Ave 9 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
162242 116354 4 60 4051X 24TH ST 8 Sidewalk: Curb side : Cutout Tree 3     10 3x3   6002850 2101803 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
162950 122415 6 57 499x Ocean Ave 12 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
166166 120598 6 15 499x Ocean Ave 6 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
173056 122420 4 31 2200 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree 3       3x3   5998886 2091075 37.7216297132481 -122.445935857536 (37.7216297132481, -122.445935857536) 9 7 6 28861 25
178661 121201 1 127 423 18th Ave 2 Sidewalk: Curb side : Cutout Tree 3       3x3   5990242 2112483 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216) 11 6 2 55 26
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
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
6915 116579 6 66 3000x 19TH AVE 2 Sidewalk: Property side : Cutout Tree 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
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
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
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
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
136506 173630 6 62 2699x OCEAN AVE 2 Sidewalk: Property side : Cutout Tree 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
145371 116609 4 101 1325x 08TH AVE 4 Sidewalk: Property side : Cutout Tree 3       3x3   5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
161563 116580 6 66 3000x 19TH AVE 3 Sidewalk: Property side : Cutout Landscaping 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
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