trees

Custom SQL query returning 71 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
2158 95238 4 36 1220 Noe St 5 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
3324 100985 1 7 2190 Powell St 6 Sidewalk: Curb side : Cutout Tree 4 DPW 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
11226 33101 1 300 450X Chestnut St 1 Sidewalk: Curb side : Cutout Tree 4 DPW 11/05/1996 12:00:00 AM 14   Permit Number 37341 6009682.3141 2120901.0273 37.804135754367 -122.410721035819 (37.804135754367, -122.410721035819) 3 1 10 308 23
14472 100972 1 48 450X Chestnut St 4 Sidewalk: Curb side : Cutout Tree 4 DPW 03/24/2016 07:43:00 AM 3   Permit Number 37341 6009614 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823) 3 1 10 308 23
17603 75990 1 271 350 Broadway 1 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6011912.57037 2118781.03793 37.7984395708796 -122.402853834756 (37.7984395708796, -122.402853834756) 3 1 10 308 23
18687 104158 1 45 525X Church St 6 Sidewalk: Curb side : Cutout Landscaping 4 DPW     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
27818 98647 1 57 2110 Greenwich St 4 Sidewalk: Curb side : Cutout Tree 4 DPW   12 5x5   6002751.94545 2119240.19821 37.7991845449763 -122.434585229619 (37.7991845449763, -122.434585229619) 13 9 1 57 17
31577 104151 1 45 525X Church St 1 Sidewalk: Property side : Cutout Landscaping 4 DPW     2x58   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
36405 98645 1 57 2110 Greenwich St 2 Sidewalk: Curb side : Cutout Tree 4 DPW   9 5x5   6002788.88101 2119245.38589 37.7992008856766 -122.434457791187 (37.7992008856766, -122.434457791187) 13 9 1 57 17
38172 34688 1 57 3101X Webster St 2 Sidewalk: Curb side : Cutout Tree 4 DPW 07/28/1997 12:00:00 AM 7 3x3 Permit Number 38352 6002815.38185 2119347.35443 37.7994823689702 -122.434373383533 (37.7994823689702, -122.434373383533) 13 9 1 57 17
39667 95239 4 36 1220 Noe St 6 Sidewalk: Curb side : Cutout Tree 4 DPW   12     6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
43511 98646 1 57 2110 Greenwich St 3 Sidewalk: Curb side : Cutout Tree 4 DPW   8 5x5   6002771.23879 2119243.65965 37.7991951444108 -122.434518715761 (37.7991951444108, -122.434518715761) 13 9 1 57 17
45053 98657 1 57 2110 Greenwich St 11 Sidewalk: Curb side : Cutout Tree 4 DPW   11 5x5   6002607.56666 2119218.59599 37.7991170337862 -122.435083283187 (37.7991170337862, -122.435083283187) 13 9 1 57 17
48885 98651 1 38 2110 Greenwich St 8 Sidewalk: Curb side : Cutout Tree 4 DPW   23 5x5   6002674.17203 2119228.66956 37.7991484749737 -122.434853527066 (37.7991484749737, -122.434853527066) 13 9 1 57 17
49150 100970 1 36 450X Chestnut St 2 Sidewalk: Curb side : Cutout Tree 4 DPW   9   Permit Number 37341 6009657.9659 2120896.9693 37.8041232469329 -122.410805008122 (37.8041232469329, -122.410805008122) 3 1 10 308 23
49823 98650 1 57 2110 Greenwich St 7 Sidewalk: Curb side : Cutout Tree 4 DPW   11 5x5   6002693.158 2119231.97091 37.7991586175436 -122.434788065428 (37.7991586175436, -122.434788065428) 13 9 1 57 17
50209 97899 4 8 375X Precita Ave 5 Sidewalk: Curb side : Cutout Tree 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
51293 100971 1 58 450X Chestnut St 3 Sidewalk: Curb side : Cutout Tree 4 DPW   4   Permit Number 37341 6009642.5454 2120895.3461 37.8041179253888 -122.410858257388 (37.8041179253888, -122.410858257388) 3 1 10 308 23
56368 34692 1 57 3101X Webster St 6 Sidewalk: Curb side : Cutout Tree 4 DPW 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002825.2019 2119271.55666 37.7992748054477 -122.434333980647 (37.7992748054477, -122.434333980647) 13 9 1 57 17
58468 100975 1 36 450X Chestnut St 7 Sidewalk: Curb side : Cutout Tree 4 DPW   11   Permit Number 37341 6009580.8633 2120886.4184 37.8040899533369 -122.411071082632 (37.8040899533369, -122.411071082632) 3 1 10 308 23
58686 98656 1 57 2110 Greenwich St 10 Sidewalk: Curb side : Cutout Tree 4 DPW   8 5x5   6002629.88193 2119221.45898 37.7991261619004 -122.435006269744 (37.7991261619004, -122.435006269744) 13 9 1 57 17
65532 100981 1 468 2190 Powell St 2 Sidewalk: Curb side : Cutout Tree 4 DPW 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
65536 100982 1 468 2190 Powell St 3 Sidewalk: Curb side : Cutout Tree 4 DPW 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
66219 100977 1 58 450X Chestnut St 9 Sidewalk: Curb side : Cutout Tree 4 DPW   3   Permit Number 37341 6009542.7178 2120879.1139 37.8040677578058 -122.411202572075 (37.8040677578058, -122.411202572075) 3 1 10 308 23
66578 100978 1 58 450X Chestnut St 10 Sidewalk: Curb side : Cutout Tree 4 DPW   5   Permit Number 37341 6009524.0508 2120877.4907 37.8040622540071 -122.411267056058 (37.8040622540071, -122.411267056058) 3 1 10 308 23
72589 47255 1 16 1035 Gilman Ave 4 Sidewalk: Curb side : Cutout Tree 4 DPW 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.7185559218928 -122.388859444456 (37.7185559218928, -122.388859444456) 10 3 8 58 1
77923 256355 1 53 1000 Bay St 1 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
79291 104154 1 45 525X Church St 2 Sidewalk: Curb side : Cutout Landscaping 4 DPW     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
81015 97898 4 8 375X Precita Ave 4 Sidewalk: Curb side : Cutout Tree 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
84800 97902 4 37 375X Precita Ave 8 Sidewalk: Curb side : Cutout Tree 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
85492 95237 4 36 1220 Noe St 4 Sidewalk: Curb side : Cutout Tree 4 DPW   9 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
87067 98675 7 17 199X Park St 1 Sidewalk: Curb side : Cutout Tree 4 DPW         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
87595 97901 4 37 375X Precita Ave 7 Sidewalk: Curb side : Cutout Tree 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
90475 234072 1 36 1400 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree 4 DPW   4 Width 3ft   6011140.67766 2101759.73109 37.7516598624171 -122.404326151746 (37.7516598624171, -122.404326151746) 10 4 8 28859 19
90901 100974 1 36 450X Chestnut St 6 Sidewalk: Curb side : Cutout Tree 4 DPW   15   Permit Number 37341 6009596.2838 2120888.8532 37.8040975034287 -122.411017890761 (37.8040975034287, -122.411017890761) 3 1 10 308 23
92277 100973 1 36 450X Chestnut St 5 Sidewalk: Curb side : Cutout Tree 4 DPW   0   Permit Number 37341 6009614 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823) 3 1 10 308 23
93651 98648 1 57 2110 Greenwich St 5 Sidewalk: Curb side : Cutout Tree 4 DPW   9 5x5   6002730.0885 2119237.75472 37.7991765949935 -122.434660687245 (37.7991765949935, -122.434660687245) 13 9 1 57 17
94668 104156 1 45 525X Church St 4 Sidewalk: Curb side : Cutout Landscaping 4 DPW     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
101825 97903 4 16 375X Precita Ave 9 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
106695 100983 1 7 2190 Powell St 4 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
108543 67860 1 57 2110 Greenwich St 1 Sidewalk: Curb side : Cutout Tree 4 DPW 01/20/1993 12:00:00 AM 5 5x5 Permit Number 31536 6002806.21719 2119247.92289 37.7992088356751 -122.434397983605 (37.7992088356751, -122.434397983605) 13 9 1 57 17
109710 97896 4 8 375X Precita Ave 2 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
111419 104155 1 45 525X Church St 3 Sidewalk: Curb side : Cutout Landscaping 4 DPW     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
115599 96503 1 32 2360X Harrison St 4 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
121961 100979 1 58 450X Chestnut St 11 Sidewalk: Curb side : Cutout Tree 4 DPW   6   Permit Number 37341 6009507.0071 2120874.2443 37.8040523843138 -122.411325807727 (37.8040523843138, -122.411325807727) 3 1 10 308 23
123087 34690 1 57 3101X Webster St 4 Sidewalk: Curb side : Cutout Tree 4 DPW 07/28/1997 12:00:00 AM 8 3x3 Permit Number 38352 6002819.05677 2119313.26082 37.7993889653989 -122.434358228162 (37.7993889653989, -122.434358228162) 13 9 1 57 17
123904 98659 7 53 2110 Greenwich St 13 Sidewalk: Curb side : Cutout Tree 4 DPW   20 7x7   6002683.8 2119245.6 37.7991955081761 -122.434821422435 (37.7991955081761, -122.434821422435) 13 9 1 57 17
126964 97897 4 8 375X Precita Ave 3 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
129312 77648 1 57 1300X Silliman St 9 Sidewalk: Curb side : Cutout Tree 4 DPW 01/01/2011 12:00:00 AM 3 3x3   6006817.14742 2093142.98247 37.7277576387802 -122.418666516263 (37.7277576387802, -122.418666516263) 9 3 7 309 5
132915 100984 1 7 2190 Powell St 5 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
133386 98658 1 17 2110 Greenwich St 12 Sidewalk: Curb side : Cutout Tree 4 DPW 06/20/2014 12:00:00 AM   6x6 Permit Number 772915 6002683.8 2119245.6 37.7991955081761 -122.434821422435 (37.7991955081761, -122.434821422435) 13 9 1 57 17
135797 97066 1 11 1599X Newcomb Ave 7 Sidewalk: Curb side : Cutout Tree 4 DPW   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.389755060411 (37.7351486000155, -122.389755060411) 10 3 8 58 1
137518 98655 1 57 2110 Greenwich St 9 Sidewalk: Curb side : Cutout Tree 4 DPW   6 5x5   6002650.75991 2119226.56813 37.7991413757273 -122.434934390513 (37.7991413757273, -122.434934390513) 13 9 1 57 17
142139 34693 1 57 3101X Webster St 1 Sidewalk: Curb side : Cutout Tree 4 DPW 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002813.73545 2119366.57801 37.799535058456 -122.434380455813 (37.799535058456, -122.434380455813) 13 9 1 57 17
152683 98649 1 57 2110 Greenwich St 6 Sidewalk: Curb side : Cutout Tree 4 DPW   16 5x5   6002707.76445 2119233.0203 37.7991623281478 -122.434737597267 (37.7991623281478, -122.434737597267) 13 9 1 57 17
153628 104153 1 45 525X Church St 1 Sidewalk: Curb side : Cutout Landscaping 4 DPW     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
154088 95241 4 36 1220 Noe St 8 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
155740 95235 4 36 1220 Noe St 1 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
156692 104157 1 45 525X Church St 5 Sidewalk: Curb side : Cutout Landscaping 4 DPW     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
162318 34689 1 57 3101X Webster St 3 Sidewalk: Curb side : Cutout Tree 4 DPW 07/28/1997 12:00:00 AM 5 3x3 Permit Number 38352 6002816.77257 2119329.88091 37.7994344701793 -122.434367321195 (37.7994344701793, -122.434367321195) 13 9 1 57 17
164652 104152 1 45 525X Church St 2 Sidewalk: Property side : Cutout Landscaping 4 DPW     2x68   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
168139 34691 1 57 3101X Webster St 5 Sidewalk: Curb side : Cutout Tree 4 DPW 07/28/1997 12:00:00 AM 10 3x3 Permit Number 38352 6002820.98316 2119293.45008 37.7993346796145 -122.434350145047 (37.7993346796145, -122.434350145047) 13 9 1 57 17
169010 102195 4 57 3999X Folsom St 9 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
170711 95240 4 36 1220 Noe St 7 Sidewalk: Curb side : Cutout Tree 4 DPW   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
175564 95236 4 36 1220 Noe St 2 Sidewalk: Curb side : Cutout Tree 4 DPW   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
182487 256357 1 53 1000 Bay St 3 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
182607 100976 1 58 450X Chestnut St 8 Sidewalk: Curb side : Cutout Tree 4 DPW   5   Permit Number 37341 6009558.1383 2120880.7372 37.8040730797801 -122.411149322876 (37.8040730797801, -122.411149322876) 3 1 10 308 23
188027 100980 1 468 2190 Powell St 1 Sidewalk: Curb side : Cutout Tree 4 DPW 05/03/2013 12:00:00 AM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
189482 97895 4 8 375X Precita Ave 1 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
191936 100987 1 7 2190 Powell St 8 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
192030 256356 1 53 1000 Bay St 2 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32