Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112803 | 112803 | 104952 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 113878 | 113878 | 104954 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 114226 | 114226 | 110115 | Undocumented 2 | Phoenix roebelenii :: Pigmy Date Palm 344 | 185x SANSOME ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9x90 | 6012318.0 | 2116367.0 | 37.7918338284962 | -122.40128118389099 | (37.7918338284962, -122.401281183891) | ||||
| 114274 | 114274 | 110143 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1130X PORTOLA DR | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 3x3 | 5994964.0 | 2098019.0 | 37.7404715144277 | -122.459995857341 | (37.7404715144277, -122.459995857341) | ||||
| 114615 | 114615 | 104938 | Undocumented 2 | Privet :: 262 | 101 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | missing? | 5990474.7 | 2090014.4 | 37.718233681711204 | -122.47493379652201 | (37.7182336817112, -122.474933796522) | ||||
| 115356 | 115356 | 106044 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 415 DEWEY BLVD | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5995172.1 | 2100351.0 | 37.7468865723154 | -122.45944518004801 | (37.7468865723154, -122.459445180048) | ||||||
| 115747 | 115747 | 97403 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2 STANFORD HEIGHTS AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5997807.0 | 2095590.8 | 37.7339673631019 | -122.449990957178 | (37.7339673631019, -122.449990957178) | |||||
| 115865 | 115865 | 104878 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 234 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/25/2013 12:00:00 AM | Permit Number 771117 | 5987170.1 | 2114381.0 | 37.784945722992504 | -122.488145785283 | (37.7849457229925, -122.488145785283) | |||
| 117495 | 117495 | 104887 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 143 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 118257 | 118257 | 104924 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 801 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 118708 | 118708 | 106159 | Undocumented 2 | Tree(s) :: 17 | 280 DORANTES AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5993249.6 | 2099727.1 | 37.745062774532 | -122.46604762346 | (37.745062774532, -122.46604762346) | |||||
| 119139 | 119139 | 93928 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | 737 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5988857.6 | 2089713.7 | 37.7173141872637 | -122.48050136001899 | (37.7173141872637, -122.480501360019) | |||
| 120101 | 120101 | 97404 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2@Melrose Stanford Heights Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5997807.0 | 2095590.8 | 37.7339673631019 | -122.449990957178 | (37.7339673631019, -122.449990957178) | |||||
| 120486 | 120486 | 104903 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 411 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 121547 | 121547 | 104939 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 109X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | ||||||
| 122291 | 122291 | 104956 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 759 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 124442 | 124442 | 111071 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1908 15TH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5991632.0 | 2102414.0 | 37.7523468518329 | -122.471836728689 | (37.7523468518329, -122.471836728689) | ||||
| 125908 | 125908 | 104941 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 133X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | ||||||
| 126914 | 126914 | 94321 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 501 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/15/2010 12:00:00 AM | Permit Number 53625 | 5987118.0 | 2115378.0 | 37.7876801589176 | -122.488399329426 | (37.7876801589176, -122.488399329426) | |||
| 127763 | 127763 | 106347 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 415 DEWEY BLVD | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5995172.1 | 2100351.0 | 37.7468865723154 | -122.45944518004801 | (37.7468865723154, -122.459445180048) | |||||
| 138275 | 138275 | 104955 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 138278 | 138278 | 104894 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 235 Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | ||||||
| 138326 | 138326 | 95420 | Permitted Site 1 | Tree(s) :: 17 | 263 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/28/2011 12:00:00 AM | Permit Number 767289 | 5986781.4 | 2114160.4 | 37.7843173345373 | -122.48947431767999 | (37.7843173345373, -122.48947431768) | |||
| 138563 | 138563 | 108589 | Significant Tree 6 | Tree(s) :: 17 | 1139x HUDSON AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6017760.0 | 2094672.0 | 37.732566047797704 | -122.38094273978099 | (37.7325660477977, -122.380942739781) | |||||
| 139831 | 139831 | 56597 | Permitted Site 1 | Tree(s) :: 17 | 537 Laidley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6003206.07850285 | 2096083.64373576 | 37.735628059215294 | -122.431359867263 | (37.7356280592153, -122.431359867263) | |||||
| 140139 | 140139 | 104889 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 149 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 142221 | 142221 | 104943 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 830X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | ||||||
| 142415 | 142415 | 104884 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 134 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 142442 | 142442 | 104893 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 233 Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | ||||||
| 143452 | 143452 | 93925 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | 3711 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990297.3 | 2090806.0 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | |||||
| 144026 | 144026 | 104949 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 535 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 144827 | 144827 | 104940 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 111X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | ||||||
| 146250 | 146250 | 104914 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 614 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 3405 | 3405 | 180669 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 171 Winding Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 6ft | 6002170.184219999 | 2086635.71157 | 37.70962739445179 | -122.434266111507 | (37.7096273944518, -122.434266111507) | |||
| 3411 | 3411 | 181033 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 39 Curtis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 4ft | 6000587.53239 | 2088326.47 | 37.71417988317489 | -122.439857163381 | (37.7141798831749, -122.439857163381) | |||
| 3413 | 3413 | 180646 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 451 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 6ft | 6002230.18825 | 2087673.61332 | 37.7124806510226 | -122.434132874236 | (37.7124806510226, -122.434132874236) | |||
| 3430 | 3430 | 180648 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 120 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 6ft | 6001751.26715 | 2087361.8508 | 37.7115974268507 | -122.435765878508 | (37.7115974268507, -122.435765878508) | |||
| 23417 | 23417 | 183167 | Undocumented 2 | :: 54 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.741329561902596 | -122.50344114283101 | (37.7413295619026, -122.503441142831) | |||
| 23724 | 23724 | 181665 | Undocumented 2 | :: 54 | 1275 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985511.3315 | 2106531.7973 | 37.7632971348656 | -122.49330603001499 | (37.7632971348656, -122.493306030015) | |||
| 23777 | 23777 | 183752 | Undocumented 2 | :: 54 | 2287 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987917.4443 | 2099749.9687 | 37.7448165037016 | -122.484486720736 | (37.7448165037016, -122.484486720736) | |||
| 23835 | 23835 | 182329 | Undocumented 2 | :: 54 | 1501 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985565.7361 | 2104954.3084 | 37.75896897093661 | -122.493001657059 | (37.7589689709366, -122.493001657059) | |||
| 23926 | 23926 | 181820 | Undocumented 2 | :: 54 | 2299 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985846.0311 | 2099546.7997 | 37.7441378151504 | -122.491634223287 | (37.7441378151504, -122.491634223287) | |||
| 24053 | 24053 | 181971 | Undocumented 2 | :: 54 | 2467 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985787.1457 | 2098434.4072 | 37.7410800425161 | -122.49175595946801 | (37.7410800425161, -122.491755959468) | |||
| 24081 | 24081 | 183742 | Undocumented 2 | :: 54 | 2278 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988578.8889999995 | 2099828.4885 | 37.745070593746796 | -122.482205348546 | (37.7450705937468, -122.482205348546) | |||
| 24148 | 24148 | 182529 | Undocumented 2 | :: 54 | 1583 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986203.973999999 | 2104470.5925 | 37.7576781250927 | -122.490758769583 | (37.7576781250927, -122.490758769583) | |||
| 24206 | 24206 | 181982 | Undocumented 2 | :: 54 | 2479 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986720.0054 | 2098392.2737 | 37.7410188327151 | -122.488527415956 | (37.7410188327151, -122.488527415956) | |||
| 24275 | 24275 | 184454 | Undocumented 2 | :: 54 | 2153 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981374.6331 | 2100381.1786 | 37.7461664541179 | -122.507156946857 | (37.7461664541179, -122.507156946857) | |||
| 24402 | 24402 | 182453 | Undocumented 2 | :: 54 | 1500 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986555.3586 | 2104541.3333 | 37.7578928802813 | -122.489548755928 | (37.7578928802813, -122.489548755928) | |||
| 24606 | 24606 | 181614 | Undocumented 2 | :: 54 | 1246 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984927.2833 | 2106710.1633 | 37.7637526989564 | -122.49533918573601 | (37.7637526989564, -122.495339185736) | |||
| 24723 | 24723 | 181788 | Undocumented 2 | :: 54 | 3131 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986265.505 | 2098198.358 | 37.740459860841 | -122.49008463083 | (37.740459860841, -122.49008463083) | |||
| 25293 | 25293 | 182679 | Undocumented 2 | :: 54 | 2631 Moraga St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986083.8267 | 2103639.2241 | 37.7553883964845 | -122.49111310108299 | (37.7553883964845, -122.491113101083) | |||
| 25978 | 25978 | 182524 | Undocumented 2 | :: 54 | 1579 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985892.4217 | 2104503.3998 | 37.757750000215005 | -122.491838645138 | (37.757750000215, -122.491838645138) | |||
| 26178 | 26178 | 186047 | Undocumented 2 | :: 54 | 1900 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984778.2299 | 2102058.2647 | 37.7509711496958 | -122.495511585412 | (37.7509711496958, -122.495511585412) | |||
| 26491 | 26491 | 184713 | Undocumented 2 | :: 54 | 1626 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984397.6244 | 2104083.8858 | 37.756510650266705 | -122.496977229466 | (37.7565106502667, -122.496977229466) | |||
| 26507 | 26507 | 184509 | Undocumented 2 | :: 54 | 1886 Lower Great Hwy | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981125.5546 | 2102268.3878 | 37.751333525850896 | -122.50815826243401 | (37.7513335258509, -122.508158262434) | |||
| 26576 | 26576 | 184709 | Undocumented 2 | :: 54 | 1618 40th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983775.4227 | 2104111.6852 | 37.7565504997112 | -122.499131044219 | (37.7565504997112, -122.499131044219) | |||
| 26632 | 26632 | 182608 | Undocumented 2 | :: 54 | 1839 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985333.4224 | 2102688.337 | 37.7527336497539 | -122.493638125681 | (37.7527336497539, -122.493638125681) | |||
| 26723 | 26723 | 183174 | Undocumented 2 | :: 54 | 2400 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984903.1916 | 2098438.8046 | 37.7410404135541 | -122.494812631239 | (37.7410404135541, -122.494812631239) | |||
| 26822 | 26822 | 183837 | Undocumented 2 | :: 54 | 2206 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985462.2045 | 2100160.7045 | 37.745800992601 | -122.4930066047 | (37.745800992601, -122.4930066047) | |||
| 26866 | 26866 | 182267 | Undocumented 2 | :: 54 | 1474 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986846.9486 | 2105227.058 | 37.7597927113016 | -122.48859072822201 | (37.7597927113016, -122.488590728222) | |||
| 26920 | 26920 | 182657 | Undocumented 2 | :: 54 | 2630 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985816.7659 | 2102326.4814 | 37.75176835729211 | -122.491940021962 | (37.7517683572921, -122.491940021962) | |||
| 27047 | 27047 | 181865 | Undocumented 2 | :: 54 | 2331 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986993.7887 | 2099395.3559 | 37.743789001507004 | -122.487654458992 | (37.743789001507, -122.487654458992) | |||
| 27251 | 27251 | 184688 | Undocumented 2 | :: 54 | 1611 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984657.9281 | 2104207.7196 | 37.7568659135367 | -122.496086155975 | (37.7568659135367, -122.496086155975) | |||
| 27390 | 27390 | 183785 | Undocumented 2 | :: 54 | 2146 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986125.7828 | 2099614.0525 | 37.744338818609 | -122.490671864125 | (37.744338818609, -122.490671864125) | |||
| 27474 | 27474 | 183607 | Undocumented 2 | :: 54 | 1 Quintara St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989903.61 | 2101103.2452 | 37.748647706091596 | -122.477717911497 | (37.7486477060916, -122.477717911497) | |||
| 27597 | 27597 | 184102 | Undocumented 2 | :: 54 | 1623 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985904.0693 | 2104173.8569 | 37.7568458469392 | -122.491774103994 | (37.7568458469392, -122.491774103994) | |||
| 27770 | 27770 | 181987 | Undocumented 2 | :: 54 | 2832 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987195.8265 | 2098292.1009 | 37.7407715379119 | -122.486874867312 | (37.7407715379119, -122.486874867312) | |||
| 28244 | 28244 | 184686 | Undocumented 2 | :: 54 | 1606 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984083.9121 | 2104208.225 | 37.7568336628482 | -122.498071323375 | (37.7568336628482, -122.498071323375) | |||
| 28310 | 28310 | 185781 | Undocumented 2 | :: 54 | 2419 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986496.7508 | 2102292.5013 | 37.7517147795652 | -122.489586075955 | (37.7517147795652, -122.489586075955) | |||
| 28315 | 28315 | 182384 | Undocumented 2 | :: 54 | 1539 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985884.4808 | 2104746.0177 | 37.7584156979157 | -122.49188396911 | (37.7584156979157, -122.49188396911) | |||
| 28318 | 28318 | 182661 | Undocumented 2 | :: 54 | 2500 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986241.1388 | 2102339.3676 | 37.7518285352163 | -122.490473451437 | (37.7518285352163, -122.490473451437) | |||
| 28871 | 28871 | 182685 | Undocumented 2 | :: 54 | 1709 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985611.9744 | 2103558.0646 | 37.7551379747053 | -122.492738908785 | (37.7551379747053, -122.492738908785) | |||
| 29215 | 29215 | 182387 | Undocumented 2 | :: 54 | 1534 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984999.5267 | 2104736.7468 | 37.7583384778479 | -122.494943804575 | (37.7583384778479, -122.494943804575) | |||
| 29414 | 29414 | 182531 | Undocumented 2 | :: 54 | 1583 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985892.5986 | 2104472.9119 | 37.7576662991842 | -122.491835788899 | (37.7576662991842, -122.491835788899) | |||
| 29522 | 29522 | 184704 | Undocumented 2 | :: 54 | 1615 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984659.276000001 | 2104181.7734 | 37.756794751430995 | -122.496079580355 | (37.756794751431, -122.496079580355) | |||
| 29939 | 29939 | 184629 | Undocumented 2 | :: 54 | 1646 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983471.6508 | 2103927.0296 | 37.7560256626113 | -122.500167928609 | (37.7560256626113, -122.500167928609) | |||
| 30182 | 30182 | 184584 | Undocumented 2 | :: 54 | 1750 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984424.998 | 2103256.5795 | 37.7542407008981 | -122.496821507327 | (37.7542407008981, -122.496821507327) | |||
| 30188 | 30188 | 182737 | Undocumented 2 | :: 54 | 1751 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985623.647000001 | 2103292.6533 | 37.7544099107452 | -122.492678995508 | (37.7544099107452, -122.492678995508) | |||
| 30846 | 30846 | 182211 | Undocumented 2 | :: 54 | 1591 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985585.3014 | 2104403.0433 | 37.75745649361671 | -122.49289338685 | (37.7574564936167, -122.49289338685) | |||
| 30940 | 30940 | 185841 | Undocumented 2 | :: 54 | 2000 35th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985424.0767 | 2101308.9631 | 37.748951568943205 | -122.493223020907 | (37.7489515689432, -122.493223020907) | |||
| 31109 | 31109 | 184715 | Undocumented 2 | :: 54 | 1631 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984663.3195 | 2104077.315 | 37.7565081745164 | -122.496057890447 | (37.7565081745164, -122.496057890447) | |||
| 31121 | 31121 | 185816 | Undocumented 2 | :: 54 | 2519 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987136.8132 | 2101635.9994 | 37.7499495497007 | -122.487324467521 | (37.7499495497007, -122.487324467521) | |||
| 31188 | 31188 | 181929 | Undocumented 2 | :: 54 | 2427 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985466.1527 | 2098683.3165 | 37.7417447146597 | -122.492884150676 | (37.7417447146597, -122.492884150676) | |||
| 31203 | 31203 | 182476 | Undocumented 2 | :: 54 | 1559 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985886.8002 | 2104622.5113 | 37.7580767189836 | -122.491866855206 | (37.7580767189836, -122.491866855206) | |||
| 31222 | 31222 | 182419 | Undocumented 2 | :: 54 | 1548 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985308.8008 | 2104684.9478 | 37.7582143519431 | -122.493870396795 | (37.7582143519431, -122.493870396795) | |||
| 31225 | 31225 | 184643 | Undocumented 2 | :: 54 | 3324 Moraga St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983935.3115 | 2103621.2359 | 37.7552132408568 | -122.49854187345801 | (37.7552132408568, -122.498541873458) | |||
| 31404 | 31404 | 181902 | Undocumented 2 | :: 54 | 2370 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986740.6492 | 2099140.1859 | 37.7430736050662 | -122.488510993633 | (37.7430736050662, -122.488510993633) | |||
| 31766 | 31766 | 184717 | Undocumented 2 | :: 54 | 1630 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984088.6295 | 2104052.5482 | 37.756406494372705 | -122.498043512944 | (37.7564064943727, -122.498043512944) | |||
| 31770 | 31770 | 183463 | Undocumented 2 | :: 54 | 2530 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988329.4378 | 2098069.925 | 37.740227528416796 | -122.482939034698 | (37.7402275284168, -122.482939034698) | |||
| 31862 | 31862 | 183821 | Undocumented 2 | :: 54 | 2226 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986398.8954 | 2100073.2231 | 37.745615527653996 | -122.48976127310301 | (37.745615527654, -122.489761273103) | |||
| 32086 | 32086 | 182494 | Undocumented 2 | :: 54 | 1589 20th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989920.8647 | 2104571.2003 | 37.758170793630704 | -122.47791173356899 | (37.7581707936307, -122.477911733569) | |||
| 32307 | 32307 | 181866 | Undocumented 2 | :: 54 | 2333 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987926.6484 | 2099416.8457 | 37.7439023721205 | -122.484430466696 | (37.7439023721205, -122.484430466696) | |||
| 32319 | 32319 | 138821 | Undocumented 2 | :: 54 | 745 BUCHANAN ST | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6004449.5065 | 2111116.3546 | 37.776974733592205 | -122.428131826933 | (37.7769747335922, -122.428131826933) | |||
| 32375 | 32375 | 183437 | Undocumented 2 | :: 54 | 2509 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988899.1764 | 2098219.7887 | 37.7406721500335 | -122.480980100642 | (37.7406721500335, -122.480980100642) | |||
| 32403 | 32403 | 182450 | Undocumented 2 | :: 54 | 1566 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988103.6039 | 2104651.3921 | 37.75828533821571 | -122.484202411136 | (37.7582853382157, -122.484202411136) | |||
| 32428 | 32428 | 182575 | Undocumented 2 | :: 54 | 2444 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989239.9887 | 2098703.075 | 37.742018933713105 | -122.479837071242 | (37.7420189337131, -122.479837071242) | |||
| 32483 | 32483 | 182444 | Undocumented 2 | :: 54 | 1530 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985615.2362 | 2104790.3432 | 37.758521662620296 | -122.49281838798099 | (37.7585216626203, -122.492818387981) | |||
| 33122 | 33122 | 185071 | Undocumented 2 | :: 54 | 2800 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984981.8139 | 2096034.5991 | 37.7344437114318 | -122.49436361071899 | (37.7344437114318, -122.494363610719) | |||
| 33144 | 33144 | 182431 | Undocumented 2 | :: 54 | 1550 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985622.7002 | 2104651.6438 | 37.7581412688876 | -122.492782358773 | (37.7581412688876, -122.492782358773) | |||
| 33203 | 33203 | 181890 | Undocumented 2 | :: 54 | 2342 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986735.2344 | 2099299.921 | 37.74351187906971 | -122.488541453894 | (37.7435118790697, -122.488541453894) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");