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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16680 | 16680 | 14970 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 18 | 3x3 | 6016646.28629 | 2097669.62437 | 37.740735388316395 | -122.385001926999 | (37.7407353883164, -122.385001926999) | |||
| 16857 | 16857 | 50824 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47344 | |||||||||
| 16938 | 16938 | 16130 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 339 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 5999827.96036 | 2094635.2259799999 | 37.73145901361271 | -122.442935300848 | (37.7314590136127, -122.442935300848) | |||
| 17040 | 17040 | 12655 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1016 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 6x21 | 5992294.67406 | 2114836.34542 | 37.7864936077921 | -122.47044973930201 | (37.7864936077921, -122.470449739302) | |||
| 17061 | 17061 | 5075 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2518X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002273.67466 | 2097186.93566 | 37.7386045571491 | -122.434662408564 | (37.7386045571491, -122.434662408564) | |||
| 17140 | 17140 | 19179 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 106 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6003475.35494 | 2107644.30442 | 37.767386171248 | -122.431253819727 | (37.767386171248, -122.431253819727) | |||
| 17406 | 17406 | 19187 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 125 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003528.70248 | 2107586.69801 | 37.7672310211182 | -122.43106518602501 | (37.7672310211182, -122.431065186025) | |||
| 17686 | 17686 | 14577 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1135 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 5999374.0888 | 2108906.7208 | 37.7706191740488 | -122.445530268097 | (37.7706191740488, -122.445530268097) | |||
| 17750 | 17750 | 2151 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1107 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001039.9865 | 2095675.11992 | 37.734383349014394 | -122.43881959664101 | (37.7343833490144, -122.438819596641) | |||
| 17961 | 17961 | 9357 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 244 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6000993.28256 | 2098353.57528 | 37.7417351034945 | -122.43917297625099 | (37.7417351034945, -122.439172976251) | |||
| 18094 | 18094 | 16230 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 567 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998330.20149 | 2094661.3287400003 | 37.7314451793547 | -122.44811519437799 | (37.7314451793547, -122.448115194378) | |||
| 18119 | 18119 | 4297 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4348 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001630.45884 | 2100316.0332 | 37.7471597870885 | -122.43711030921301 | (37.7471597870885, -122.437110309213) | |||
| 18275 | 18275 | 5786 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 545 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003176.40068 | 2108310.41756 | 37.769198208965896 | -122.432335439751 | (37.7691982089659, -122.432335439751) | |||
| 18367 | 18367 | 99991 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44594 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | ||||
| 18545 | 18545 | 5094 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2608 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6002249.53771 | 2096620.3889799998 | 37.737047580668296 | -122.434705361078 | (37.7370475806683, -122.434705361078) | |||
| 18608 | 18608 | 24390 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 501X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 6 | 3 | 5991485.44871 | 2094112.7680400002 | 37.7295453093597 | -122.471738611958 | (37.7295453093597, -122.471738611958) | ||
| 18611 | 18611 | 4312 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002294.35545 | 2095730.49773 | 37.73460668843771 | -122.434486797948 | (37.7346066884377, -122.434486797948) | |||
| 18759 | 18759 | 12961 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 62 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6001945.75733 | 2095702.9994599998 | 37.7345113899755 | -122.435690050366 | (37.7345113899755, -122.435690050366) | |||
| 18946 | 18946 | 16174 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 431 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999199.03492 | 2094645.6030400002 | 37.731451629275796 | -122.445110353454 | (37.7314516292758, -122.445110353454) | |||
| 18960 | 18960 | 4321 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X Brompton Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002183.61558 | 2095631.29861 | 37.7343280236114 | -122.43486257064801 | (37.7343280236114, -122.434862570648) | |||
| 19062 | 19062 | 50066 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 406 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46794 | 6003569.14495563 | 2105912.6827965 | 37.7626368713078 | -122.430805824209 | (37.7626368713078, -122.430805824209) | ||
| 19223 | 19223 | 19185 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 113 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6003523.98986 | 2107648.07805 | 37.7673992887615 | -122.431085867714 | (37.7673992887615, -122.431085867714) | |||
| 19233 | 19233 | 5084 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2567 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1994 12:00:00 AM | 12 | 3X3 | 6002282.63151 | 2096922.4202 | 37.7378787673769 | -122.434612531259 | (37.7378787673769, -122.434612531259) | ||
| 19302 | 19302 | 16196 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 487 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 5998881.1124599995 | 2094651.6641 | 37.731450120229795 | -122.446209903265 | (37.7314501202298, -122.446209903265) | |||
| 19502 | 19502 | 27637 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300X Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x4 | 5994586.51749 | 2114934.4548299997 | 37.7868952379175 | -122.462527708701 | (37.7868952379175, -122.462527708701) | |||
| 19512 | 19512 | 16602 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 81 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002869.47017 | 2107840.0194599996 | 37.7678892025435 | -122.433363476353 | (37.7678892025435, -122.433363476353) | |||
| 19556 | 19556 | 99478 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 4 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
| 19598 | 19598 | 16804 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 18 | 4x3 | 6001450.7704065 | 2113227.696464 | 37.7826018222756 | -122.438656679492 | (37.7826018222756, -122.438656679492) | |||
| 19719 | 19719 | 5088 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2586 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6002230.0958 | 2096785.7567599998 | 37.737500538614896 | -122.43478440250401 | (37.7375005386149, -122.434784402504) | |||
| 19730 | 19730 | 12618 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 805 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5992909.32952 | 2114804.6184 | 37.7864420144633 | -122.46832089375499 | (37.7864420144633, -122.468320893755) | |||
| 19844 | 19844 | 27797 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | ||
| 20008 | 20008 | 16236 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 579 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998252.89851 | 2094662.9382599997 | 37.73144517935 | -122.448382560117 | (37.73144517935, -122.448382560117) | |||
| 20226 | 20226 | 5117 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2720 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2002 12:00:00 AM | 8 | 3X3 | 6002348.769730001 | 2096171.20815 | 37.735819866687 | -122.43433016751499 | (37.735819866687, -122.434330167515) | ||
| 20648 | 20648 | 16216 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 527-529 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | Also has partial frontage shared with 535 Monterey Blvd. | 5998570.71989 | 2094653.4436599999 | 37.7314372752037 | -122.447283112845 | (37.7314372752037, -122.447283112845) | ||
| 20733 | 20733 | 4319 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X Brompton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002197.2955 | 2095679.49968 | 37.7344611493668 | -122.434818720617 | (37.7344611493668, -122.434818720617) | |||
| 20759 | 20759 | 4847 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 216 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6006763.29686 | 2097403.25303 | 37.7394523732277 | -122.41915474650801 | (37.7394523732277, -122.419154746508) | |||
| 20834 | 20834 | 16172 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 429 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999224.67853 | 2094646.31985 | 37.7314550611033 | -122.44502175046301 | (37.7314550611033, -122.445021750463) | |||
| 20887 | 20887 | 4296 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4344 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001646.5169400005 | 2100317.5627900003 | 37.747164899748995 | -122.43705489117599 | (37.747164899749, -122.437054891176) | |||
| 20917 | 20917 | 2068 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 825 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001750.47291 | 2095477.80199 | 37.7338819553801 | -122.43634910053999 | (37.7338819553801, -122.43634910054) | |||
| 21048 | 21048 | 5089 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2590 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6002229.15895 | 2096765.16695 | 37.737443950566 | -122.43478616966298 | (37.737443950566, -122.434786169663) | |||
| 21145 | 21145 | 2092 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 943 Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6001450.63808 | 2095555.96116 | 37.7340795211485 | -122.437391313181 | (37.7340795211485, -122.437391313181) | |||
| 21282 | 21282 | 16256 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 625 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997836.72391 | 2094668.86675 | 37.7314376547022 | -122.44982177487302 | (37.7314376547022, -122.449821774873) | |||
| 21497 | 21497 | 9366 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 264 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6001152.801969999 | 2098197.5633099996 | 37.7413158071797 | -122.438610236294 | (37.7413158071797, -122.438610236294) | |||
| 21533 | 21533 | 5767 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 449 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3X3 | 6003822.198969999 | 2108336.65808 | 37.7693068560416 | -122.430103531057 | (37.7693068560416, -122.430103531057) | |||
| 21599 | 21599 | 1993 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 162 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6007301.508909999 | 2098085.20202 | 37.7413551489316 | -122.417342154839 | (37.7413551489316, -122.417342154839) | |||
| 21639 | 21639 | 2248 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 24 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002179.97974 | 2095615.76928 | 37.7342851772073 | -122.434874030709 | (37.7342851772073, -122.434874030709) | |||
| 22017 | 22017 | 5765 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 412 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/1990 12:00:00 AM | 12 | 3X3 | 6003796.50672 | 2108397.52526 | 37.76947252735229 | -122.430196742212 | (37.7694725273523, -122.430196742212) | ||
| 22090 | 22090 | 5789 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 551 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003097.4127 | 2108300.15747 | 37.7691655581641 | -122.43260792171101 | (37.7691655581641, -122.432607921711) | |||
| 22111 | 22111 | 2089 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 943 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001413.27766 | 2095566.23245 | 37.7341055996942 | -122.43752121485399 | (37.7341055996942, -122.437521214854) | |||
| 22189 | 22189 | 24547 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 704 Cortland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X4 | 6007976.32415 | 2097161.8833 | 37.7388578628999 | -122.41494353791501 | (37.7388578628999, -122.414943537915) | |||
| 22218 | 22218 | 24546 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 704 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X4 | 6007961.02706 | 2097162.19636 | 37.7388578629053 | -122.414996450438 | (37.7388578629053, -122.414996450438) | |||
| 23380 | 23380 | 53997 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 437 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 27 | Permit Number 9715 | 6012213.68621 | 2086616.7781099998 | 37.7101403551771 | -122.399552462203 | (37.7101403551771, -122.399552462203) | ||
| 24541 | 24541 | 57383 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1038 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 20 | Permit Number 16222 | 6008178.637569999 | 2116060.00557 | 37.790759089023 | -122.415581676167 | (37.790759089023, -122.415581676167) | ||
| 24663 | 24663 | 8164 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1108 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6002345.91863 | 2111334.94694 | 37.7774556905463 | -122.435424415956 | (37.7774556905463, -122.435424415956) | |||
| 26114 | 26114 | 61073 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2638 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1983 12:00:00 AM | 20 | Permit Number 20909 | 5999566.78827199 | 2113662.02579548 | 37.783687022959995 | -122.44520566105601 | (37.78368702296, -122.445205661056) | |
| 26962 | 26962 | 54655 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 280 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 18 | Permit Number 10479 | 6012382.775359999 | 2087271.8623 | 37.7119485104815 | -122.39901400211201 | (37.7119485104815, -122.399014002112) | ||
| 27174 | 27174 | 24392 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 699X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/21/1995 12:00:00 AM | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
| 29736 | 29736 | 100016 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6011790.6974 | 2117658.0677 | 37.7953493591435 | -122.403196519624 | (37.7953493591435, -122.403196519624) | ||||
| 30547 | 30547 | 54566 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1312 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 3x3 | Permit Number 10364 | 6000274.16247872 | 2109249.10106233 | 37.7716106075543 | -122.44244149612 | (37.7716106075543, -122.44244149612) | ||
| 31575 | 31575 | 54673 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/1972 12:00:00 AM | 24 | 3x5 | Permit Number 10502 | 6012086.572000001 | 2087197.07093 | 37.7117266378561 | -122.40003252207799 | (37.7117266378561, -122.400032522078) | |
| 32415 | 32415 | 11719 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 899X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
| 32763 | 32763 | 68295 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 25 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 17 | Permit Number 32104 | 5991131.604780001 | 2114879.69838 | 37.7865453253482 | -122.47447679418 | (37.7865453253482, -122.47447679418) | |
| 33089 | 33089 | 59113 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 672 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 23 | Permit Number 18417 | 5993196.849359999 | 2110897.8448900003 | 37.7757316778167 | -122.46704201709801 | (37.7757316778167, -122.467042017098) | ||
| 34129 | 34129 | 63191 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 480 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 14 | 4x9 | Permit Number 23731 | 5984103.006630001 | 2112603.98729 | 37.7798871547077 | -122.49862546555599 | (37.7798871547077, -122.498625465556) |
| 35672 | 35672 | 59088 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3426 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 23 | Permit Number 18389 | 5992714.67832 | 2110042.8934299997 | 37.7733563684721 | -122.468647730515 | (37.7733563684721, -122.468647730515) | ||
| 36150 | 36150 | 69365 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3536 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 15 | 4.5x6 | Permit Number 33459 | 6002661.12901 | 2120784.76321 | 37.803420359914796 | -122.435010010914 | (37.8034203599148, -122.435010010914) |
| 37422 | 37422 | 56296 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 153 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1973 12:00:00 AM | 19 | Permit Number 12428 | 5993949.48549 | 2114460.3201 | 37.7855566873358 | -122.464697232751 | (37.7855566873358, -122.464697232751) | ||
| 38847 | 38847 | 51264 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 791 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 11 | Permit Number 47641 | 5991632.45779 | 2110058.1497 | 37.773335681454896 | -122.472392358685 | (37.7733356814549, -122.472392358685) | |
| 39371 | 39371 | 37143 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2155 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Permit Number 39724 | 6003778.522480001 | 2115919.83113 | 37.7901258907459 | -122.430795841768 | (37.7901258907459, -122.430795841768) | |||
| 40493 | 40493 | 53401 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 730 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1969 12:00:00 AM | 19 | Permit Number 6300 | 5990392.09793 | 2110392.4951299997 | 37.774181835613206 | -122.476707321825 | (37.7741818356132, -122.476707321825) | ||
| 40997 | 40997 | 68216 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 371 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 13 | 4x4 | Permit Number 32003 | 5991199.85508 | 2112923.89297 | 37.781179180083704 | -122.474097911754 | (37.7811791800837, -122.474097911754) |
| 43129 | 43129 | 54833 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 18 | Permit Number 10687 | 5982543.3158 | 2111642.14145 | 37.777154613505395 | -122.50394977664 | (37.7771546135054, -122.50394977664) | ||
| 44066 | 44066 | 57393 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1236 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 17 | Permit Number 16232 | 6008083.47781 | 2116740.22221 | 37.792621447386104 | -122.415959115337 | (37.7926214473861, -122.415959115337) | ||
| 44431 | 44431 | 100017 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6011791.69231 | 2117640.10072 | 37.7953000816886 | -122.40319181257799 | (37.7953000816886, -122.403191812578) | ||||
| 44875 | 44875 | 32939 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1419 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 26 | Permit Number 37259 | 6013402.96511 | 2105197.8174 | 37.76122625950521 | -122.39674381646999 | (37.7612262595052, -122.39674381647) | |
| 46418 | 46418 | 53581 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 149 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1970 12:00:00 AM | 20 | Permit Number 6509 | 5993949.30457 | 2114483.86823 | 37.7856213336586 | -122.46469956926599 | (37.7856213336586, -122.464699569266) | ||
| 47243 | 47243 | 59089 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3432 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 18 | 6x10 | Permit Number 18390 | 5992672.34131 | 2110040.7760799997 | 37.7733481090042 | -122.468794024744 | (37.7733481090042, -122.468794024744) | |
| 48061 | 48061 | 53996 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 409 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 33 | Permit Number 9714 | 6012251.58643 | 2086735.6167099997 | 37.7104687749864 | -122.399429808164 | (37.7104687749864, -122.399429808164) | ||
| 49017 | 49017 | 100015 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6011789.640790001 | 2117672.98825 | 37.795390268386 | -122.403201225768 | (37.795390268386, -122.403201225768) | ||||
| 49451 | 49451 | 54596 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 614 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 19 | Permit Number 10419 | 6014083.5952699995 | 2104262.66421 | 37.758696391053206 | -122.394324311034 | (37.7586963910532, -122.394324311034) | ||
| 49454 | 49454 | 34585 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2201 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 19 | Permit Number 38286 | 5999325.9998 | 2116419.19935 | 37.7912437525454 | -122.446237095163 | (37.7912437525454, -122.446237095163) | ||
| 50032 | 50032 | 34999 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 825 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | 14 | 6x10 | Permit Number 43196 | 5999546.79475277 | 2111295.47699927 | 37.7771879487933 | -122.445104637941 | (37.7771879487933, -122.445104637941) |
| 50339 | 50339 | 59126 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 462 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 14 | 6x9 | Permit Number 18431 | 5992526.6588 | 2112295.88073 | 37.779531598558705 | -122.469462142255 | (37.7795315985587, -122.469462142255) | |
| 51115 | 51115 | 99989 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Permit Number 44594 | 6011816.528390001 | 2117490.26365 | 37.794890051993896 | -122.40309533059099 | (37.7948900519939, -122.403095330591) | |||
| 51955 | 51955 | 57553 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1976 12:00:00 AM | 18 | 3x3 | Permit Number 16416 | 6004949.77312 | 2110889.41028 | 37.7763798917414 | -122.426385087108 | (37.7763798917414, -122.426385087108) | |
| 52129 | 52129 | 54126 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 415 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | 16 | Permit Number 9859 | 6012243.80314 | 2086705.1932599999 | 37.7103848043898 | -122.39945457456301 | (37.7103848043898, -122.399454574563) | ||
| 53623 | 53623 | 66064 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 612 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1990 12:00:00 AM | 14 | Permit Number 29104 | 6013245.790080001 | 2104237.6601 | 37.7585811285267 | -122.397220091143 | (37.7585811285267, -122.397220091143) | |
| 55017 | 55017 | 54653 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 274 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 16 | Permit Number 10477 | 6012392.2248 | 2087295.07392 | 37.7120127715543 | -122.39898297010299 | (37.7120127715543, -122.398982970103) | ||
| 55703 | 55703 | 99995 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Permit Number 44594 | 6011799.6511699995 | 2117580.00293 | 37.795135512041995 | -122.403160044009 | (37.795135512042, -122.403160044009) | |||
| 58786 | 58786 | 81639 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 678 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 10 | 3x3 | Permit Number 51574 | 5994125.833 | 2110896.56875 | 37.77578175135179 | -122.463828362424 | (37.7757817513518, -122.463828362424) | |
| 59159 | 59159 | 67885 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 558 Commercial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1993 12:00:00 AM | 11 | 4x4 | Permit Number 31579 | 6012000.40021 | 2117278.49262 | 37.794318845792105 | -122.40244420615299 | (37.7943188457921, -122.402444206153) | |
| 59209 | 59209 | 33675 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 469 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 13 | Permit Number 37757 | 6005116.23557125 | 2111084.96150687 | 37.7769262359606 | -122.425823168919 | (37.7769262359606, -122.425823168919) | |
| 59351 | 59351 | 126283 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1442 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6006684.03658 | 2118052.67265 | 37.796146330239 | -122.42089446522101 | (37.796146330239, -122.420894465221) | |||
| 60605 | 60605 | 51265 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 791 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 14 | Permit Number 47641 | 5991632.71365 | 2110039.2533299997 | 37.7732838119525 | -122.472390095818 | (37.7732838119525, -122.472390095818) | |
| 63415 | 63415 | 33467 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 72 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37623 | 6006783.56593714 | 2099291.50343979 | 37.744638227793395 | -122.419218573599 | (37.7446382277934, -122.419218573599) | ||
| 64605 | 64605 | 98705 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1050 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2012 12:00:00 AM | 10 | 3x3 | Permit Number 768656 | 6007880.11955 | 2092984.0697400002 | 37.7273810881671 | -122.414980548629 | (37.7273810881671, -122.414980548629) | |
| 65606 | 65606 | 58791 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 505 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1992 12:00:00 AM | 15 | Permit Number 30381 | 6012232.54216 | 2117604.48195 | 37.7952268912538 | -122.40166388690099 | (37.7952268912538, -122.401663886901) | ||
| 66741 | 66741 | 50805 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1498 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2004 12:00:00 AM | Permit Number 47329 | 6000596.76427703 | 2111027.41746177 | 37.7765117981927 | -122.441453229456 | (37.7765117981927, -122.441453229456) | |||
| 67931 | 67931 | 32978 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 29 | Permit Number 37291 | 6014355.15854 | 2104463.2818299998 | 37.759262335300996 | -122.39339915324601 | (37.759262335301, -122.393399153246) | |
| 68692 | 68692 | 59156 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 724 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1980 12:00:00 AM | 21 | Permit Number 18465 | 5993208.37426 | 2110527.44532 | 37.7747153253036 | -122.466975215661 | (37.7747153253036, -122.466975215661) |
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");