Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH, PlotSize
qLegalStatus ✖
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1994 | 1994 | 42166 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 354 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011846.02554 | 2111882.36991 | 37.77949374398221 | -122.402598720465 | (37.7794937439822, -122.402598720465) | ||
| 2014 | 2014 | 42165 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 354 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011856.41574 | 2111871.95313 | 37.7794657219919 | -122.40256204342501 | (37.7794657219919, -122.402562043425) | ||
| 10100 | 10100 | 42164 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 360 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42459 | 6011853.6 | 2111898.2 | 37.779537632618705 | -122.40257363052 | (37.7795376326187, -122.40257363052) | |||
| 13340 | 13340 | 42050 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 405 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | ||
| 13342 | 13342 | 42051 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 405 Duncan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | ||
| 13346 | 13346 | 42052 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 405 Duncan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | ||
| 13351 | 13351 | 42049 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 405 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | ||
| 13538 | 13538 | 42043 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 15904 | 15904 | 42044 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16322 | 16322 | 42042 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16500 | 16500 | 42041 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 18072 | 18072 | 42004 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 240 Manor Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | ||
| 24451 | 24451 | 42139 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 583 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 5 | Permit Number 42434 | 5991253.848730001 | 2111457.82315 | 37.7771568827635 | -122.4738041366 | (37.7771568827635, -122.4738041366) | |
| 24667 | 24667 | 41967 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 660 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42320 | 5993546.32610667 | 2094692.15978902 | 37.731255200572 | -122.464656063289 | (37.731255200572, -122.464656063289) | ||
| 25197 | 25197 | 42152 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 622 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 5 | Permit Number 42447 | 5989745.16846 | 2111083.69562 | 37.7760421357171 | -122.47899570903401 | (37.7760421357171, -122.478995709034) | |
| 27907 | 27907 | 42155 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 519 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 5 | Permit Number 42450 | 5989365.15047 | 2111778.31526 | 37.7779272929593 | -122.480361131189 | (37.7779272929593, -122.480361131189) | |
| 39609 | 39609 | 42172 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 11 | Permit Number 42460 | 6012593.26461 | 2111204.07737 | 37.7776729981365 | -122.399966040597 | (37.7776729981365, -122.399966040597) | ||
| 40418 | 40418 | 42151 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 554 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 7 | Permit Number 42446 | 5989728.75072 | 2111581.12126 | 37.7774069754215 | -122.47908889577499 | (37.7774069754215, -122.479088895775) | |
| 42447 | 42447 | 42181 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 649 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 4 | Permit Number 42465 | 6012754.97243 | 2111452.86272 | 37.778365119997204 | -122.399424104664 | (37.7783651199972, -122.399424104664) | |
| 43332 | 43332 | 41969 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 700 Darien Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42321 | 5993590.54370591 | 2094553.01083875 | 37.73087568091729 | -122.464493096634 | (37.7308756809173, -122.464493096634) | ||
| 46446 | 46446 | 42145 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 474 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 6 | Permit Number 42440 | 5990638.82894 | 2112162.53163 | 37.7790561777006 | -122.475983142258 | (37.7790561777006, -122.475983142258) | |
| 48381 | 48381 | 42133 | Permitted Site 1 | Tree(s) :: 17 | 69 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42429 | 6003074.74673035 | 2107378.43779911 | 37.7666334554934 | -122.43262047379 | (37.7666334554934, -122.43262047379) | |||
| 49127 | 49127 | 40957 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 735 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 7 | Permit Number 42441 | 5990344.94056 | 2110364.54527 | 37.7741023575346 | -122.476868403223 | (37.7741023575346, -122.476868403223) | |
| 49603 | 49603 | 42126 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 54 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42422 | 5999645.50083885 | 2093804.90397788 | 37.729168738667795 | -122.44350647351001 | (37.7291687386678, -122.44350647351) | ||
| 53786 | 53786 | 33351 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 156 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42327 | 5994316.91365045 | 2093552.57844974 | 37.7281705833725 | -122.461909418866 | (37.7281705833725, -122.461909418866) | ||
| 54822 | 54822 | 42146 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 739 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 6 | Permit Number 42442 | 5990347.5181 | 2110325.21419 | 37.7739945146903 | -122.476856612826 | (37.7739945146903, -122.476856612826) | |
| 54939 | 54939 | 42167 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 14 | Permit Number 42460 | 6012577.4664 | 2111216.9324 | 37.7777074143023 | -122.400021595319 | (37.7777074143023, -122.400021595319) | ||
| 58956 | 58956 | 42053 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 470 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42368 | 6003495.60283243 | 2099833.79882234 | 37.7459415266501 | -122.43062638702601 | (37.7459415266501, -122.430626387026) | ||
| 60096 | 60096 | 42173 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 466 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 11 | Permit Number 42461 | 6010347.47254 | 2109513.35928 | 37.7729052153318 | -122.407615799844 | (37.7729052153318, -122.407615799844) | |
| 60642 | 60642 | 42138 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 579 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 8 | Permit Number 42433 | 5991254.316269999 | 2111466.88915 | 37.7771818025968 | -122.473803180798 | (37.7771818025968, -122.473803180798) | |
| 73063 | 73063 | 42026 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 49 Rausch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 6 | Permit Number 42349 | 6009754.59547 | 2110863.5181299997 | 37.776579230974 | -122.409761960854 | (37.776579230974, -122.409761960854) | |
| 74137 | 74137 | 42144 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 471 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 10 | Permit Number 42439 | 5990590.8617 | 2112190.82997 | 37.7791310957428 | -122.476151146082 | (37.7791310957428, -122.476151146082) | |
| 77927 | 77927 | 42102 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 324 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42408 | 5997476.85720986 | 2094482.06690448 | 37.7309041502726 | -122.45105243040301 | (37.7309041502726, -122.451052430403) | ||
| 78216 | 78216 | 41994 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 80 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42334 | 5993638.39101115 | 2093445.81341471 | 37.727838346667795 | -122.464247330355 | (37.7278383466678, -122.464247330355) | ||
| 78298 | 78298 | 42118 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 270 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42415 | 5999640.33220805 | 2095259.39939734 | 37.733162148555 | -122.443628787399 | (37.733162148555, -122.443628787399) | ||
| 78530 | 78530 | 42106 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 305 Hearst Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42409 | 5999382.77994639 | 2094344.80390055 | 37.730636191213996 | -122.444453504412 | (37.730636191214, -122.444453504412) | ||
| 79448 | 79448 | 42039 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 186 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42359 | 6004732.95354078 | 2098732.8034677 | 37.742988466771 | -122.42626942175899 | (37.742988466771, -122.426269421759) | ||
| 79509 | 79509 | 42070 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 175 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42382 | 6006689.9789182 | 2098613.42451698 | 37.7427711044259 | -122.419494082241 | (37.7427711044259, -122.419494082241) | ||
| 79959 | 79959 | 42068 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100X Ripley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 8 | 3x3 | Permit Number 42381 | 6015269.0 | 2115673.0 | 37.790092461076604 | -122.39102211089701 | (37.7900924610766, -122.391022110897) |
| 80492 | 80492 | 42122 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 466 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42419 | 5997198.29224206 | 2095567.6456229 | 37.7338689373859 | -122.45209376562799 | (37.7338689373859, -122.452093765628) | ||
| 81233 | 81233 | 42014 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 52 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42342 | 5993349.78365955 | 2093339.35918031 | 37.7275294102383 | -122.46523731491199 | (37.7275294102383, -122.465237314912) | ||
| 81404 | 81404 | 42003 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 240 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | ||
| 82892 | 82892 | 42008 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 240 Manor Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | ||
| 83351 | 83351 | 33354 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 168 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42328 | 5994249.16422919 | 2093532.93310922 | 37.728112741470106 | -122.462142205261 | (37.7281127414701, -122.462142205261) | ||
| 83688 | 83688 | 42111 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 84120 | 84120 | 42175 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 468 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42462 | 6009925.08941952 | 2109046.40040251 | 37.7715994018396 | -122.409043924996 | (37.7715994018396, -122.409043924996) | ||
| 84382 | 84382 | 41977 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 895 DARIEN WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 3x3 | Permit Number 42322 | 5994361.7 | 2093982.2 | 37.72935279772889 | -122.461785730278 | (37.7293527977289, -122.461785730278) | |
| 84960 | 84960 | 42029 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 65 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42351 | 5994340.62872168 | 2093722.8989966 | 37.728639607369 | -122.461839780515 | (37.728639607369, -122.461839780515) | ||
| 85311 | 85311 | 42056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1604 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42370 | 6003957.6315271 | 2098925.27946959 | 37.7434731064371 | -122.428963992715 | (37.7434731064371, -122.428963992715) | ||
| 85432 | 85432 | 42119 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 522 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42416 | 5997964.26201439 | 2095285.33494323 | 37.73313762619021 | -122.449425254756 | (37.7331376261902, -122.449425254756) | ||
| 86009 | 86009 | 33359 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 245 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42329 | 5993873.30755046 | 2093527.06719529 | 37.7280749872139 | -122.463441119172 | (37.7280749872139, -122.463441119172) | ||
| 86693 | 86693 | 42025 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 171 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42348 | 5993627.24240997 | 2093940.95109531 | 37.72919723077929 | -122.464321804087 | (37.7291972307793, -122.464321804087) | ||
| 86963 | 86963 | 42085 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 110 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42394 | 6008601.9576373 | 2099058.44046142 | 37.7441005280097 | -122.412914436371 | (37.7441005280097, -122.412914436371) | ||
| 87620 | 87620 | 42082 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 301 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42392 | 6008452.52473671 | 2100207.10363126 | 37.747246112868794 | -122.413512366427 | (37.7472461128688, -122.413512366427) | ||
| 87730 | 87730 | 42005 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 240 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | ||
| 87930 | 87930 | 42086 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1420 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42395 | 6007983.09301481 | 2099771.54386954 | 37.7460237932697 | -122.41510480513399 | (37.7460237932697, -122.415104805134) | ||
| 87967 | 87967 | 41995 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 80 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42334 | 5993638.39101115 | 2093445.81341471 | 37.727838346667795 | -122.464247330355 | (37.7278383466678, -122.464247330355) | ||
| 88628 | 88628 | 42066 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 94 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42378 | 6007297.03712767 | 2098828.5050365003 | 37.7433958417804 | -122.41741028115601 | (37.7433958417804, -122.417410281156) | ||
| 88633 | 88633 | 42190 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 975 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.40622367699301 | (37.7730141185867, -122.406223676993) | ||
| 88941 | 88941 | 42024 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 135 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42347 | 5993558.09176508 | 2093797.91990476 | 37.72880051608529 | -122.464550480382 | (37.7288005160853, -122.464550480382) | ||
| 89344 | 89344 | 41974 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42321 | 5993590.54370591 | 2094553.01083875 | 37.73087568091729 | -122.464493096634 | (37.7308756809173, -122.464493096634) | ||
| 89644 | 89644 | 42057 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1604 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42370 | 6003957.6315271 | 2098925.27946959 | 37.7434731064371 | -122.428963992715 | (37.7434731064371, -122.428963992715) | ||
| 90296 | 90296 | 42178 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 540 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42463 | 6010231.08590939 | 2108722.60367253 | 37.770727467539295 | -122.40796262268299 | (37.7707274675393, -122.407962622683) | |||
| 90368 | 90368 | 42058 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1644 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42371 | 6003970.3796312995 | 2098696.48598214 | 37.7428456137574 | -122.42890360490499 | (37.7428456137574, -122.428903604905) | |||
| 90752 | 90752 | 33378 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 2 Northgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42339 | 5994377.61807739 | 2093748.96213411 | 37.728713299737 | -122.461713796033 | (37.728713299737, -122.461713796033) | ||
| 90886 | 90886 | 42110 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100@ Detroit Judson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 92361 | 92361 | 67754 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1644 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42371 | 6003970.3796312995 | 2098696.48598214 | 37.7428456137574 | -122.42890360490499 | (37.7428456137574, -122.428903604905) | ||
| 92416 | 92416 | 42186 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 975 Bryant St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.40622367699301 | (37.7730141185867, -122.406223676993) | ||
| 92662 | 92662 | 41999 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 130 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42336 | 5993772.38783122 | 2093685.79470402 | 37.7285049990899 | -122.463801515353 | (37.7285049990899, -122.463801515353) | ||
| 92679 | 92679 | 42192 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 979 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42469 | 6010727.99251849 | 2109523.22808117 | 37.7729536057439 | -122.406300225016 | (37.7729536057439, -122.406300225016) | ||
| 92843 | 92843 | 41966 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 660 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42320 | 5993546.32610667 | 2094692.15978902 | 37.731255200572 | -122.464656063289 | (37.731255200572, -122.464656063289) | ||
| 93188 | 93188 | 40860 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 32 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42377 | 6007537.55147065 | 2099272.41006031 | 37.744628235414204 | -122.416610080854 | (37.7446282354142, -122.416610080854) | ||
| 93965 | 93965 | 42104 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 305 Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42409 | 5999382.77994639 | 2094344.80390055 | 37.730636191213996 | -122.444453504412 | (37.730636191214, -122.444453504412) | ||
| 94288 | 94288 | 42125 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 474 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42421 | 5997171.36718465 | 2095568.06043291 | 37.7338685339915 | -122.452186883121 | (37.7338685339915, -122.452186883121) | ||
| 94467 | 94467 | 42095 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 45 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42400 | 6008105.01217426 | 2099392.98476779 | 37.744991204982 | -122.414656438734 | (37.744991204982, -122.414656438734) | |||
| 94744 | 94744 | 42040 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 345 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42360 | 6003709.400251 | 2098624.3505206 | 37.74263277107121 | -122.429800854173 | (37.7426327710712, -122.429800854173) | ||
| 94877 | 94877 | 42090 | Permitted Site 1 | :: 54 | 25 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42397 | 6008240.69863747 | 2099401.70748619 | 37.7450227780609 | -122.414187874949 | (37.7450227780609, -122.414187874949) | ||
| 95079 | 95079 | 42123 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 473 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42420 | 5997186.22664229 | 2095515.825336 | 37.7337259601641 | -122.452131742169 | (37.7337259601641, -122.452131742169) | ||
| 95424 | 95424 | 42113 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 136 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42412 | 5999169.44681663 | 2093518.27568943 | 37.7283545633122 | -122.445131627679 | (37.7283545633122, -122.445131627679) | ||
| 95622 | 95622 | 38422 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1542 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | ||
| 95849 | 95849 | 42074 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Montezuma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42386 | 6007407.21852601 | 2099717.8399438 | 37.745843955191 | -122.417092303307 | (37.745843955191, -122.417092303307) | ||
| 95957 | 95957 | 42128 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 62 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42424 | 5999607.24235334 | 2093805.46920105 | 37.7291681086723 | -122.443638776439 | (37.7291681086723, -122.443638776439) | ||
| 96256 | 96256 | 41990 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 42 Keystone Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42331 | 5994132.67284908 | 2092973.44632189 | 37.7265698190565 | -122.46250435133301 | (37.7265698190565, -122.462504351333) | ||
| 96300 | 96300 | 42017 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 95 Pinehurst Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42344 | 5993454.75406454 | 2093611.71639617 | 37.728283289236 | -122.46489420553999 | (37.728283289236, -122.46489420554) | ||
| 97177 | 97177 | 42163 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4630 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42458 | 5989047.18920071 | 2109907.45432155 | 37.7727719459225 | -122.48132401917401 | (37.7727719459225, -122.481324019174) | ||
| 97190 | 97190 | 41962 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 640 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42318 | 5993511.89759083 | 2094752.0237459 | 37.731417587340005 | -122.46477943358101 | (37.73141758734, -122.464779433581) | |||
| 97822 | 97822 | 42006 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 240 Manor Dr | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | ||
| 97986 | 97986 | 42096 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1536 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42401 | 6008711.739543499 | 2099881.1132478 | 37.7463655671811 | -122.412592977201 | (37.7463655671811, -122.412592977201) | ||
| 98612 | 98612 | 42132 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 171 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42428 | 5998957.22367334 | 2093763.17021168 | 37.729014870842 | -122.445882895755 | (37.729014870842, -122.445882895755) | ||
| 98840 | 98840 | 42078 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 Norwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | ||
| 99497 | 99497 | 42185 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 975 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.40622367699301 | (37.7730141185867, -122.406223676993) | ||
| 99834 | 99834 | 40859 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1670 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42380 | 6009721.65724328 | 2100087.27684169 | 37.746988275084895 | -122.409115329349 | (37.7469882750849, -122.409115329349) | ||
| 100062 | 100062 | 42062 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1726 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42373 | 6009298.2802895 | 2099318.00641811 | 37.74485230089571 | -122.41052502294599 | (37.7448523008957, -122.410525022946) | ||
| 100185 | 100185 | 41991 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 42 Keystone Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42331 | 5994132.67284908 | 2092973.44632189 | 37.7265698190565 | -122.46250435133301 | (37.7265698190565, -122.462504351333) | ||
| 100362 | 100362 | 42081 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 254 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42391 | 6008092.42384606 | 2100220.76756697 | 37.7472634047037 | -122.41475853876999 | (37.7472634047037, -122.41475853877) | ||
| 100373 | 100373 | 37439 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42376 | 6007699.64971821 | 2099462.43084291 | 37.7451591053054 | -122.416063030013 | (37.7451591053054, -122.416063030013) | ||
| 100837 | 100837 | 42191 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 975 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.40622367699301 | (37.7730141185867, -122.406223676993) | ||
| 101054 | 101054 | 42002 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 240 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | ||
| 101210 | 101210 | 42019 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42345 | 5993530.78029049 | 2093639.27854134 | 37.7283633513404 | -122.46463338232799 | (37.7283633513404, -122.464633382328) | |||
| 101840 | 101840 | 42038 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42358 | 6004596.89230657 | 2098983.86286022 | 37.7436701266667 | -122.42675775960501 | (37.7436701266667, -122.426757759605) |
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");