trees
3,965 rows where qSpecies_id = 70 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194496 | 265137 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 90X Broadmoor Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x6 | 5991049 | 2093460 | 37.7277277099678 | -122.47319985648 | (37.7277277099678, -122.47319985648) | 9 | 8 | 4 | 64 | 40 | ||||
194313 | 111849 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 785307 | 6000127.71624 | 2117950.98913 | 37.7954953973371 | -122.443573271798 | (37.7954953973371, -122.443573271798) | 13 | 9 | 1 | 57 | 17 | ||
194303 | 111847 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 785307 | 6000127.3505 | 2117932.29224 | 37.7954440397598 | -122.443573193555 | (37.7954440397598, -122.443573193555) | 13 | 9 | 1 | 57 | 17 | ||
194295 | 111848 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 785307 | 6000127.46619 | 2117938.95057 | 37.7954623283723 | -122.443573271789 | (37.7954623283723, -122.443573271789) | 13 | 9 | 1 | 57 | 17 | ||
194294 | 111846 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785307 | 6000128.0406 | 2117924.83666 | 37.7954236080649 | -122.443570269862 | (37.7954236080649, -122.443570269862) | 13 | 9 | 1 | 57 | 17 | |
194273 | 263629 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1985X Alemany Blvd | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 785142 | 6000955 | 2090559 | 37.7203308201534 | -122.438746936552 | (37.7203308201534, -122.438746936552) | 9 | 7 | 6 | 28861 | 25 | |||
194185 | 203974 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 264 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 4ft | 5994004.62814 | 2098904.36751 | 37.7428472878804 | -122.463377197624 | (37.7428472878804, -122.463377197624) | 1 | 8 | 4 | 59 | 40 | |||
194163 | 183710 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1205 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5984255.4943 | 2106945.8685 | 37.7643605222858 | -122.497680065967 | (37.7643605222858, -122.497680065967) | 1 | 8 | 3 | 56 | 35 | |||
194117 | 124781 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3055 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000933.00357 | 2118922.11994 | 37.7982077607251 | -122.440856545798 | (37.7982077607251, -122.440856545798) | 13 | 9 | 1 | 57 | 17 | |||
194113 | 181562 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984861.0859 | 2106095.0617 | 37.7620599263149 | -122.495522768827 | (37.7620599263149, -122.495522768827) | 1 | 8 | 3 | 56 | 35 | |||
193975 | 203903 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5002 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5990622.28371 | 2093237.14363 | 37.727091085566 | -122.474658748425 | (37.727091085566, -122.474658748425) | 9 | 8 | 4 | 64 | 40 | |||
193946 | 102631 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 175 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769999 | 5987997.5 | 2114816.6 | 37.7861899917282 | -122.485315257259 | (37.7861899917282, -122.485315257259) | 11 | 6 | 1 | 55 | 33 | |||
193807 | 125139 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2637 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6000119.7154 | 2117672.97114 | 37.7947315770624 | -122.443580974507 | (37.7947315770624, -122.443580974507) | 13 | 9 | 1 | 57 | 27 | |||
193643 | 187769 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1444 Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6016076.38007 | 2097543.12037 | 37.7403564940456 | -122.386963644264 | (37.7403564940456, -122.386963644264) | 10 | 3 | 8 | 58 | 1 | |||
193544 | 6946 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 566 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x4 | 6004669.16029 | 2110552.41632 | 37.7754387224635 | -122.427331794438 | (37.7754387224635, -122.427331794438) | 7 | 9 | 11 | 28852 | 10 | |||
193515 | 124806 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2860 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5999197.36695 | 2118744.91549 | 37.7976222040597 | -122.446849582964 | (37.7976222040597, -122.446849582964) | 13 | 9 | 1 | 57 | 17 | |||
193459 | 220165 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 29 | Front Yard : Yard | Tree | Private 2 | 22 | 6004939.36103 | 2096521.46367 | 37.7369282937109 | -122.425398386937 | (37.7369282937109, -122.425398386937) | 2 | 7 | 5 | 28859 | 2 | ||||
193452 | 123355 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 706 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 4ft | 5994755.9803 | 2110676.184 | 37.7752129260933 | -122.461632557387 | (37.7752129260933, -122.461632557387) | 11 | 6 | 2 | 54 | 11 | |||
193443 | 138341 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2250 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001827.6702 | 2114321.0768 | 37.7856253996885 | -122.437431090913 | (37.7856253996885, -122.437431090913) | 13 | 6 | 1 | 29490 | 27 | |||
193373 | 203688 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 950 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5991858.41058 | 2105254.40313 | 37.7601589521859 | -122.471260701418 | (37.7601589521859, -122.471260701418) | 1 | 8 | 4 | 56 | 12 | |||
193342 | 124857 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Casa Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001735.95246 | 2121430.00924 | 37.8051394589735 | -122.438257867517 | (37.8051394589735, -122.438257867517) | 13 | 9 | 1 | 57 | 17 | |||
193082 | 141595 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 15 ATALAYA TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5998812.2944 | 2110989.0674 | 37.7763046766786 | -122.447623435448 | (37.7763046766786, -122.447623435448) | 15 | 6 | 2 | 29492 | 16 | |||
193027 | 187752 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000 Oakdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6018083.61672 | 2093238.62842 | 37.7286481456935 | -122.379724357202 | (37.7286481456935, -122.379724357202) | 10 | 3 | 8 | 58 | 1 | ||||
193013 | 203717 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 310 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991970.60241 | 2097771.08027 | 37.7396181731262 | -122.470327710568 | (37.7396181731262, -122.470327710568) | 1 | 8 | 4 | 59 | 40 | |||
192979 | 89262 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Polk St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||||
192871 | 173728 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 994 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | 6012439 | 2103318 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | 10 | 3 | 8 | 28856 | 29 | |||
192863 | 106188 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1353 ULLOA ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 4x15 | 5991777 | 2098367.4 | 37.7412443198206 | -122.471040528993 | (37.7412443198206, -122.471040528993) | 1 | 8 | 4 | 59 | 40 | |||
192788 | 184841 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984637.2894 | 2106860.5086 | 37.7641485212291 | -122.496353264421 | (37.7641485212291, -122.496353264421) | 1 | 8 | 3 | 56 | 35 | |||
192779 | 182703 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1819 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5988641.4448 | 2103725.1166 | 37.7557733357838 | -122.482274480216 | (37.7557733357838, -122.482274480216) | 1 | 8 | 3 | 56 | 35 | |||
192716 | 203757 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992536.87292 | 2097880.10011 | 37.7399502379196 | -122.468377737549 | (37.7399502379196, -122.468377737549) | 1 | 8 | 4 | 59 | 40 | |||
192713 | 203740 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 75 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993111.94031 | 2098586.25042 | 37.7419223477532 | -122.46644072016 | (37.7419223477532, -122.46644072016) | 1 | 8 | 4 | 59 | 40 | |||
192645 | 8247 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500X Galvez Ave | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | |||
192636 | 217756 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 West Portal Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5991795.29783 | 2096615.56127 | 37.7364352736738 | -122.470849682473 | (37.7364352736738, -122.470849682473) | 1 | 8 | 4 | 29491 | 40 | |||
192601 | 203945 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2579 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991715.80084 | 2097896.72117 | 37.7399484158804 | -122.471217847832 | (37.7399484158804, -122.471217847832) | 1 | 8 | 4 | 29491 | 40 | |||
192584 | 23574 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3035 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6005498.03712 | 2120829.33235 | 37.8037034071495 | -122.425195941456 | (37.8037034071495, -122.425195941456) | 13 | 9 | 1 | 28858 | 17 | |||
192507 | 139603 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1173 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6001836.2075 | 2112462.5832 | 37.7805229342453 | -122.437268433743 | (37.7805229342453, -122.437268433743) | 15 | 5 | 11 | 29490 | 41 | |||
192491 | 124952 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 232 Maple St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 5996648.67677 | 2115450.86718 | 37.7884317073951 | -122.455430490336 | (37.7884317073951, -122.455430490336) | 11 | 6 | 1 | 54 | 31 | |||
192441 | 98513 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 De Montfort Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 775766 | 5995016.6 | 2091971.4 | 37.7238693046984 | -122.459376132933 | (37.7238693046984, -122.459376132933) | 9 | 8 | 4 | 28861 | 24 | ||
192355 | 116486 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3101 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5999315.33547 | 2116299.88566 | 37.7909155395754 | -122.44626540675 | (37.7909155395754, -122.44626540675) | 13 | 6 | 1 | 29490 | 31 | |||
192327 | 8238 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500X Galvez Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6X3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | |||
192314 | 125277 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1285 Greenwich St | 2 | Side Yard : Yard | Tree | Private 2 | 10 | 6006721.71386 | 2119753.35883 | 37.8008181095192 | -122.420884898228 | (37.8008181095192, -122.420884898228) | 5 | 1 | 1 | 28858 | 32 | ||||
192235 | 188596 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Rhode Island St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 7ft | 6011998.11194 | 2102296.49626 | 37.7531815791825 | -122.401398733471 | (37.7531815791825, -122.401398733471) | 10 | 3 | 8 | 28856 | 29 | |||
192134 | 3768 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1098 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
192020 | 6747 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1215 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6017390.63175 | 2096829.56918 | 37.7384699097667 | -122.382369804725 | (37.7384699097667, -122.382369804725) | 10 | 3 | 8 | 58 | 1 | |||
191880 | 203942 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1427 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5991551.86269 | 2098375.26124 | 37.7412528807104 | -122.471819539243 | (37.7412528807104, -122.471819539243) | 1 | 8 | 4 | 29491 | 40 | |||
191820 | 122912 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 12th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 6ft | 5992124.93885 | 2114841.80236 | 37.7864987754489 | -122.471037373141 | (37.7864987754489, -122.471037373141) | 11 | 6 | 1 | 54 | 11 | |||
191678 | 250948 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5987141.62407 | 2114456.19432 | 37.7851505237326 | -122.488249829271 | (37.7851505237326, -122.488249829271) | 11 | 6 | 1 | 55 | 33 | |||
191672 | 217842 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 32 | Front Yard : Yard | Tree | Private 2 | 8 | 5991425.94511 | 2095892.37177 | 37.734428210799 | -122.472073981738 | (37.734428210799, -122.472073981738) | 1 | 8 | 4 | 64 | 40 | ||||
191606 | 39248 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3168 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.412982801874 | (37.7483859278404, -122.412982801874) | 2 | 4 | 7 | 28859 | 19 | |||
191601 | 124875 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3636 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997387.91317 | 2115752.3977 | 37.7893020191102 | -122.452894636001 | (37.7893020191102, -122.452894636001) | 11 | 6 | 1 | 54 | 31 | |||
191592 | 200550 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 26 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6016212.9331 | 2095623.1152 | 37.7350921083386 | -122.386357662249 | (37.7350921083386, -122.386357662249) | 10 | 3 | 8 | 58 | 1 | |||
191580 | 221370 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 675 Sanchez St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 3ft | 6003706.22318 | 2104404.27248 | 37.7585029028146 | -122.430224101377 | (37.7585029028146, -122.430224101377) | 2 | 4 | 5 | 28862 | 3 | |||
191515 | 220203 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1475 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6010135.22584 | 2100726.27725 | 37.7487659897773 | -122.407730288036 | (37.7487659897773, -122.407730288036) | 2 | 4 | 7 | 28859 | 19 | |||
191511 | 125109 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3141 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5999155.05388 | 2116275.98418 | 37.7908407573341 | -122.446818251472 | (37.7908407573341, -122.446818251472) | 13 | 6 | 1 | 29490 | 31 | |||
191472 | 34879 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 211 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38492 | 6014657.62995196 | 2115836.08195439 | 37.7905063026103 | -122.393148834356 | (37.7905063026103, -122.393148834356) | 6 | 2 | 9 | 28855 | 6 | ||||
191431 | 200535 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 11 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6016168.4829 | 2095664.0064 | 37.7352019267754 | -122.386514194261 | (37.7352019267754, -122.386514194261) | 10 | 3 | 8 | 58 | 1 | |||
191410 | 123196 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 543 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5993110.70056 | 2111778.48241 | 37.7781446980418 | -122.467404075887 | (37.7781446980418, -122.467404075887) | 11 | 6 | 2 | 54 | 11 | |||
191403 | 121109 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 416 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x6 | 5996806.9264 | 2110369.3662 | 37.7744883268229 | -122.454515741886 | (37.7744883268229, -122.454515741886) | 15 | 5 | 2 | 29492 | 16 | |||
191369 | 22565 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 231 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 6001358.74635 | 2097645.73608 | 37.7398123322633 | -122.437858639569 | (37.7398123322633, -122.437858639569) | 2 | 7 | 5 | 63 | 7 | |||
191347 | 188647 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Cargo Way | 10 | Median : Yard | Tree | DPW 1 | 17 | 6018073.11672 | 2098111.74487 | 37.7420281826481 | -122.38009915058 | (37.7420281826481, -122.38009915058) | 10 | 3 | 8 | 58 | 1 | ||||
191307 | 188739 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 7 | Median : Yard | Tree | DPW 1 | 18 | Width 8ft | 6014439.36233 | 2086971.42049 | 37.7112379444543 | -122.391884803738 | (37.7112379444543, -122.391884803738) | 10 | 3 | 8 | 58 | 1 | |||
191261 | 123161 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 511 10th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5992793.37077 | 2111978.93196 | 37.7786767533022 | -122.46851641299 | (37.7786767533022, -122.46851641299) | 11 | 6 | 2 | 54 | 11 | ||||
191251 | 220281 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Bemis St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6003914.80845 | 2097011.80991 | 37.7382167335113 | -122.428975669715 | (37.7382167335113, -122.428975669715) | 2 | 7 | 5 | 63 | 7 | ||||
191218 | 205122 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1251 Portola Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994227.2119 | 2097869.58545 | 37.7400188561762 | -122.462532528279 | (37.7400188561762, -122.462532528279) | 1 | 8 | 4 | 59 | 40 | |||
191186 | 125214 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2101 Washington St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6004729.01649 | 2116727.35326 | 37.7923969487148 | -122.427564762007 | (37.7923969487148, -122.427564762007) | 13 | 9 | 1 | 28858 | 27 | |||
191138 | 114575 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3621 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5997436.35352 | 2115714.92269 | 37.7892018984917 | -122.452724333156 | (37.7892018984917, -122.452724333156) | 11 | 6 | 1 | 54 | 31 | |||
191135 | 181560 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984861.3745 | 2106086.3243 | 37.7620359527601 | -122.49552112623 | (37.7620359527601, -122.49552112623) | 1 | 8 | 3 | 56 | 35 | |||
191128 | 6927 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 488 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005098.7367 | 2110617.0491 | 37.7756404737796 | -122.425850388577 | (37.7756404737796, -122.425850388577) | 7 | 9 | 11 | 28852 | 10 | |||
190907 | 100386 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5989668.805 | 2104235.219 | 37.7572336462205 | -122.478758883384 | (37.7572336462205, -122.478758883384) | 1 | 8 | 3 | 56 | 35 | |||
190901 | 92956 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
190858 | 203869 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5995595.19547 | 2089971.45111 | 37.7184111700071 | -122.457231426804 | (37.7184111700071, -122.457231426804) | 9 | 8 | 6 | 28861 | 24 | |||
190854 | 97981 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 11 | Front Yard : Yard | Tree | Private 2 | 3x105 | 6008582.5 | 2094142.5 | 37.7306013339748 | -122.412634267782 | (37.7306013339748, -122.412634267782) | 9 | 3 | 7 | 309 | 28 | ||||
190793 | 247792 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 30th St | 8 | : | Tree | Private 2 | 10 | Width 3ft | 6004127.24522 | 2098408.26883 | 37.742063113215 | -122.42834067009 | (37.742063113215, -122.42834067009) | 2 | 7 | 5 | 63 | 22 | |||
190688 | 34955 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38552 | 5990784 | 2114938 | 37.786685259507 | -122.475683667555 | (37.786685259507, -122.475683667555) | 11 | 6 | 1 | 54 | 33 | ||||
190591 | 6745 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300X Fairfax Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
190560 | 108342 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 390x JERSEY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002599 | 2101610 | 37.7507677214535 | -122.433853648065 | (37.7507677214535, -122.433853648065) | 2 | 4 | 5 | 28862 | 22 | ||||
190480 | 205136 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1970 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 3ft | 5993811.8327 | 2102056.77713 | 37.7514918960558 | -122.464272641796 | (37.7514918960558, -122.464272641796) | 1 | 8 | 4 | 29491 | 12 | |||
190420 | 125063 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 610 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004567.91234 | 2110590.84618 | 37.7755385148274 | -122.427684773828 | (37.7755385148274, -122.427684773828) | 7 | 9 | 11 | 28852 | 10 | |||
190379 | 182719 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1704 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5987209.8948 | 2103643.7982 | 37.7554666839422 | -122.487219202852 | (37.7554666839422, -122.487219202852) | 1 | 8 | 3 | 56 | 35 | |||
190281 | 139619 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1817 EDDY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001794.7901 | 2112532.8884 | 37.7807136199949 | -122.437416751748 | (37.7807136199949, -122.437416751748) | 15 | 5 | 11 | 29490 | 41 | |||
190247 | 51623 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 25 Short St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47918 | 6000046.75417134 | 2104161.05228348 | 37.7576271269874 | -122.44286268101 | (37.7576271269874, -122.44286268101) | 2 | 4 | 5 | 28862 | 3 | ||||
190240 | 139460 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 822 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001026.3641 | 2111511.4487 | 37.777865290258 | -122.440001839118 | (37.777865290258, -122.440001839118) | 15 | 5 | 11 | 29490 | 41 | |||
190199 | 175014 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | Width 8ft | 6013188.07866 | 2087071.75218 | 37.7114438900863 | -122.396216610525 | (37.7114438900863, -122.396216610525) | 10 | 3 | 8 | 309 | 1 | |||
190187 | 250583 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2201 Golden Gate Ave | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 25 | Width 4ft | 5997549.22583 | 2111234.92705 | 37.7769074772273 | -122.452010459418 | (37.7769074772273, -122.452010459418) | 15 | 6 | 2 | 29492 | 16 | |||
190153 | 125318 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6013183.07782 | 2118614.70431 | 37.7980537176562 | -122.398445780741 | (37.7980537176562, -122.398445780741) | 3 | 1 | 10 | 28860 | 6 | |||
190128 | 10319 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 739 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6002579.70252 | 2109173.84871 | 37.7715351260824 | -122.434461126791 | (37.7715351260824, -122.434461126791) | 15 | 5 | 11 | 29492 | 9 | |||
190117 | 188716 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6014770.59198 | 2115729.03116 | 37.7902186405175 | -122.39275049743 | (37.7902186405175, -122.39275049743) | 6 | 2 | 9 | 28855 | 6 | |||
189962 | 30841 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2586 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1995 12:00:00 AM | 22 | Permit Number 34689 | 6002395.11591 | 2116122.86039 | 37.7906048804643 | -122.435596842818 | (37.7906048804643, -122.435596842818) | 13 | 9 | 1 | 29490 | 27 | ||
189917 | 125070 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2134 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6001880.87041 | 2115920.51116 | 37.7900200603243 | -122.43736160408 | (37.7900200603243, -122.43736160408) | 13 | 6 | 1 | 29490 | 27 | |||
189858 | 108154 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 350 HILL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6004022.3 | 2103383.2 | 37.7557171771691 | -122.42905816498 | (37.7557171771691, -122.42905816498) | 2 | 4 | 5 | 28862 | 22 | |||
189818 | 221408 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3975 22nd St | 3 | : | Tree | Private 2 | 11 | 6001990.46485 | 2102928.21102 | 37.7543526628574 | -122.43605233057 | (37.7543526628574, -122.43605233057) | 2 | 4 | 5 | 28862 | 22 | ||||
189772 | 247329 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 785 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6003680.5695 | 2110362.616 | 37.7748616179268 | -122.43073801521 | (37.7748616179268, -122.43073801521) | 7 | 9 | 11 | 29492 | 10 | |||
189714 | 99906 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
189688 | 184884 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984688.9312 | 2106783.4256 | 37.7639398980625 | -122.496168965531 | (37.7639398980625, -122.496168965531) | 1 | 8 | 3 | 56 | 35 | |||
189686 | 124914 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5998986.59365 | 2115887.25221 | 37.7897637769339 | -122.447373122385 | (37.7897637769339, -122.447373122385) | 13 | 6 | 1 | 54 | 31 | |||
189674 | 125282 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1151 Lombard St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6006775.37415 | 2120099.55836 | 37.8017717101681 | -122.420723801756 | (37.8017717101681, -122.420723801756) | 5 | 1 | 1 | 28858 | 32 | ||||
189638 | 221385 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 84 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001442.14467 | 2107662.58176 | 37.767320923637 | -122.438287707917 | (37.767320923637, -122.438287707917) | 15 | 5 | 5 | 29492 | 3 | |||
189619 | 203791 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1992 09th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 6ft | 5993497.88442 | 2101974.58502 | 37.7512481168052 | -122.46535233455 | (37.7512481168052, -122.46535233455) | 1 | 8 | 4 | 29491 | 12 | |||
189388 | 99899 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||
189331 | 92957 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 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) );