trees

Custom SQL query returning 37 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
16782 237960 1 371 571 Duncan St 1 Sidewalk: Property side : Yard Tree 2     6 Width 10ft   6002836.92742 2099745.95433 37.7456629887692 -122.432897720155 (37.7456629887692, -122.432897720155) 2 7 5 63 22
22992 178860 1 371 89 Belle Ave 4 Sidewalk: Property side : Yard Tree 2     15 Width 2ft   5991691.41062 2086487.07285 37.7086189324765 -122.470471431226 (37.7086189324765, -122.470471431226) 9 8 4 64 24
33093 46368 1 371 1839 Laguna St 1 Sidewalk: Curb side : Cutout Tree 2   04/08/2010 12:00:00 AM 4   Permit Number 53354 6004357.9818 2115208.0648 37.7882043731201 -122.428740197102 (37.7882043731201, -122.428740197102) 13 9 11 29490 27
35476 55322 1 371 1174 Goettingen St 1 Sidewalk: Curb side : Cutout Tree 2   10/26/1972 12:00:00 AM 9   Permit Number 11252 6011343.89577 2089330.65772 37.7175436012422 -122.402749381186 (37.7175436012422, -122.402749381186) 10 7 8 309 39
38721 24263 1 371 300X Winding Way 1 Median : Cutout Tree 1     30 8   6001575.13411 2086503.14158 37.7092295937538 -122.436313223902 (37.7092295937538, -122.436313223902) 9 7 6 28861 5
46081 214363 1 371 1549 15th Ave 4 Sidewalk: Curb side : Yard Tree 2     19     5991540.65145 2104932.9857 37.7592580392483 -122.472336237554 (37.7592580392483, -122.472336237554) 1 8 4 56 12
48244 237961 1 371 177 Grand View Ave 1 Sidewalk: Property side : Yard Tree 2     12     6000805.94873 2103333.15476 37.7553971750633 -122.440177715934 (37.7553971750633, -122.440177715934) 2 4 5 28862 38
48253 249619 1 371 2398 Golden Gate Ave 4 Sidewalk: Property side : Yard Tree 2     8 Width 7ft   5998061.53273 2111381.56318 37.7773394333005 -122.450248814341 (37.7773394333005, -122.450248814341) 15 6 2 54 16
56202 178859 1 371 300x Winding Way 2 Median : Cutout Tree 1     36 Width 0ft   6001566.6929 2086499.15435 37.7092181660671 -122.436342112826 (37.7092181660671, -122.436342112826) 9 7 6 28861 5
59580 214368 1 371 711 Joost Ave 3 Sidewalk: Property side : Yard Tree 2     44     5997395.8129 2094969.98374 37.7322392132673 -122.451367789509 (37.7322392132673, -122.451367789509) 9 7 4 59 40
59724 123750 1 371 2 Cabrillo St 1 Sidewalk: Property side : Yard Tree 2     9 Width 3ft   5995617 2110854 37.775750686051 -122.458666990683 (37.775750686051, -122.458666990683) 11 6 2 54 11
79390 135877 1 371 1998 Jefferson St 5 Sidewalk: Property side : Yard Tree 2     1 Width 1ft   5999700.17509 2121253.84302 37.804539757774 -122.445290220574 (37.804539757774, -122.445290220574) 13 9 1 57 17
82308 214370 1 371 280 Vernon St 2 Sidewalk: Property side : Yard Tree 2     7 Width 4ft   5992489.60576 2089794.03711 37.7177451815858 -122.4679531649 (37.7177451815858, -122.4679531649) 9 8 6 64 24
82460 178862 1 371 475 Country Club Dr 2 Sidewalk: Property side : Yard Tree 2     3 Width 4ft   5984727.35234 2094646.97301 37.7306187644333 -122.49514106342 (37.7306187644333, -122.49514106342) 1 8 4 64 35
83318 214362 1 371 1549 15th Ave 5 Sidewalk: Curb side : Yard Tree 2     23     5991544.57337 2104931.26078 37.7592535300574 -122.472322548047 (37.7592535300574, -122.472322548047) 1 8 4 56 12
85303 214364 1 371 1549 15th Ave 3 Sidewalk: Curb side : Yard Tree 2     20     5991543.36526 2104936.54185 37.7592679605603 -122.472327111216 (37.7592679605603, -122.472327111216) 1 8 4 56 12
100483 237959 1 371 4301 26th St 3 Sidewalk: Property side : Yard Tree 2     8 Width 8ft   6001852.48827 2100568.36234 37.747865241384 -122.436360606479 (37.747865241384, -122.436360606479) 2 4 5 63 22
104554 2756 1 371 130 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree 2     3 3X3   5995174.76257 2110814.06482 37.7756156072533 -122.460193896477 (37.7756156072533, -122.460193896477) 11 6 2 54 11
106820 214366 1 371 1549 15th Ave 1 Sidewalk: Curb side : Yard Tree 2     18     5991544.33826 2104943.58363 37.7592873517403 -122.472324259478 (37.7592873517403, -122.472324259478) 1 8 4 56 12
107033 104876 2 371 2478 43rd Ave   Sidewalk: Property side : Cutout Tree 2   12/28/2016 12:00:00 AM 3   Permit Number 778928 5983068.6 2098273.8 37.7404797966413 -122.501143676277 (37.7404797966413, -122.501143676277) 1 8 3 29491 35
108651 214371 1 371 280 Vernon St 3 Sidewalk: Property side : Yard Tree 2     8 Width 4ft   5992489.13857 2089808.10753 37.7177837885668 -122.46795580262 (37.7177837885668, -122.46795580262) 9 8 6 64 24
110789 237958 1 371 4301 26th St 1 Sidewalk: Property side : Yard Tree 2     10 Width 8ft   6001845.26134 2100568.224 37.747864450895 -122.436385586923 (37.747864450895, -122.436385586923) 2 4 5 63 22
112835 237957 1 371 612 28th St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 2ft   6001964.12241 2099450.71378 37.7448027845374 -122.435894623662 (37.7448027845374, -122.435894623662) 2 7 5 63 22
112975 107342 6 371 110 JULIAN AVE 1 Back Yard : Yard Tree 2     100     6006340.8 2107214.1 37.7663669011591 -122.421312071366 (37.7663669011591, -122.421312071366) 8 4 7 28853 19
113143 237962 1 371 177 Grand View Ave 3 Sidewalk: Property side : Yard Tree 2     39     6000813.89685 2103347.44097 37.7554368540311 -122.440151253392 (37.7554368540311, -122.440151253392) 2 4 5 28862 38
114067 214367 1 371 711 Joost Ave 2 Sidewalk: Property side : Yard Tree 2     36     5997381.65215 2094970.27905 37.7322392132504 -122.451416767471 (37.7322392132504, -122.451416767471) 9 7 4 59 40
121254 123442 1 371 770 03rd Ave 1 Sidewalk: Curb side : Cutout Tree 2     41 Width 4ft   5995072.84677 2110398.87908 37.7744697543778 -122.46051635392 (37.7744697543778, -122.46051635392) 11 6 2 54 11
128727 237956 1 371 225 Kingston St 1 : Tree 2     26 Width 4ft   6006307.0177 2098035.04162 37.7411614169794 -122.420777203522 (37.7411614169794, -122.420777203522) 2 7 7 28859 2
132276 135876 1 371 1998 Jefferson St 3 Sidewalk: Property side : Yard Tree 2     1 Width 3ft   5999716.36995 2121255.20068 37.8045444099615 -122.445234274639 (37.8045444099615, -122.445234274639) 13 9 1 57 17
133606 100571 7 371 20 Landers St 1 Sidewalk: Curb side : Cutout Tree 2   12/31/2014 12:00:00 AM   3x3 Permit Number 770316 6004449 2107658 37.7674789047962 -122.427887091326 (37.7674789047962, -122.427887091326) 8 4 5 28862 3
136426 178861 1 371 475 Country Club Dr 1 Sidewalk: Property side : Yard Tree 2     6 Width 4ft   5984726.53104 2094657.37794 37.7306472855285 -122.495144669717 (37.7306472855285, -122.495144669717) 1 8 4 64 35
143998 214360 1 371 1549 15th Ave 7 Sidewalk: Curb side : Yard Tree 2     6     5991543.46931 2104921.03616 37.7592253920544 -122.472325621024 (37.7592253920544, -122.472325621024) 1 8 4 56 12
153649 214369 1 371 280 Vernon St 1 Sidewalk: Property side : Yard Tree 2     5 Width 4ft   5992489.92941 2089773.12953 37.7176877931326 -122.467950526298 (37.7176877931326, -122.467950526298) 9 8 6 64 24
162891 249739 1 371 2500 Broderick St 23 : Tree 2     12 Width 3ft   6000181.57325 2117191.47862 37.793413053123 -122.443332338011 (37.793413053123, -122.443332338011) 13 9 1 57 27
168844 214365 1 371 1549 15th Ave 2 Sidewalk: Curb side : Yard Tree 2     13     5991540.76565 2104938.40333 37.7592729212382 -122.472336237538 (37.7592729212382, -122.472336237538) 1 8 4 56 12
171189 214361 1 371 1549 15th Ave 6 Sidewalk: Curb side : Yard Tree 2     5     5991542.49822 2104926.70561 37.7592409026637 -122.472329392783 (37.7592409026637, -122.472329392783) 1 8 4 56 12
188834 135875 1 371 1998 Jefferson St 2 Sidewalk: Property side : Yard Tree 2     1 Width 3ft   5999729.52384 2121257.63856 37.8045518545403 -122.445188929927 (37.8045518545403, -122.445188929927) 13 9 1 57 17