trees
3,247 rows where qSpecies_id = 22 sorted by qSiteInfo 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117129 | 219070 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 915 Capitol Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995006.51385 | 2090023.52797 | 37.7185203333247 | -122.459270009121 | (37.7185203333247, -122.459270009121) | 9 | 8 | 6 | 28861 | 24 | |||
117504 | 201608 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 598 Innes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6020912.48689 | 2093230.64881 | 37.7287818667771 | -122.369944109446 | (37.7287818667771, -122.369944109446) | 10 | 3 | 8 | 58 | 1 | |||
119051 | 123591 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 26 05th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 5994270.79581 | 2115427.05215 | 37.7882295890949 | -122.463655789773 | (37.7882295890949, -122.463655789773) | 11 | 6 | 1 | 54 | 11 | |||
122500 | 128975 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008334.95209 | 2112397.31521 | 37.7807110132398 | -122.414781508856 | (37.7807110132398, -122.414781508856) | 7 | 10 | 9 | 28852 | 36 | |||
123296 | 120472 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988447.19453 | 2115067.03638 | 37.786903806069 | -122.483777820382 | (37.786903806069, -122.483777820382) | 11 | 6 | 1 | 55 | 33 | |||
123869 | 192479 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1100 Pennsylvania Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014497.46696 | 2101747.35421 | 37.7518128856693 | -122.392716981507 | (37.7518128856693, -122.392716981507) | 10 | 3 | 8 | 28856 | 1 | ||||
125361 | 247437 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 400 Pierce St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/02/2014 12:00:00 AM | 24 | Width 0ft | 6002701.7149 | 2110019.7981 | 37.7738648191641 | -122.434099563044 | (37.7738648191641, -122.434099563044) | 15 | 5 | 11 | 29492 | 10 | ||
125835 | 192476 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1100 Pennsylvania Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014495.23557 | 2101789.67403 | 37.7519289629698 | -122.392727658282 | (37.7519289629698, -122.392727658282) | 10 | 3 | 8 | 28856 | 1 | ||||
129263 | 219106 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1950 08th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993887.94797 | 2102234.36749 | 37.7519839007399 | -122.464022318177 | (37.7519839007399, -122.464022318177) | 1 | 8 | 4 | 29491 | 12 | |||
130896 | 201605 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 570 Innes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6021066.69823 | 2093118.68379 | 37.7284828925695 | -122.369403250859 | (37.7284828925695, -122.369403250859) | 10 | 3 | 8 | 58 | 1 | |||
132945 | 128981 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008536.70915 | 2112423.0867 | 37.7807931096483 | -122.41408535538 | (37.7807931096483, -122.41408535538) | 7 | 10 | 9 | 28852 | 36 | |||
133117 | 182033 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1318 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5988666.672 | 2106312.5286 | 37.7628791367764 | -122.482376807806 | (37.7628791367764, -122.482376807806) | 1 | 8 | 3 | 56 | 35 | |||
137638 | 201607 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 598 Innes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 1 | Width 3ft | 6020934.32673 | 2093214.83409 | 37.7287396409072 | -122.369867514187 | (37.7287396409072, -122.369867514187) | 10 | 3 | 8 | 58 | 1 | ||
139450 | 219107 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1950 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993858.1687 | 2102183.92132 | 37.7518436721727 | -122.464121636607 | (37.7518436721727, -122.464121636607) | 1 | 8 | 4 | 29491 | 12 | |||
141203 | 140887 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 140 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5996576.5404 | 2113403.6496 | 37.782806454531 | -122.455532042867 | (37.782806454531, -122.455532042867) | 11 | 6 | 1 | 54 | 31 | |||
144781 | 120458 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 67 West Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5988579.7702 | 2114992.84531 | 37.7867078149969 | -122.483313703981 | (37.7867078149969, -122.483313703981) | 11 | 6 | 1 | 55 | 33 | |||
146446 | 219068 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 390 Ashton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5994208.7713 | 2092426.53783 | 37.7250725230697 | -122.462201637112 | (37.7250725230697, -122.462201637112) | 9 | 8 | 4 | 28861 | 24 | |||
149358 | 120442 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 77 22nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5988947.55811 | 2114864.8414 | 37.7863777500738 | -122.482031879947 | (37.7863777500738, -122.482031879947) | 11 | 6 | 1 | 55 | 33 | |||
150041 | 128979 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008469.91366 | 2112412.28863 | 37.7807597088309 | -122.414315669952 | (37.7807597088309, -122.414315669952) | 7 | 10 | 9 | 28852 | 36 | |||
150408 | 120460 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 67 West Clay St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988559.61165 | 2114998.49915 | 37.7867221656327 | -122.483383861528 | (37.7867221656327, -122.483383861528) | 11 | 6 | 1 | 55 | 33 | |||
151476 | 128976 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008353.03797 | 2112399.2385 | 37.7807173103084 | -122.41471907703 | (37.7807173103084, -122.41471907703) | 7 | 10 | 9 | 28852 | 36 | |||
151774 | 120473 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5988459.1629 | 2115064.18747 | 37.7868966804599 | -122.483736204114 | (37.7868966804599, -122.483736204114) | 11 | 6 | 1 | 55 | 33 | |||
153512 | 107579 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | 9 | 8 | 4 | 64 | 24 | ||
155680 | 228278 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2050 15th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
156788 | 176525 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 555 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6001927.74225 | 2090254.03018 | 37.7195487332566 | -122.435362686337 | (37.7195487332566, -122.435362686337) | 9 | 7 | 6 | 28861 | 5 | |||
157135 | 201616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 0 Innes Ct | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6021349.55513 | 2092801.07471 | 37.7276263098888 | -122.368403462858 | (37.7276263098888, -122.368403462858) | 10 | 3 | 8 | 58 | 1 | |||
161576 | 219108 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 45 Linares Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994049.66419 | 2102078.05108 | 37.7515640144782 | -122.463451741528 | (37.7515640144782, -122.463451741528) | 1 | 8 | 4 | 29491 | 40 | |||
162248 | 219067 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 390 Ashton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5994207.71828 | 2092406.81664 | 37.7250183128279 | -122.462203847655 | (37.7250183128279, -122.462203847655) | 9 | 8 | 4 | 28861 | 24 | |||
166114 | 128977 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008381.16446 | 2112403.1567 | 37.7807296489991 | -122.41462205098 | (37.7807296489991, -122.41462205098) | 7 | 10 | 9 | 28852 | 36 | |||
166595 | 190586 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1245 03rd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6015582.84086 | 2109273.77078 | 37.7725390266763 | -122.389489148317 | (37.7725390266763, -122.389489148317) | 14 | 3 | 9 | 310 | 20 | |||
171397 | 228257 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 746 Sanchez St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6003677.18233 | 2103771.84402 | 37.7567647596966 | -122.430279417762 | (37.7567647596966, -122.430279417762) | 2 | 4 | 5 | 28862 | 3 | |||
174593 | 226167 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 266 Upper Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5999446.7745 | 2106130.84331 | 37.7630014609621 | -122.445079255819 | (37.7630014609621, -122.445079255819) | 15 | 5 | 5 | 29492 | 9 | |||
175627 | 107582 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.47342 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | 9 | 8 | 4 | 64 | 24 | ||
175973 | 247000 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 415 Valley St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6003159.75235 | 2099193.72668 | 37.7441650051229 | -122.431742019398 | (37.7441650051229, -122.431742019398) | 2 | 7 | 5 | 63 | 22 | |||
176185 | 187408 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 50 Leland Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6010703.7606 | 2087207.6456 | 37.7116784782683 | -122.404812664008 | (37.7116784782683, -122.404812664008) | 9 | 7 | 8 | 309 | 39 | |||
176885 | 120474 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5988469.71157 | 2115060.56996 | 37.7868873618402 | -122.483699443255 | (37.7868873618402, -122.483699443255) | 11 | 6 | 1 | 55 | 33 | |||
177392 | 219110 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 45 Linares Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993942.77446 | 2102207.53523 | 37.7519133858187 | -122.463830774294 | (37.7519133858187, -122.463830774294) | 1 | 8 | 4 | 29491 | 12 | |||
182302 | 120446 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 22nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988945.57573 | 2114940.19348 | 37.7865845302304 | -122.482044260519 | (37.7865845302304, -122.482044260519) | 11 | 6 | 1 | 55 | 33 | |||
182443 | 107581 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992393.94682 | 2086830.99569 | 37.7096038591978 | -122.468068397753 | (37.7096038591978, -122.468068397753) | 9 | 8 | 4 | 64 | 24 | ||
182462 | 201606 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 598 Innes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 1 | Width 3ft | 6020954.32481 | 2093200.46357 | 37.7287012794353 | -122.369797385941 | (37.7287012794353, -122.369797385941) | 10 | 3 | 8 | 58 | 1 | ||
183085 | 190588 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1245 03rd St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6015580.36907 | 2109321.80204 | 37.7726707728775 | -122.389501053548 | (37.7726707728775, -122.389501053548) | 14 | 3 | 9 | 310 | 20 | |||
183095 | 225623 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 615 Buena Vista Ave West | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5999830.8005 | 2107620.03218 | 37.7671123132949 | -122.443858043933 | (37.7671123132949, -122.443858043933) | 15 | 5 | 5 | 29492 | 9 | |||
183738 | 190587 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1245 03rd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6015583.31199 | 2109308.81865 | 37.7726352865222 | -122.389489966697 | (37.7726352865222, -122.389489966697) | 14 | 3 | 9 | 310 | 20 | |||
191354 | 219102 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 524 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993068.50132 | 2099447.34757 | 37.744284195874 | -122.466653494359 | (37.744284195874, -122.466653494359) | 1 | 8 | 4 | 29491 | 40 | |||
16333 | 128995 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1414 Jones St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6008424.44271 | 2117443.95005 | 37.7945728745903 | -122.41482918821 | (37.7945728745903, -122.41482918821) | 5 | 1 | 10 | 28858 | 21 | |||
29859 | 128994 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1414 Jones St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6008423.06087 | 2117463.28601 | 37.7946258887275 | -122.414835338698 | (37.7946258887275, -122.414835338698) | 5 | 1 | 10 | 28858 | 21 | |||
42849 | 129009 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1137 Montgomery St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 3ft | 6011525.13377 | 2119231.56027 | 37.7996549551749 | -122.404226217291 | (37.7996549551749, -122.404226217291) | 3 | 1 | 10 | 308 | 23 | |||
48949 | 244952 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 290 Page St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 0ft | 6005205.1684 | 2109938.5353 | 37.7737834538473 | -122.425433917449 | (37.7737834538473, -122.425433917449) | 7 | 9 | 11 | 28852 | 10 | |||
73582 | 129023 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 400 Montgomery St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6011906.72239 | 2116826.46817 | 37.7930724645857 | -122.40273653976 | (37.7930724645857, -122.40273653976) | 4 | 1 | 10 | 28854 | 6 | |||
74894 | 228337 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1768 Sanchez St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6003964.05943 | 2097961.58291 | 37.740827380874 | -122.428873076831 | (37.740827380874, -122.428873076831) | 2 | 7 | 5 | 63 | 7 | |||
87514 | 226270 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 4491 24th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 26 | Width 8ft | 6000072.43582 | 2101640.71207 | 37.7507083509117 | -122.442592908247 | (37.7507083509117, -122.442592908247) | 2 | 4 | 5 | 28862 | 22 | |||
117805 | 129024 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 400 Montgomery St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6011905.28525 | 2116843.33674 | 37.7931187014156 | -122.40274269923 | (37.7931187014156, -122.40274269923) | 4 | 1 | 10 | 28854 | 6 | |||
138594 | 226015 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2440 24th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6011224.38926 | 2102319.51011 | 37.7532015702139 | -122.404076055683 | (37.7532015702139, -122.404076055683) | 10 | 4 | 8 | 28859 | 19 | |||
38 | 167409 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 4 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6001979.94285 | 2107686.90453 | 37.7674182815445 | -122.436429284105 | (37.7674182815445, -122.436429284105) | 15 | 5 | 5 | 29492 | 3 | |
56 | 124 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1032 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6002037.12702 | 2107659.05322 | 37.7673450578674 | -122.436229498819 | (37.7673450578674, -122.436229498819) | 15 | 5 | 5 | 29492 | 3 | |
288 | 125298 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010056.95509 | 2118170.07703 | 37.7966582351325 | -122.409231726859 | (37.7966582351325, -122.409231726859) | 3 | 1 | 10 | 308 | 4 | |||
321 | 219060 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000072.85251 | 2094491.10418 | 37.731077247812 | -122.442078323383 | (37.731077247812, -122.442078323383) | 9 | 7 | 4 | 63 | 40 | |||
692 | 61241 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1984 12:00:00 AM | Permit Number 21113 | 6003879.55901956 | 2104241.51200503 | 37.7580658175007 | -122.429613020503 | (37.7580658175007, -122.429613020503) | 2 | 4 | 5 | 28862 | 3 | ||
757 | 226221 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009154.30275 | 2103871.8716 | 37.7573481256189 | -122.411344516752 | (37.7573481256189, -122.411344516752) | 2 | 4 | 7 | 28859 | 19 | |||
796 | 36869 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
881 | 254388 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
1069 | 49087 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 692 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2003 12:00:00 AM | Permit Number 46237 | 6012085.19773634 | 2105185.1896517 | 37.7611181541392 | -122.401300553818 | (37.7611181541392, -122.401300553818) | 10 | 3 | 8 | 28856 | 29 | |||
1198 | 225665 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 300x Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006874 | 2096520 | 37.7370333899893 | -122.418709361786 | (37.7370333899893, -122.418709361786) | 2 | 7 | 7 | 28859 | 2 | |||
1246 | 160377 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 824 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001767.32645 | 2089068.63157 | 37.7162847814869 | -122.435832414836 | (37.7162847814869, -122.435832414836) | 9 | 7 | 6 | 28861 | 5 | ||
1277 | 220672 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 25 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6005444.88154 | 2104573.79472 | 37.759066695887 | -122.424223091727 | (37.759066695887, -122.424223091727) | 2 | 4 | 5 | 28859 | 19 | |||
1506 | 70618 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1557 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6007346.38924 | 2116443.24691 | 37.7917645589423 | -122.418488407316 | (37.7917645589423, -122.418488407316) | 5 | 1 | 10 | 28858 | 21 | |||
1594 | 264718 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 6012426 | 2106899 | 37.7658429041656 | -122.400242229593 | (37.7658429041656, -122.400242229593) | 14 | 3 | 8 | 28856 | 20 | |||
1608 | 32205 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1697 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 8 | Permit Number 35528 | 6009341.58261 | 2099615.8477 | 37.7456725350783 | -122.410396317437 | (37.7456725350783, -122.410396317437) | 2 | 7 | 7 | 28859 | 2 | |
1649 | 92526 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
1669 | 35520 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41442 | 6005793.71652674 | 2102887.49607432 | 37.7544562030797 | -122.422896805421 | (37.7544562030797, -122.422896805421) | 2 | 4 | 5 | 28859 | 19 | ||
1686 | 225676 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008816.88964 | 2096900.69924 | 37.7381879057352 | -122.412018790637 | (37.7381879057352, -122.412018790637) | 10 | 7 | 7 | 28859 | 2 | |||
1811 | 258532 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1565 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777683 | 6006695.00356 | 2117330.6469 | 37.7941644464503 | -122.420805231935 | (37.7941644464503, -122.420805231935) | 13 | 9 | 10 | 28858 | 32 | |
1918 | 262485 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 500X Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6009406 | 2087980 | 37.7137265813857 | -122.409352565386 | (37.7137265813857, -122.409352565386) | 9 | 7 | 8 | 309 | 39 | |||
1952 | 129457 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010137.05679 | 2118184.23209 | 37.7967015887668 | -122.408955554965 | (37.7967015887668, -122.408955554965) | 3 | 1 | 10 | 308 | 4 | |||
2060 | 150281 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Wisconsin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012538.7082 | 2106843.10365 | 37.7656957093017 | -122.399848467747 | (37.7656957093017, -122.399848467747) | 14 | 3 | 8 | 28856 | 20 | |||
2109 | 71599 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5994726.40181 | 2086320.41636 | 37.7083363538073 | -122.459970121431 | (37.7083363538073, -122.459970121431) | 9 | 8 | 6 | 28861 | 25 | |||
2312 | 71328 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 228 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004151.95998 | 2089814.42795 | 37.7184677472758 | -122.427643069565 | (37.7184677472758, -122.427643069565) | 9 | 7 | 6 | 28861 | 5 | |||
2367 | 226104 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 269 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005509.798 | 2107472.48259 | 37.7670294722636 | -122.424204733868 | (37.7670294722636, -122.424204733868) | 8 | 4 | 5 | 28853 | 19 | |||
2409 | 225663 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006114.92527 | 2097621.73369 | 37.7400157373359 | -122.421412046638 | (37.7400157373359, -122.421412046638) | 2 | 7 | 7 | 28859 | 2 | |||
2416 | 192496 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Kansas St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011473.84765 | 2106919.34293 | 37.765845622699 | -122.403536974176 | (37.765845622699, -122.403536974176) | 8 | 3 | 8 | 28853 | 20 | |||
2444 | 187616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/03/2013 12:00:00 AM | 3x3 | 6013035 | 2114021 | 37.78543223702 | -122.398635644163 | (37.78543223702, -122.398635644163) | 6 | 2 | 9 | 28855 | 6 | ||
2467 | 5648 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/1997 12:00:00 AM | 12 | 3x3 | 6005228.5165 | 2100736.64221 | 37.748518548493 | -122.424698417605 | (37.748518548493, -122.424698417605) | 2 | 4 | 5 | 28859 | 19 | ||
2577 | 31869 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 166 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 1 | Permit Number 35311 | 6000215.42905 | 2104900.21847 | 37.759666310759 | -122.442332399837 | (37.759666310759, -122.442332399837) | 2 | 4 | 5 | 28862 | 3 | |
2637 | 262319 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011556 | 2107033 | 37.7661622878471 | -122.403260820888 | (37.7661622878471, -122.403260820888) | 8 | 2 | 8 | 28853 | 20 | ||||
2645 | 137669 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1927 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6000327.0363 | 2111629.9151 | 37.7781507333481 | -122.442429558556 | (37.7781507333481, -122.442429558556) | 15 | 5 | 11 | 29490 | 16 | |||
2803 | 39877 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
2836 | 219119 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002030.49307 | 2095074.13161 | 37.7327894760326 | -122.435352122012 | (37.7327894760326, -122.435352122012) | 9 | 7 | 5 | 63 | 40 | |||
2843 | 243848 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2976 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2017 12:00:00 AM | 3 | Width 3ft | 6009037.26284 | 2102182.62574 | 37.7527032720445 | -122.411629937289 | (37.7527032720445, -122.411629937289) | 2 | 4 | 7 | 28859 | 19 | ||
3016 | 190529 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 Clarence Pl | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6014722.79424 | 2111890.37318 | 37.7796759079438 | -122.392647234607 | (37.7796759079438, -122.392647234607) | 6 | 2 | 9 | 28856 | 6 | |||
3134 | 190600 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015217.08572 | 2107526.40267 | 37.7677208521577 | -122.390632216307 | (37.7677208521577, -122.390632216307) | 14 | 3 | 9 | 310 | 20 | |||
3143 | 46360 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 514 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2002 12:00:00 AM | 2 | Permit Number 44598 | 5988790.17087 | 2111781.31969 | 37.7779021128043 | -122.482350384801 | (37.7779021128043, -122.482350384801) | 11 | 6 | 2 | 55 | 26 | |
3155 | 171861 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 600 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009150.18336 | 2091330.30171 | 37.722911477365 | -122.410473193303 | (37.722911477365, -122.410473193303) | 9 | 3 | 7 | 309 | 28 | |||
3333 | 66070 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 517 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 7 | Permit Number 29111 | 6014120.17951 | 2104674.3104 | 37.7598287157536 | -122.39422660508 | (37.7598287157536, -122.39422660508) | 10 | 3 | 8 | 28856 | 29 | |
3402 | 81722 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014944.17963 | 2104119.9743 | 37.758352394954 | -122.391338017739 | (37.758352394954, -122.391338017739) | 10 | 3 | 8 | 28856 | 29 | |||
3435 | 226185 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 160 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008635.20088 | 2097780.05534 | 37.7405922297483 | -122.412709130925 | (37.7405922297483, -122.412709130925) | 10 | 7 | 7 | 28859 | 2 | |||
3516 | 92206 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 443 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775730 | 6002885.09645 | 2091274.76844 | 37.7224057768794 | -122.432126318576 | (37.7224057768794, -122.432126318576) | 9 | 7 | 6 | 28861 | 5 | |
3595 | 219121 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002025.50342 | 2095049.38545 | 37.7327212453836 | -122.435367602937 | (37.7327212453836, -122.435367602937) | 9 | 7 | 5 | 63 | 40 | |||
3597 | 93954 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012934.64989 | 2114104.90951 | 37.7856570416874 | -122.398988719454 | (37.7856570416874, -122.398988719454) | 6 | 2 | 9 | 28855 | 6 | |
3744 | 39401 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
3762 | 159863 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 31 Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781524 | 6001585.86798 | 2091604.37779 | 37.7232370625303 | -122.436641024974 | (37.7232370625303, -122.436641024974) | 9 | 7 | 6 | 28861 | 25 |
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) );