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)
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
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
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
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
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
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
191085 40085 1 90 2770 Filbert St 1 Sidewalk: Curb side : Cutout Tree 2   02/19/1999 12:00:00 AM 12   Permit Number 41306 5999702.22145 2118468.61098 37.7968923736436 -122.445082782069 (37.7968923736436, -122.445082782069) 13 9 1 57 17
163569 99182 1 90 3124 Baker St 1 Sidewalk: Curb side : Cutout Tree 2     20 3x7   5999415.83241 2119586.98668 37.7999467842805 -122.446154238844 (37.7999467842805, -122.446154238844) 13 9 1 57 17
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
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
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
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
71452 142122 1 90 16 HEMWAY TER 1 Sidewalk: Curb side : Yard Tree 2     12 Width 0ft   5998654.7965 2110846.2756 37.7759036047997 -122.448157977873 (37.7759036047997, -122.448157977873) 15 6 2 29492 16
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
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
151144 126028 1 90 3436 Clay St 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 4ft   5998376.70601 2115562.57298 37.7888374239642 -122.449459861577 (37.7888374239642, -122.449459861577) 13 6 1 54 31
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
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
143612 141065 1 90 193 Cook St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 0ft   5997591.6366 2112595.3291 37.7806452152507 -122.451961919026 (37.7806452152507, -122.451961919026) 15 6 2 54 16
106398 51523 1 90 45 Parker Ave 2 Sidewalk: Curb side : Cutout Tree 2   01/13/2005 12:00:00 AM 2   Permit Number 47825 5996809.5439 2114270.1786 37.7851990807779 -122.454788580102 (37.7851990807779, -122.454788580102) 11 6 1 54 31
55113 51522 1 90 45 Parker Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/13/2005 12:00:00 AM 4   Permit Number 47825 5996807.8517 2114293.8682 37.7852640290514 -122.454796146743 (37.7852640290514, -122.454796146743) 11 6 1 54 31
53262 206050 1 90 54 Montana St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 2ft   5996176.33569 2089321.83975 37.7166608491878 -122.45517576096 (37.7166608491878, -122.45517576096) 9 8 6 28861 24
25846 106623 1 90 156 Commonwealth Ave 2 Sidewalk: Curb side : Cutout Tree 2     9 3x6   5996579.5862 2113331.5658 37.7826087063099 -122.455516294075 (37.7826087063099, -122.455516294075) 11 6 1 54 31
53721 123351 1 90 622 04th Ave 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   5994733.36441 2111254.23547 37.7767987999792 -122.46175271245 (37.7767987999792, -122.46175271245) 11 6 2 54 11
90181 206049 1 90 866 Pacheco St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 1ft   5992290.59671 2102926.23663 37.7537914058675 -122.469596501502 (37.7537914058675, -122.469596501502) 1 8 4 56 12
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
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
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
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
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
117355 182966 1 90 2430 21st Ave 1 Sidewalk: Curb side : Yard Tree 2     9 Width 0ft   5989858.6972 2098819.7917 37.7423753326027 -122.477706327536 (37.7423753326027, -122.477706327536) 1 8 3 29491 35
29042 120762 1 90 1914 Clement St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   5989545.85022 2113375.8297 37.7823241210205 -122.479852964119 (37.7823241210205, -122.479852964119) 11 6 2 55 26