trees
508 rows where qSpecies_id = 25 sorted by rowid descending
This data as json, CSV (advanced)
rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
149342 | 35091 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 920 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 15 | 3x3 | Permit Number 42238 | 5992055.93239281 | 2105259.4330846 | 37.7601841866451 | -122.470577939927 | (37.7601841866451, -122.470577939927) | 1 | 8 | 4 | 56 | 12 |
149327 | 128871 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6001562.05606 | 2116003.40074 | 37.7902295241198 | -122.438470613846 | (37.7902295241198, -122.438470613846) | 13 | 6 | 1 | 29490 | 27 | |||
148769 | 225977 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 310 Liberty St | 61 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 6003712.20285 | 2103924.72704 | 37.7571865237503 | -122.430169210355 | (37.7571865237503, -122.430169210355) | 2 | 4 | 5 | 28862 | 3 | |||
147726 | 114483 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 784 CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x2 | 6009096 | 2110140 | 37.7745556909018 | -122.411989099957 | (37.7745556909018, -122.411989099957) | 8 | 2 | 9 | 28853 | 34 | |||
145759 | 59939 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1778 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 1 | Permit Number 19412 | 5999341.88585809 | 2110158.12282899 | 37.7740533674999 | -122.445731667127 | (37.7740533674999, -122.445731667127) | 15 | 5 | 11 | 29492 | 16 | |
145603 | 176510 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Brookdale Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006143.81597 | 2087479.56194 | 37.7121691699409 | -122.420592382928 | (37.7121691699409, -122.420592382928) | 9 | 7 | 8 | 309 | 39 | |||
144609 | 176499 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 162 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6005745.58119 | 2087451.77686 | 37.7120704261874 | -122.421966828522 | (37.7120704261874, -122.421966828522) | 9 | 7 | 8 | 309 | 18 | |||
143918 | 32088 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3972 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 12 | Permit Number 35461 | 6003219.31552 | 2104788.31954 | 37.7595298134806 | -122.431935468059 | (37.7595298134806, -122.431935468059) | 2 | 4 | 5 | 28862 | 3 | |
143314 | 176508 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 150 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 50 | Width 6ft | 6005731.29388 | 2087351.07842 | 37.7117931238283 | -122.422009060692 | (37.7117931238283, -122.422009060692) | 9 | 7 | 8 | 309 | 39 | |||
143306 | 225933 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1256 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008673.75291 | 2101213.64343 | 37.7500222662216 | -122.41281852357 | (37.7500222662216, -122.41281852357) | 2 | 4 | 7 | 28859 | 19 | |||
143129 | 225952 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 800 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001178.25767 | 2102625.59939 | 37.7534755882504 | -122.438839459988 | (37.7534755882504, -122.438839459988) | 2 | 4 | 5 | 28862 | 22 | |||
142404 | 29761 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 500 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6008886.8317032 | 2121139.4877644 | 37.8047458740943 | -122.4134907456 | (37.8047458740943, -122.4134907456) | 3 | 1 | 10 | 308 | 23 | |||
142175 | 225966 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 183 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007593.94414 | 2100298.17812 | 37.7474479361811 | -122.416487731444 | (37.7474479361811, -122.416487731444) | 2 | 7 | 7 | 28859 | 2 | |||
142128 | 109686 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 190 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772797 | 6000260.82873 | 2091434.8524 | 37.7226961949641 | -122.441209260793 | (37.7226961949641, -122.441209260793) | 9 | 7 | 6 | 28861 | 25 |
142003 | 10068 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 549 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005603.73706 | 2105778.33301 | 37.762383043055 | -122.423759340124 | (37.762383043055, -122.423759340124) | 8 | 4 | 5 | 28859 | 19 | |||
141749 | 41187 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 380 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 8 | Permit Number 46607 | 6013185.95339 | 2105307.79412 | 37.7615161505792 | -122.39750208615 | (37.7615161505792, -122.39750208615) | 10 | 3 | 8 | 28856 | 29 | |
141655 | 52023 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 20 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2005 12:00:00 AM | Permit Number 48238 | 6006866.55802505 | 2096801.82623419 | 37.7378068034281 | -122.418755072853 | (37.7378068034281, -122.418755072853) | 2 | 7 | 7 | 28859 | 2 | ||
141317 | 60696 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2839 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/1983 12:00:00 AM | Permit Number 20342 | 6009224.45070504 | 2103317.03242809 | 37.7558285965659 | -122.411062726793 | (37.7558285965659, -122.411062726793) | 2 | 4 | 7 | 28859 | 19 | ||
140391 | 69220 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1244 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 3x3 | Permit Number 33272 | 6008663.44143065 | 2101293.23911329 | 37.7502402393754 | -122.412859808121 | (37.7502402393754, -122.412859808121) | 2 | 4 | 7 | 28859 | 19 | |
139962 | 67087 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30488 | 6009949 | 2099997 | 37.74675312806 | -122.40832282803 | (37.74675312806, -122.40832282803) | 2 | 7 | 7 | 28859 | 2 | ||
139521 | 10000 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 136 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 2X2 | 6005403.54778 | 2108183.22689 | 37.7689750062251 | -122.424622801709 | (37.7689750062251, -122.424622801709) | 8 | 4 | 5 | 28853 | 19 | |||
139202 | 225909 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 99 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6005410.68329 | 2103188.80406 | 37.7552619044394 | -122.424242863321 | (37.7552619044394, -122.424242863321) | 2 | 4 | 5 | 28859 | 19 | |||
139062 | 142338 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 510 Central Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5999738.5075 | 2110257.1017 | 37.7743477755014 | -122.444366803816 | (37.7743477755014, -122.444366803816) | 15 | 5 | 11 | 29492 | 16 | |||
138266 | 176511 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 127 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6006104.31545 | 2087436.52069 | 37.7120487615086 | -122.420725854912 | (37.7120487615086, -122.420725854912) | 9 | 7 | 8 | 309 | 39 | |||
138084 | 219015 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 178 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995362.975 | 2091073.58019 | 37.7214240148917 | -122.458113831693 | (37.7214240148917, -122.458113831693) | 9 | 8 | 6 | 28861 | 24 | |||
138074 | 98258 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2800X 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.415898914261 | (37.7655523739417, -122.415898914261) | 8 | 4 | 7 | 28853 | 19 | |||
137812 | 192423 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6012208.34529 | 2107668.53767 | 37.7679437428368 | -122.401049131921 | (37.7679437428368, -122.401049131921) | 14 | 3 | 8 | 28856 | 20 | |||
137668 | 98257 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2800X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.415898914261 | (37.7655523739417, -122.415898914261) | 8 | 4 | 7 | 28853 | 19 | |||
137615 | 31889 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 167 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 15 | Permit Number 35321 | 6007897.98767 | 2109828.50999 | 37.7736331256972 | -122.416111205987 | (37.7736331256972, -122.416111205987) | 8 | 2 | 9 | 28853 | 34 | ||
137342 | 32627 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 75 Boardman Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 15 | Permit Number 37080 | 6011835.14299 | 2109991.00563 | 37.774299885758 | -122.402503334756 | (37.774299885758, -122.402503334756) | 14 | 2 | 9 | 28853 | 34 | |
136527 | 108571 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 223 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772573 | 6009406.56 | 2094751.33642 | 37.7323192844032 | -122.409828317318 | (37.7323192844032, -122.409828317318) | 10 | 3 | 7 | 309 | 28 |
136233 | 244047 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 400 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997955.5586 | 2109119.1735 | 37.7711214297529 | -122.450452276113 | (37.7711214297529, -122.450452276113) | 15 | 5 | 11 | 29492 | 9 | |||
136146 | 98260 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2800X 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.415898914261 | (37.7655523739417, -122.415898914261) | 8 | 4 | 7 | 28853 | 19 | |||
136070 | 225945 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 25 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006157.91256 | 2103444.1528 | 37.7560051968042 | -122.421676853797 | (37.7560051968042, -122.421676853797) | 2 | 4 | 5 | 28859 | 19 | |||
135416 | 219002 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1333 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5992990.51198 | 2106402.84909 | 37.7633777040321 | -122.467428846685 | (37.7633777040321, -122.467428846685) | 1 | 8 | 11 | 56 | 12 | |||
134411 | 66548 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3444 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 29730 | 6005443.81991983 | 2103160.76453772 | 37.7551867854403 | -122.424126272898 | (37.7551867854403, -122.424126272898) | 2 | 4 | 5 | 28859 | 19 | ||
133210 | 142723 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008387.4711 | 2121064.7168 | 37.8045125206489 | -122.415213542996 | (37.8045125206489, -122.415213542996) | 5 | 1 | 10 | 308 | 23 | |||
132865 | 225968 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3599 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6005865.3441 | 2101966.56287 | 37.7519315746039 | -122.422583660903 | (37.7519315746039, -122.422583660903) | 2 | 4 | 5 | 28859 | 19 | |||
132781 | 49769 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Schwerin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 4 | Permit Number 46559 | 6008658.89925 | 2086391.11579 | 37.7093219451162 | -122.411822622426 | (37.7093219451162, -122.411822622426) | 9 | 7 | 8 | 309 | 39 | |
132497 | 95583 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 320 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767373 | 6004245 | 2103375 | 37.7557072655698 | -122.428287412943 | (37.7557072655698, -122.428287412943) | 2 | 4 | 5 | 28862 | 22 | |
132169 | 65670 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 954 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28590 | 5998557.99448518 | 2095716.03586207 | 37.7343541747365 | -122.447403560759 | (37.7343541747365, -122.447403560759) | 9 | 7 | 4 | 59 | 40 | ||
131963 | 245455 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2800 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6007994.6854 | 2106818.5473 | 37.7653739107422 | -122.41556356407 | (37.7653739107422, -122.41556356407) | 8 | 4 | 7 | 28853 | 19 | |||
131459 | 10112 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 821 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005694.08607 | 2104163.28117 | 37.7579535897166 | -122.423332040744 | (37.7579535897166, -122.423332040744) | 2 | 4 | 5 | 28859 | 19 | |||
131125 | 98179 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 50-60 Camp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005725 | 2106380 | 37.7640419231114 | -122.423382710222 | (37.7640419231114, -122.423382710222) | 8 | 4 | 5 | 28859 | 19 | ||||
131118 | 59938 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1774 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | Permit Number 19411 | 5999360.65261909 | 2110160.72458075 | 37.7740615827199 | -122.445666937047 | (37.7740615827199, -122.445666937047) | 15 | 5 | 11 | 29492 | 16 | ||
130161 | 122086 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 459 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990589.94258 | 2112248.552 | 37.7792895311955 | -122.476158542806 | (37.7792895311955, -122.476158542806) | 11 | 6 | 2 | 55 | 26 | |||
129759 | 239617 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 998 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009142.86586 | 2103412.72936 | 37.756086783293 | -122.411351634886 | (37.756086783293, -122.411351634886) | 2 | 4 | 7 | 28859 | 19 | |||
129612 | 46907 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1461 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44964 | 5993949.00931755 | 2105566.46922701 | 37.7611365120681 | -122.464053023285 | (37.7611365120681, -122.464053023285) | 1 | 5 | 11 | 56 | 12 | ||
129017 | 225900 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009378.42208 | 2107868.1744 | 37.7683336277295 | -122.410851658572 | (37.7683336277295, -122.410851658572) | 8 | 4 | 7 | 28853 | 19 | |||
128927 | 225953 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 245 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003670.68661 | 2095891.30011 | 37.7351262474841 | -122.429739824559 | (37.7351262474841, -122.429739824559) | 2 | 7 | 5 | 63 | 7 | |||
128761 | 115129 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
128657 | 192413 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 5 | : | Tree | Private 2 | 8 | Width 3ft | 6011782.001 | 2105308.50285 | 37.7614398242054 | -122.402357857724 | (37.7614398242054, -122.402357857724) | 10 | 3 | 8 | 28856 | 29 | |||
128154 | 176514 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 154 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6006291.2518 | 2087400.97553 | 37.7119616963423 | -122.420077226985 | (37.7119616963423, -122.420077226985) | 9 | 7 | 8 | 309 | 39 | |||
127888 | 67548 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1120 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 16 | Permit Number 31094 | 6011900.0943 | 2103205.59495 | 37.7556722956615 | -122.401801597389 | (37.7556722956615, -122.401801597389) | 10 | 3 | 8 | 28856 | 29 | |
127339 | 225917 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 85 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005793.09116 | 2104012.03953 | 37.7575439026326 | -122.422978889581 | (37.7575439026326, -122.422978889581) | 2 | 4 | 5 | 28859 | 19 | |||
126906 | 225940 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 183 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006723.95695 | 2102704.663 | 37.7540066307184 | -122.419666814188 | (37.7540066307184, -122.419666814188) | 2 | 4 | 7 | 28859 | 19 | |||
126795 | 245457 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2800 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007865.341 | 2106811.8898 | 37.7653483594859 | -122.416010466111 | (37.7653483594859, -122.416010466111) | 8 | 4 | 7 | 28853 | 19 | |||
126766 | 22760 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1620 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6002287.3238 | 2112301.156 | 37.7801053300032 | -122.435696258637 | (37.7801053300032, -122.435696258637) | 15 | 5 | 11 | 29490 | 41 | |||
126710 | 46930 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | |
126477 | 10165 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1019 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x4 | 6005763.39401 | 2102897.66691 | 37.7544824188306 | -122.423002391551 | (37.7544824188306, -122.423002391551) | 2 | 4 | 5 | 28859 | 19 | |||
126060 | 10089 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 700 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005586.51976 | 2104851.24563 | 37.7598365074586 | -122.423752966647 | (37.7598365074586, -122.423752966647) | 2 | 4 | 5 | 28859 | 19 | |||
125955 | 225897 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2770 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009476.04285 | 2103963.05006 | 37.7576165210915 | -122.410238245413 | (37.7576165210915, -122.410238245413) | 2 | 4 | 7 | 28859 | 19 | |||
125841 | 26544 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 530 Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/1997 12:00:00 AM | 3 | 4X4 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | 3 | 1 | 10 | 308 | 23 | ||
125276 | 225942 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2741 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008447.49602 | 2106788.13781 | 37.7653158554543 | -122.413995240611 | (37.7653158554543, -122.413995240611) | 8 | 4 | 7 | 28859 | 19 | |||
125083 | 34039 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2741 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37955 | 6008443.32721054 | 2106790.24036099 | 37.7653213944342 | -122.414009808345 | (37.7653213944342, -122.414009808345) | 8 | 4 | 7 | 28859 | 19 | ||
124628 | 225974 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 478 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002948.60968 | 2105430.29379 | 37.7612771701244 | -122.43291756641 | (37.7612771701244, -122.43291756641) | 15 | 4 | 5 | 28862 | 3 | |||
124173 | 225898 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009373.69267 | 2107922.66686 | 37.7684829862389 | -122.410871866347 | (37.7684829862389, -122.410871866347) | 8 | 4 | 7 | 28853 | 19 | |||
124151 | 244202 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 546 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6003923.0756 | 2109749.7244 | 37.7731925042221 | -122.429855409854 | (37.7731925042221, -122.429855409854) | 7 | 9 | 11 | 29492 | 10 | |||
123075 | 219012 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 139 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995316.47386 | 2090822.54609 | 37.7207320630034 | -122.458256412004 | (37.7207320630034, -122.458256412004) | 9 | 8 | 6 | 28861 | 24 | |||
123054 | 49771 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 1 | Permit Number 46559 | 6008634.11039 | 2086335.40293 | 37.7091675783038 | -122.411904362692 | (37.7091675783038, -122.411904362692) | 9 | 7 | 8 | 309 | 39 | |
122480 | 38842 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1273 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 40672 | 6001780.14804372 | 2110445.45784357 | 37.7749812288155 | -122.437317892677 | (37.7749812288155, -122.437317892677) | 15 | 5 | 11 | 29492 | 10 | ||||
121745 | 128876 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1237x Robert C Levy Tunl | 5 | Median : Yard | Tree | DPW 1 | 3 | 6007635.33447 | 2118142.36056 | 37.7964461660197 | -122.417609134775 | (37.7964461660197, -122.417609134775) | 5 | 1 | 10 | 28858 | 32 | ||||
121409 | 225926 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 448 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002953.29528 | 2099219.15304 | 37.7442231148112 | -122.43245771787 | (37.7442231148112, -122.43245771787) | 2 | 7 | 5 | 63 | 22 | |||
120732 | 81925 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2316 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50640 | 6007582.8644 | 2120346.37282 | 37.8024948784062 | -122.417947010953 | (37.8024948784062, -122.417947010953) | 5 | 1 | 1 | 308 | 32 | |
119801 | 32107 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 429 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 10 | Permit Number 35478 | 6002990.68319 | 2105750.27702 | 37.7621581531882 | -122.432794911471 | (37.7621581531882, -122.432794911471) | 15 | 4 | 5 | 28862 | 3 | |
119640 | 10695 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1250 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001856.34415 | 2110522.16346 | 37.7751961745675 | -122.437059807317 | (37.7751961745675, -122.437059807317) | 15 | 5 | 11 | 29492 | 10 | |||
119488 | 59933 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 549 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 9 | Permit Number 19406 | 5999664.8686 | 2110448.6759 | 37.7748695877317 | -122.444635305779 | (37.7748695877317, -122.444635305779) | 15 | 5 | 11 | 29492 | 16 | |
119348 | 128867 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001756.03579 | 2116033.5731 | 37.7903234016642 | -122.437801621649 | (37.7903234016642, -122.437801621649) | 13 | 6 | 1 | 29490 | 27 | |||
118274 | 85304 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 417 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2007 12:00:00 AM | Permit Number 49590 | 5998857 | 2109314 | 37.7717079252645 | -122.447348195836 | (37.7717079252645, -122.447348195836) | 15 | 5 | 11 | 29492 | 9 | |||
118115 | 225963 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 200 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007947.91694 | 2096980.61578 | 37.7383585458117 | -122.415028930344 | (37.7383585458117, -122.415028930344) | 2 | 7 | 7 | 28859 | 2 | |||
117463 | 95134 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 450@ Wayland Somerset St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781342 | 6010117.36612 | 2092259.39432 | 37.7255167458877 | -122.407195288535 | (37.7255167458877, -122.407195288535) | 10 | 3 | 7 | 309 | 28 |
116552 | 65468 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 55 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1989 12:00:00 AM | Permit Number 28348 | 5995598.18541989 | 2090265.07086982 | 37.7192175521634 | -122.457242320925 | (37.7192175521634, -122.457242320925) | 9 | 8 | 6 | 28861 | 24 | ||
116322 | 225918 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1619 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009320.79374 | 2100001.018 | 37.7467289623867 | -122.41049539576 | (37.7467289623867, -122.41049539576) | 2 | 7 | 7 | 28859 | 2 | |||
115177 | 225904 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 50 Camp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005635.69766 | 2106380.47503 | 37.7640381868445 | -122.423691614897 | (37.7640381868445, -122.423691614897) | 8 | 4 | 5 | 28859 | 19 | |||
114891 | 219009 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 161 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995318.79946 | 2090948.50153 | 37.7210780403007 | -122.458257484914 | (37.7210780403007, -122.458257484914) | 9 | 8 | 6 | 28861 | 24 | |||
113428 | 176518 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1501 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6007403.12553 | 2087360.36514 | 37.7119127723386 | -122.416231391376 | (37.7119127723386, -122.416231391376) | 9 | 7 | 8 | 309 | 39 | |||
113210 | 29768 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 640 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/1991 12:00:00 AM | 6 | 6x6 | 6008286.5569 | 2121053.032 | 37.8044747652934 | -122.415561939011 | (37.8044747652934, -122.415561939011) | 5 | 1 | 10 | 308 | 23 | ||
112936 | 142206 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1693 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999789.089 | 2110173.0386 | 37.7741198453954 | -122.444185791724 | (37.7741198453954, -122.444185791724) | 15 | 5 | 11 | 29492 | 16 | |||
112771 | 51725 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1904 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2005 12:00:00 AM | 6 | Permit Number 48537 | 6012320.61849 | 2104715.41974 | 37.7598414015724 | -122.400453331067 | (37.7598414015724, -122.400453331067) | 10 | 3 | 8 | 28856 | 29 | ||
112761 | 69222 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1250 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/2001 12:00:00 AM | 3x3 | Permit Number 33274 | 6008665.27491562 | 2101259.70225891 | 37.7501482575919 | -122.412851097008 | (37.7501482575919, -122.412851097008) | 2 | 4 | 7 | 28859 | 19 | |
111888 | 225939 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1037 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6009456.84269 | 2103117.56685 | 37.75529393828 | -122.410244954342 | (37.75529393828, -122.410244954342) | 2 | 4 | 7 | 28859 | 19 | |||
111491 | 95562 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 467 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767356 | 6003496 | 2099787 | 37.7458130504625 | -122.430621674841 | (37.7458130504625, -122.430621674841) | 2 | 7 | 5 | 63 | 22 | |
111282 | 244548 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1500 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999285.3779 | 2109104.904 | 37.7711582700312 | -122.445851374555 | (37.7711582700312, -122.445851374555) | 15 | 5 | 11 | 29492 | 9 | |||
110586 | 219014 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 154 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995361.04968 | 2090937.11704 | 37.721049208941 | -122.45811061572 | (37.721049208941, -122.45811061572) | 9 | 8 | 6 | 28861 | 24 | |||
110175 | 192409 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 650 Rhode Island St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6011776.86645 | 2105375.28628 | 37.7616229099979 | -122.40238031202 | (37.7616229099979, -122.40238031202) | 10 | 3 | 8 | 28856 | 29 | |||
109935 | 48959 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1521 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | 2 | 7 | 7 | 28859 | 2 | |||
109731 | 45152 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1619 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2001 12:00:00 AM | Permit Number 44005 | 6009316.84366878 | 2099994.11121489 | 37.7467097764312 | -122.410508567135 | (37.7467097764312, -122.410508567135) | 2 | 7 | 7 | 28859 | 2 | ||
109388 | 96194 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1640 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
109240 | 115128 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
109140 | 102653 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 203X Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.459209674514 | (37.7139992025898, -122.459209674514) | 9 | 8 | 6 | 28861 | 24 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );