trees

Custom SQL query returning 22 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
109994 15661 1 91 3900 Mission St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6005100.74203 2095958.24727 37.7353909444416 -122.424800364285 (37.7353909444416, -122.424800364285) 2 7 5 28859 2
8068 32395 1 91 222 Richland Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/03/1996 12:00:00 AM 6 8x6 Permit Number 36936 6005810.68419 2096104.55108 37.735832735077 -122.42235621788 (37.735832735077, -122.42235621788) 2 7 7 28859 2
98484 239610 1 91 342 Prospect Ave 1 Sidewalk: Property side : Yard Tree 2     23 Width 3ft   6006341.94877 2097874.88988 37.7407236449682 -122.420645058033 (37.7407236449682, -122.420645058033) 2 7 7 28859 2
63489 113030 4 91 200x ESMERALDA AVE 2 Sidewalk: Curb side : Cutout Tree 2     10 9x9   6007093 2098828 37.7433829729046 -122.41811575542 (37.7433829729046, -122.41811575542) 2 7 7 28859 2
112033 239613 1 91 200 Bennington St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6007098.78535 2096984.45251 37.7383213273752 -122.417965090943 (37.7383213273752, -122.417965090943) 2 7 7 28859 2
146935 239586 1 91 103 Winfield St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 2ft   6007116.95324 2098786.33455 37.743269917082 -122.418029977927 (37.743269917082, -122.418029977927) 2 7 7 28859 2
81834 239609 1 91 98 Winfield St 1 Sidewalk: Curb side : Pot Tree 2     25 Width 3ft   6007121.02113 2098861.91271 37.7434776667546 -122.41802126889 (37.7434776667546, -122.41802126889) 2 7 7 28859 2
59175 46762 7 91 220 Esmeralda Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 04/24/2002 12:00:00 AM 14 6x5 Permit Number 44860 6007156.68652731 2098808.76351871 37.7433337382313 -122.417894179823 (37.7433337382313, -122.417894179823) 2 7 7 28859 2
27405 33584 7 91 149 Bonview St 1 Sidewalk: Curb side : Cutout Tree 2   11/26/1996 12:00:00 AM     Permit Number 37692 6007187.40748461 2098136.50319387 37.7414895902405 -122.417740314034 (37.7414895902405, -122.417740314034) 2 7 7 28859 2
23648 239611 1 91 230 Esmeralda Ave 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 5ft   6007188.60592 2098802.03139 37.7433170496408 -122.417783333431 (37.7433170496408, -122.417783333431) 2 7 7 28859 2
98903 239612 1 91 220 Esmeralda Ave 2 Sidewalk: Curb side : Cutout Tree 2     16 Width 4ft   6007237.85888 2098768.99356 37.7432291067493 -122.417610687906 (37.7432291067493, -122.417610687906) 2 7 7 28859 2
134061 239607 1 91 189 Bocana St 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 3ft   6007238.5342 2097885.55109 37.7408034085529 -122.417545753258 (37.7408034085529, -122.417545753258) 2 7 7 28859 2
175778 33535 7 91 189 Bocana St 1 Sidewalk: Curb side : Cutout Tree 2   11/25/1996 12:00:00 AM 14 4x4 Permit Number 37645 6007254.14606577 2097898.03626592 37.7408385685157 -122.417492657782 (37.7408385685157, -122.417492657782) 2 7 7 28859 2
124417 239608 1 91 149 Bonview St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6007254.62958 2098290.95874 37.7419174734269 -122.417518826646 (37.7419174734269, -122.417518826646) 2 7 7 28859 2
137756 239587 1 91 105 Elsie St 1 Sidewalk: Curb side : Pot Tree 2     10 Width 5ft   6007266.87289 2098693.35025 37.7430230396951 -122.417505004957 (37.7430230396951, -122.417505004957) 2 7 7 28859 2
156347 63010 7 91 9 Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/23/1986 12:00:00 AM     Permit Number 23424 6007395.1381387 2098224.27155142 37.7417422703287 -122.417028268249 (37.7417422703287, -122.417028268249) 2 7 7 28859 2
129788 239614 1 91 249 Precita Ave 2 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft   6007957.74109 2100292.59771 37.7474530659031 -122.41522934697 (37.7474530659031, -122.41522934697) 2 7 7 28859 2
188533 239615 1 91 249 Precita Ave 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   6007977.56297 2100289.57669 37.7474458848375 -122.4151605902 (37.7474458848375, -122.4151605902) 2 7 7 28859 2
151790 63720 7 91 249 Precita Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/19/1987 12:00:00 AM 12 3x3 Permit Number 24385 6008064.48787212 2100278.68429699 37.7474208614245 -122.41485923795 (37.7474208614245, -122.41485923795) 2 7 7 28859 2
167131 247586 1 91 800 Tompkins Ave 7 Front Yard : Yard Tree 2     21     6008976.64658 2096466.10816 37.7370035750634 -122.411435734088 (37.7370035750634, -122.411435734088) 10 7 7 28859 2
11161 247593 1 91 800 Tompkins Ave 14 Front Yard : Yard Tree 2     11     6009015.3685 2096434.58029 37.736919178173 -122.411299627995 (37.736919178173, -122.411299627995) 10 7 7 28859 2
172414 256223 8 91 116X Brewster St 1 Sidewalk: Property side : Yard Tree 5       6x6   6010334 2099321 37.7449185312124 -122.406943891675 (37.7449185312124, -122.406943891675) 2 7 7 28859 2