trees

Custom SQL query returning 39 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
133175 162236 1 90 403 Leland Ave 2 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   6008707.08373 2087980.38348 37.7136884504429 -122.411768311455 (37.7136884504429, -122.411768311455) 9 7 8 309 39
188098 175851 1 90 401 Leland Ave 2 Sidewalk: Curb side : Cutout Tree 2     18 Width 3ft   6008594.06768 2088021.58529 37.7137952413274 -122.41216184759 (37.7137952413274, -122.41216184759) 9 7 8 309 39
26710 40518 7 90 141 Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout Tree 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
39640 40517 7 90 141 Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
45446 40519 7 90 141 Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
49999 40514 7 90 141 Junipero Serra Blvd 8 Sidewalk: Curb side : Cutout Tree 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
54107 40522 7 90 141 Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
77077 40515 7 90 141 Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
129069 42588 7 90 121 Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree 2   06/26/2000 12:00:00 AM     Permit Number 42664 5991652.84779157 2095347.0788302 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136) 9 8 4 59 40
132650 40516 7 90 141 Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout Tree 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
135827 42589 7 90 121 Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree 2   06/26/2000 12:00:00 AM     Permit Number 42664 5991652.84779157 2095347.0788302 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136) 9 8 4 59 40
139635 42590 7 90 121 Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree 2   06/26/2000 12:00:00 AM     Permit Number 42664 5991652.84779157 2095347.0788302 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136) 9 8 4 59 40
173411 40523 7 90 141 Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout Tree 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
8672 175850 1 90 44 Curtis St 1 Sidewalk: Curb side : Cutout Tree 2     18 Width 5ft   6000539.62692 2088348.79811 37.7142384641087 -122.440024342845 (37.7142384641087, -122.440024342845) 9 7 6 28861 5
143925 175849 1 90 986 Athens St 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   6002153.04681 2088139.00774 37.713754143201 -122.434432752284 (37.713754143201, -122.434432752284) 9 7 6 28861 5
191408 175848 1 90 900 Vienna St 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 4ft   6002108.06583 2088596.52311 37.7150078260217 -122.434620917447 (37.7150078260217, -122.434620917447) 9 7 6 28861 5
9272 245113 1 90 265 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   5999808.2851 2109439.1163 37.7721057759535 -122.444066643429 (37.7721057759535, -122.444066643429) 15 5 11 29492 9
33803 247397 1 90 313 Scott St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   6002217.7088 2109675.3523 37.7728915755216 -122.435749167904 (37.7728915755216, -122.435749167904) 15 5 11 29492 9
43223 117532 4 90 257 Central Ave 6 Sidewalk: Curb side : Cutout Tree 2       3x3   5999766.4 2109434.7 37.7720912604321 -122.444211209505 (37.7720912604321, -122.444211209505) 15 5 11 29492 9
46049 244486 1 90 267 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 0ft   5999805.9584 2109458.3944 37.7721585760078 -122.444076077102 (37.7721585760078, -122.444076077102) 15 5 11 29492 9
48468 115995 1 90 640 CLAYTON ST 2 Sidewalk: Curb side : Cutout Tree 2       5x5   5998607 2108438 37.7692883636191 -122.448149870984 (37.7692883636191, -122.448149870984) 15 5 11 29492 9
57991 41088 7 90 753 Cole St 2 Sidewalk: Curb side : Cutout Tree 2   11/01/1999 12:00:00 AM     Permit Number 41839 5997940.8911805 2107832.91164834 37.7675888440052 -122.450410271522 (37.7675888440052, -122.450410271522) 15 5 11 29492 9
60442 246062 1 90 644 Clayton St 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   5998535.261 2108439.0074 37.7692870283806 -122.448398084106 (37.7692870283806, -122.448398084106) 15 5 11 29492 9
64002 245168 7 90 233 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/21/1974 12:00:00 AM 20 Width 0ft Permit Number 14310 5999825.2365 2109323.448 37.7717891470569 -122.443999694963 (37.7717891470569, -122.443999694963) 15 5 11 29492 9
79211 244487 1 90 255 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   5999812.606 2109402.2221 37.772004720305 -122.444049045701 (37.772004720305, -122.444049045701) 15 5 11 29492 9
87261 225215 1 90 786 Cole St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   5998022.25403 2107604.08202 37.7669651923219 -122.450112353917 (37.7669651923219, -122.450112353917) 15 5 11 29492 9
96819 245114 1 90 257 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 0ft   5999810.2794 2109420.503 37.7720547823085 -122.444058407339 (37.7720547823085, -122.444058407339) 15 5 11 29492 9
98435 117530 4 90 257 Central Ave 4 Sidewalk: Curb side : Cutout Tree 2       3x3   5999766.4 2109434.7 37.7720912604321 -122.444211209505 (37.7720912604321, -122.444211209505) 15 5 11 29492 9
100336 246061 1 90 644 Clayton St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   5998536.4724 2108422.6546 37.7692421970101 -122.448392716164 (37.7692421970101, -122.448392716164) 15 5 11 29492 9
104501 57046 7 90 233 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/21/1974 12:00:00 AM   3x3 Permit Number 14310 5999827.54945588 2109277.32348014 37.7716626327266 -122.443988379661 (37.7716626327266, -122.443988379661) 15 5 11 29492 9
109899 115994 1 90 640 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree 2   05/13/2016 12:00:00 AM 3 5x5   5998607 2108438 37.7692883636191 -122.448149870984 (37.7692883636191, -122.448149870984) 15 5 11 29492 9
111522 245133 1 90 247 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 0ft   5999815.2651 2109384.2736 37.7719555899544 -122.444038557826 (37.7719555899544, -122.444038557826) 15 5 11 29492 9
116824 247477 1 90 864 Page St 1 Sidewalk: Curb side : Yard Tree 2     14 Width 0ft   6002445.2342 2109547.3008 37.7725528991659 -122.434952972157 (37.7725528991659, -122.434952972157) 15 5 11 29492 9
136970 245134 1 90 245 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   5999817.9241 2109365.3279 37.7719037215376 -122.444027998646 (37.7719037215376, -122.444027998646) 15 5 11 29492 9
144437 111361 1 90 404x ASHBURY ST 1 Sidewalk: Curb side : Cutout Tree 2   07/27/2015 12:00:00 AM 3 9x3   5998929 2109293 37.7716543786165 -122.447097632764 (37.7716543786165, -122.447097632764) 15 5 11 29492 9
146118 245157 1 90 241 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   5999819.9184 2109349.706 37.771860941516 -122.444019977581 (37.771860941516, -122.444019977581) 15 5 11 29492 9
157110 111362 1 90 404x ASHBURY ST 2 Sidewalk: Curb side : Cutout Tree 2   07/27/2015 12:00:00 AM 3 9x3   5998929 2109293 37.7716543786165 -122.447097632764 (37.7716543786165, -122.447097632764) 15 5 11 29492 9
172064 101679 4 90 257 Central Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5999766.4 2109434.7 37.7720912604321 -122.444211209505 (37.7720912604321, -122.444211209505) 15 5 11 29492 9
183065 117531 4 90 257 Central Ave 5 Sidewalk: Curb side : Cutout Tree 2       3x3   5999766.4 2109434.7 37.7720912604321 -122.444211209505 (37.7720912604321, -122.444211209505) 15 5 11 29492 9