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)
55400 18519 1 54 1700X Powell St 1 Sidewalk: Curb side : Cutout Tree 5     30 3X3   6009627.5943 2119520.0726 37.8003409270103 -122.410812809398 (37.8003409270103, -122.410812809398) 3 1 10 308 4
37866 67753 1 54 900 Kearny St 1 Sidewalk: Curb side : Cutout Tree 2   12/04/1992 12:00:00 AM 11 3x3 Permit Number 31377 6011258.7412 2118020.5233 37.79631485229 -122.405062718866 (37.79631485229, -122.405062718866) 3 1 10 308 4
76001 115985 1 54 900 Kearny St 4 Sidewalk: Curb side : Cutout Tree 2     9 3x3   6011253.148 2118063.4049 37.7964322821358 -122.405085093558 (37.7964322821358, -122.405085093558) 3 1 10 308 4
109940 258056 4 54 600 California St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6011288 2116842 37.793080546408 -122.404878460446 (37.793080546408, -122.404878460446) 3 1 10 28857 4
120425 258058 4 54 600 California St 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6011288 2116842 37.793080546408 -122.404878460446 (37.793080546408, -122.404878460446) 3 1 10 28857 4
137907 258057 4 54 600 California St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6011288 2116842 37.793080546408 -122.404878460446 (37.793080546408, -122.404878460446) 3 1 10 28857 4
153254 115984 1 54 900 Kearny St 3 Sidewalk: Curb side : Cutout Tree 2     10 3x3   6011255.4785 2118051.2862 37.7963991373929 -122.405076175742 (37.7963991373929, -122.405076175742) 3 1 10 308 4
158367 115983 1 54 900 Kearny St 2 Sidewalk: Curb side : Cutout Tree 2     10 3x3   6011256.8768 2118034.0404 37.796351862759 -122.405070122367 (37.796351862759, -122.405070122367) 3 1 10 308 4
191059 258059 4 54 600 California St 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6011288 2116842 37.793080546408 -122.404878460446 (37.793080546408, -122.404878460446) 3 1 10 28857 4
22448 143498 1 54 857 Kearny St 3 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6011217.724 2117930.0991 37.7960642762572 -122.405198277055 (37.7960642762572, -122.405198277055) 3 1 10 28857 4
28001 142492 1 54 651 COLUMBUS AVE 5 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   6009649.7576 2119605.0318 37.8005754466702 -122.410742118634 (37.8005754466702, -122.410742118634) 3 1 10 308 4
39600 143497 1 54 867 Kearny St 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6011217.2579 2117938.9551 37.7960885666374 -122.40520051379 (37.7960885666374, -122.40520051379) 3 1 10 28857 4
44783 142491 1 54 651 COLUMBUS AVE 4 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   6009641.4463 2119604.1083 37.8005724449635 -122.410770813978 (37.8005724449635, -122.410770813978) 3 1 10 308 4
78902 143556 1 54 848 KEARNY ST 1 Sidewalk: Curb side : Pot Tree 2     5 Width 0ft   6011275.0549 2117918.4465 37.7960354859857 -122.404999078913 (37.7960354859857, -122.404999078913) 3 1 10 28857 4
90895 142938 1 54 1160 BROADWAY 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 0ft   6010744.0272 2118552.2837 37.7977461503426 -122.406881242638 (37.7977461503426, -122.406881242638) 3 1 10 308 4
98101 142489 1 54 651 COLUMBUS AVE 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 0ft   6009636.3672 2119608.7257 37.8005848384211 -122.410788716085 (37.8005848384211, -122.410788716085) 3 1 10 308 4
109050 142510 4 54 401 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 0ft   6010260.5653 2119044.3559 37.7990701962332 -122.408588891831 (37.7990701962332, -122.408588891831) 3 1 10 308 4
114918 142918 1 54 509 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree 2     18 Width 0ft   6010018.2099 2119266.553 37.7996667187629 -122.409443216757 (37.7996667187629, -122.409443216757) 3 1 10 308 4
118494 142490 1 54 651 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   6009644.6785 2119609.6491 37.8005878398576 -122.41076002073 (37.8005878398576, -122.41076002073) 3 1 10 308 4
121443 142630 1 54 707 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 0ft   6009347.3214 2119879.3022 37.8013115634868 -122.411808066362 (37.8013115634868, -122.411808066362) 3 1 10 308 4
128630 142499 1 54 521 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 0ft   6009964.3012 2119317.683 37.7998040885057 -122.40963337214 (37.7998040885057, -122.40963337214) 3 1 10 308 4
131870 142488 1 54 651 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   6009640.0611 2119612.4195 37.8005951877983 -122.410776194648 (37.8005951877983, -122.410776194648) 3 1 10 308 4
134953 142512 1 54 427 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree 1     13 Width 0ft   6010331.5039 2118981.6421 37.7989019721603 -122.408338993416 (37.7989019721603, -122.408338993416) 3 1 10 308 4
142221 142513 1 54 419 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree 1     18 Width 0ft   6010363.8889 2118953.3694 37.7988261556788 -122.408224935007 (37.7988261556788, -122.408224935007) 3 1 10 308 4
146897 142493 1 54 651 COLUMBUS AVE 6 Sidewalk: Curb side : Cutout Tree 2     16 Width 0ft   6009645.6019 2119599.491 37.8005599999984 -122.410756107582 (37.8005599999984, -122.410756107582) 3 1 10 308 4
153779 142620 1 54 1 Scotland St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   6009140.6951 2120065.1504 37.8018102626301 -122.412536232083 (37.8018102626301, -122.412536232083) 3 1 10 308 4
170680 143496 1 54 877 Kearny St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 0ft   6011215.3935 2117948.7433 37.7961153384403 -122.405207654625 (37.7961153384403, -122.405207654625) 3 1 10 28857 4
180082 143557 1 54 848 KEARNY ST 2 Sidewalk: Curb side : Pot Tree 2     5 Width 0ft   6011271.7921 2117938.489 37.7960903354635 -122.405011780806 (37.7960903354635, -122.405011780806) 3 1 10 28857 4
184752 142629 1 54 725 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 0ft   6009330.2372 2119895.0012 37.8013537106151 -122.41186829545 (37.8013537106151, -122.41186829545) 3 1 10 308 4