Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187028 | 187028 | 176511 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 127 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6006104.31545 | 2087436.5206900002 | 37.712048761508605 | -122.42072585491199 | (37.7120487615086, -122.420725854912) | |||
| 186907 | 186907 | 176505 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 178 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005616.04698 | 2087112.6870400002 | 37.7111320510829 | -122.42239045867599 | (37.7111320510829, -122.422390458676) | |||
| 186722 | 186722 | 142687 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 550 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008655.2673 | 2121104.5109 | 37.804636831606494 | -122.414289624157 | (37.8046368316065, -122.414289624157) | |||
| 186358 | 186358 | 128869 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6001642.59008 | 2116017.92803 | 37.7902739929064 | -122.438193013824 | (37.7902739929064, -122.438193013824) | |||
| 186176 | 186176 | 141447 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 196 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5996894.8261 | 2111600.0306 | 37.7778724506652 | -122.454300593509 | (37.7778724506652, -122.454300593509) | |||
| 186145 | 186145 | 81695 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 539 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52514 | 5990609.143069999 | 2111709.86868 | 37.7778115687685 | -122.476052767078 | (37.7778115687685, -122.476052767078) | |
| 185820 | 185820 | 219006 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 221 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995326.9231199995 | 2091423.0850799999 | 37.7223816004164 | -122.458263736089 | (37.7223816004164, -122.458263736089) | |||
| 185706 | 185706 | 67574 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 601 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 13 | Permit Number 31129 | 6013300.57075 | 2104280.61777 | 37.7587021305084 | -122.397033645504 | (37.7587021305084, -122.397033645504) | |
| 185667 | 185667 | 70154 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 339 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1993 12:00:00 AM | 9 | 5992446.53753 | 2113177.4125 | 37.7819474134806 | -122.469803511026 | (37.7819474134806, -122.469803511026) | ||
| 185659 | 185659 | 245457 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6007865.341 | 2106811.8898 | 37.7653483594859 | -122.41601046611099 | (37.7653483594859, -122.416010466111) | |||
| 185415 | 185415 | 246444 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 467 Duncan St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6003499.43256 | 2099785.6606799997 | 37.7458095674622 | -122.430609709989 | (37.7458095674622, -122.430609709989) | |||
| 184565 | 184565 | 192415 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1400 20th St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013731.20085 | 2104795.9240599996 | 37.760141011629706 | -122.39558042201 | (37.7601410116297, -122.39558042201) | |||
| 184487 | 184487 | 247270 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1520 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999196.9373 | 2109093.7955 | 37.7711227186713 | -122.446156493551 | (37.7711227186713, -122.446156493551) | |||
| 184254 | 184254 | 225897 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2770 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6009476.04285 | 2103963.05006 | 37.7576165210915 | -122.410238245413 | (37.7576165210915, -122.410238245413) | |||
| 184026 | 184026 | 225978 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 737 Sanchez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6003705.65415 | 2103955.3434599997 | 37.757270218256394 | -122.430194042444 | (37.7572702182564, -122.430194042444) | |||
| 183815 | 183815 | 51725 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1904 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2005 12:00:00 AM | 6 | Permit Number 48537 | 6012320.61849 | 2104715.4197400003 | 37.7598414015724 | -122.40045333106701 | (37.7598414015724, -122.400453331067) | ||
| 183419 | 183419 | 128864 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 628 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004541.11924 | 2110775.90598 | 37.7760451281037 | -122.42779064652599 | (37.7760451281037, -122.427790646526) | |||
| 182998 | 182998 | 128875 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1237x Robert C Levy Tunl | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6007636.05536 | 2118136.6748900004 | 37.7964305951503 | -122.417606237154 | (37.7964305951503, -122.417606237154) | ||||
| 182056 | 182056 | 225942 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2741 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008447.4960199995 | 2106788.1378099998 | 37.7653158554543 | -122.413995240611 | (37.7653158554543, -122.413995240611) | |||
| 181764 | 181764 | 219002 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1333 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5992990.51198 | 2106402.84909 | 37.7633777040321 | -122.46742884668501 | (37.7633777040321, -122.467428846685) | |||
| 181544 | 181544 | 225967 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3599 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005877.128169999 | 2101963.64024 | 37.7519242145407 | -122.42254270219601 | (37.7519242145407, -122.422542702196) | |||
| 181461 | 181461 | 128870 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6001597.99168 | 2116010.93406 | 37.790252252691495 | -122.43834681946501 | (37.7902522526915, -122.438346819465) | |||
| 181455 | 181455 | 142338 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 510 Central Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5999738.5075 | 2110257.1017 | 37.7743477755014 | -122.444366803816 | (37.7743477755014, -122.444366803816) | |||
| 181377 | 181377 | 32926 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1530 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 9 | Permit Number 37252 | 6012714.10584 | 2106606.08517 | 37.765054686045 | -122.399225162022 | (37.765054686045, -122.399225162022) | |
| 181307 | 181307 | 225907 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3749 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6005583.06138 | 2101365.98068 | 37.7502665850353 | -122.42351714192499 | (37.7502665850353, -122.423517141925) | |||
| 181038 | 181038 | 176508 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 150 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | Width 6ft | 6005731.293880001 | 2087351.0784200002 | 37.71179312382829 | -122.422009060692 | (37.7117931238283, -122.422009060692) | |||
| 180600 | 180600 | 128868 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001720.521000001 | 2116028.9102 | 37.790308579028 | -122.43792416596202 | (37.790308579028, -122.437924165962) | |||
| 180046 | 180046 | 73919 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 179 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1995 12:00:00 AM | 11 | 6007979.779619999 | 2109750.0679099998 | 37.77342234081 | -122.415822718756 | (37.77342234081, -122.415822718756) | ||
| 179575 | 179575 | 49771 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 1 | Permit Number 46559 | 6008634.11039 | 2086335.4029299999 | 37.70916757830379 | -122.411904362692 | (37.7091675783038, -122.411904362692) | |
| 179065 | 179065 | 176512 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006244.01324 | 2087410.04073 | 37.711983925792 | -122.42024114011801 | (37.711983925792, -122.420241140118) | |||
| 178781 | 178781 | 225940 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 183 Bartlett St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006723.95695 | 2102704.663 | 37.7540066307184 | -122.419666814188 | (37.7540066307184, -122.419666814188) | |||
| 178778 | 178778 | 225914 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 611 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009855.21876 | 2105398.0408099997 | 37.7615779286091 | -122.409028144648 | (37.7615779286091, -122.409028144648) | |||
| 178517 | 178517 | 225923 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1523 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009609.76682 | 2100372.8440799997 | 37.7477661109153 | -122.409522389545 | (37.7477661109153, -122.409522389545) | |||
| 178516 | 178516 | 142724 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008368.8817 | 2121063.6546 | 37.804508559383706 | -122.41527779826299 | (37.8045085593837, -122.415277798263) | |||
| 178195 | 178195 | 59936 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1757 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 14 | Permit Number 19409 | 5999437.2024 | 2110127.1563 | 37.773973782951295 | -122.44539972496 | (37.7739737829513, -122.44539972496) | |
| 177519 | 177519 | 225979 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 171 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003500.9012 | 2108793.5344 | 37.7705431243846 | -122.431247500167 | (37.7705431243846, -122.431247500167) | |||
| 177304 | 177304 | 176507 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 150 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | Width 6ft | 6005719.71054 | 2087314.8851 | 37.7116930913392 | -122.422046526423 | (37.7116930913392, -122.422046526423) | |||
| 176344 | 176344 | 142206 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1693 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999789.089 | 2110173.0386 | 37.7741198453954 | -122.444185791724 | (37.7741198453954, -122.444185791724) | |||
| 175971 | 175971 | 225905 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3620 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006092.03845 | 2100850.85024 | 37.7488808700704 | -122.421720479039 | (37.7488808700704, -122.421720479039) | |||
| 175010 | 175010 | 244548 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1500 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999285.3779 | 2109104.904 | 37.7711582700312 | -122.44585137455499 | (37.7711582700312, -122.445851374555) | |||
| 174957 | 174957 | 72137 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1445 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1990 12:00:00 AM | 10 | 6013608.91395 | 2104739.63414 | 37.759979648971296 | -122.395999412568 | (37.7599796489713, -122.395999412568) | ||
| 174678 | 174678 | 128878 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2507 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006675.76572 | 2119877.35226 | 37.8011559740396 | -122.421052707221 | (37.8011559740396, -122.421052707221) | |||
| 173505 | 173505 | 142723 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008387.4711 | 2121064.7168 | 37.8045125206489 | -122.415213542996 | (37.8045125206489, -122.415213542996) | |||
| 173461 | 173461 | 192419 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 5ft | 6013725.780809999 | 2104155.14731 | 37.7583812766799 | -122.39555427333299 | (37.7583812766799, -122.395554273333) | |||
| 172811 | 172811 | 219015 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 178 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995362.975 | 2091073.5801900001 | 37.7214240148917 | -122.458113831693 | (37.7214240148917, -122.458113831693) | |||
| 171695 | 171695 | 176519 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1501 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6007411.664 | 2087356.69589 | 37.7119031774593 | -122.416201620236 | (37.7119031774593, -122.416201620236) | |||
| 171362 | 171362 | 192424 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 80 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6012214.215580001 | 2107593.00345 | 37.767736670334 | -122.40102351921401 | (37.767736670334, -122.401023519214) | |||
| 170940 | 170940 | 225941 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2741 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008479.57157 | 2106789.99356 | 37.7653227523561 | -122.41388442972799 | (37.7653227523561, -122.413884429728) | |||
| 170862 | 170862 | 142691 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2410 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008523.0158 | 2121086.8394 | 37.804580880348794 | -122.414746043331 | (37.8045808803488, -122.414746043331) | |||
| 170051 | 170051 | 32624 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 39 Boardman Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 7 | Permit Number 37079 | 6011697.70075 | 2110139.81067 | 37.7747007963356 | -122.402989243876 | (37.7747007963356, -122.402989243876) | |
| 169492 | 169492 | 122086 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 459 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990589.9425800005 | 2112248.5519999997 | 37.7792895311955 | -122.47615854280599 | (37.7792895311955, -122.476158542806) | |||
| 169474 | 169474 | 176504 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 178 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6005618.83947 | 2087124.32667 | 37.711164168567 | -122.422381633625 | (37.711164168567, -122.422381633625) | |||
| 169326 | 169326 | 128865 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001864.710469999 | 2116045.7184900003 | 37.7903629286659 | -122.437426485651 | (37.7903629286659, -122.437426485651) | |||
| 169108 | 169108 | 225946 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3557 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005893.76776 | 2102550.85426 | 37.7535375074585 | -122.422526882211 | (37.7535375074585, -122.422526882211) | |||
| 168988 | 168988 | 192423 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 80 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6012208.345290001 | 2107668.53767 | 37.76794374283679 | -122.401049131921 | (37.7679437428368, -122.401049131921) | |||
| 168685 | 168685 | 192421 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 53 Pomona St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6014148.288919999 | 2094395.14028 | 37.731605838737295 | -122.39341002514799 | (37.7316058387373, -122.393410025148) | |||
| 167999 | 167999 | 142232 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 600 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004552.0651 | 2110734.2793 | 37.775931450627205 | -122.427749815271 | (37.7759314506272, -122.427749815271) | |||
| 167039 | 167039 | 140156 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2155 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997581.2766 | 2109865.28 | 37.7731486172497 | -122.451800756951 | (37.7731486172497, -122.451800756951) | |||
| 167018 | 167018 | 225971 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3446 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006565.68979 | 2104973.1411599996 | 37.7602264301236 | -122.420375142719 | (37.7602264301236, -122.420375142719) | |||
| 166957 | 166957 | 225920 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 300 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009736.52173 | 2099618.93286 | 37.74570313810779 | -122.409030888471 | (37.7457031381078, -122.409030888471) | |||
| 166491 | 166491 | 32275 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 11 | 6x6 | Permit Number 36861 | 6014077.35334 | 2105478.23544 | 37.762033738282106 | -122.39443101198401 | (37.7620337382821, -122.394431011984) | |
| 164420 | 164420 | 225929 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 56 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008145.90084 | 2098385.005 | 37.742225813165895 | -122.414443742389 | (37.7422258131659, -122.414443742389) | |||
| 164012 | 164012 | 128873 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1270 Clay St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6008597.37413 | 2116983.75832 | 37.7933190163979 | -122.414198247271 | (37.7933190163979, -122.414198247271) | |||
| 163531 | 163531 | 128879 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1 Balance St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6012011.137630001 | 2118129.24016 | 37.796655394198204 | -122.40246690323099 | (37.7966553941982, -122.402466903231) | |||
| 163455 | 163455 | 82278 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 245 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50610 | 5992733.47806 | 2113805.1753 | 37.783687659814795 | -122.46885653402398 | (37.7836876598148, -122.468856534024) | |
| 163367 | 163367 | 225953 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003670.68661 | 2095891.30011 | 37.735126247484104 | -122.42973982455901 | (37.7351262474841, -122.429739824559) | |||
| 163115 | 163115 | 112711 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 782 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 1 | 6009126.82605 | 2110111.36785 | 37.774478803191 | -122.411880442527 | (37.774478803191, -122.411880442527) | ||
| 162995 | 162995 | 79749 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 615 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 9 | 6015454.74686 | 2106112.32495 | 37.7638512843329 | -122.38971139058799 | (37.7638512843329, -122.389711390588) | ||
| 162647 | 162647 | 47473 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2713 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45374 | 6001758.37714 | 2115982.9514900004 | 37.790184540925395 | -122.43778989361601 | (37.7901845409254, -122.437789893616) | |
| 162031 | 162031 | 225916 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005165.83624 | 2104308.70302 | 37.758323056384796 | -122.425169300823 | (37.7583230563848, -122.425169300823) | |||
| 161897 | 161897 | 176501 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 170 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6005674.86736 | 2087315.91925 | 37.7116934016018 | -122.42220159024599 | (37.7116934016018, -122.422201590246) | |||
| 161894 | 161894 | 59931 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 521 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 12 | Permit Number 19403 | 5999683.6559 | 2110322.5324 | 37.7745243018378 | -122.444561248652 | (37.7745243018378, -122.444561248652) | |
| 161173 | 161173 | 225924 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 145 Guerrero St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 2ft | 6005469.65475 | 2108205.8081400003 | 37.7690407421536 | -122.424395748072 | (37.7690407421536, -122.424395748072) | |||
| 161053 | 161053 | 225943 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3386 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005777.63765 | 2103756.4235799997 | 37.75684116881 | -122.423014166371 | (37.75684116881, -122.423014166371) | |||
| 160115 | 160115 | 59914 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 409 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1981 12:00:00 AM | 12 | Permit Number 19383 | 5999728.7839 | 2110019.0941 | 37.773693712339 | -122.444383331369 | (37.773693712339, -122.444383331369) | |
| 160109 | 160109 | 225901 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005825.23106 | 2106352.45228 | 37.763971940068394 | -122.423034081872 | (37.7639719400684, -122.423034081872) | |||
| 159645 | 159645 | 225939 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1037 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6009456.84269 | 2103117.56685 | 37.75529393828 | -122.410244954342 | (37.75529393828, -122.410244954342) | |||
| 159246 | 159246 | 32928 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1550 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 11 | Permit Number 44256 | 6012662.29085 | 2106602.53119 | 37.765042039783395 | -122.39940412891899 | (37.7650420397834, -122.399404128919) | |
| 158982 | 158982 | 225932 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009854.01904 | 2098898.01508 | 37.743730236853 | -122.40857375230101 | (37.743730236853, -122.408573752301) | |||
| 158771 | 158771 | 176498 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 144 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6005795.48549 | 2087494.48765 | 37.7121905153633 | -122.42179737647498 | (37.7121905153633, -122.421797376475) | |||
| 158445 | 158445 | 225966 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 183 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007593.94414 | 2100298.1781200003 | 37.7474479361811 | -122.416487731444 | (37.7474479361811, -122.416487731444) | |||
| 158310 | 158310 | 142337 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 500 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999743.369 | 2110239.8651 | 37.774300725553005 | -122.44434874808998 | (37.774300725553, -122.44434874809) | |||
| 158147 | 158147 | 247455 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 541 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003122.801 | 2110193.1484 | 37.7743646855214 | -122.432655343876 | (37.7743646855214, -122.432655343876) | |||
| 158116 | 158116 | 142702 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 520 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008814.8812 | 2121126.1728 | 37.8047052743397 | -122.413738796098 | (37.8047052743397, -122.413738796098) | |||
| 157984 | 157984 | 225945 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 25 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006157.91256 | 2103444.1528 | 37.7560051968042 | -122.421676853797 | (37.7560051968042, -122.421676853797) | |||
| 157971 | 157971 | 49772 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 6 | Permit Number 46559 | 6008665.3182 | 2086406.55888 | 37.7093647087858 | -122.41180152792299 | (37.7093647087858, -122.411801527923) | |
| 157898 | 157898 | 128866 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001800.9878 | 2116040.20004 | 37.790344153503604 | -122.43764656594 | (37.7903441535036, -122.43764656594) | |||
| 157340 | 157340 | 70988 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 179 11th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1995 12:00:00 AM | 13 | 6007961.92289 | 2109767.88075 | 37.773470246774295 | -122.415885749526 | (37.7734702467743, -122.415885749526) | ||
| 157030 | 157030 | 225903 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 50 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005652.747830001 | 2106381.31475 | 37.7640414549602 | -122.423632703012 | (37.7640414549602, -122.423632703012) | |||
| 156793 | 156793 | 192413 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011782.001 | 2105308.50285 | 37.7614398242054 | -122.402357857724 | (37.7614398242054, -122.402357857724) | |||
| 154958 | 154958 | 112871 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 549 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 5999666.6578 | 2110431.976 | 37.7748238361568 | -122.444627916028 | (37.7748238361568, -122.444627916028) | |||
| 154809 | 154809 | 225913 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 699 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005644.87336 | 2104976.18097 | 37.760182844481 | -122.42356003238501 | (37.760182844481, -122.423560032385) | |||
| 154604 | 154604 | 116598 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 454 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x4 | 5999760.624 | 2110077.6149 | 37.7738562121972 | -122.444277398119 | (37.7738562121972, -122.444277398119) | |||
| 154398 | 154398 | 82843 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 719 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52435 | 6009401.3474 | 2110338.98679 | 37.7751191888227 | -122.410946896775 | (37.7751191888227, -122.410946896775) | |
| 154338 | 154338 | 192414 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 740 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6011806.79674 | 2104934.73644 | 37.76041492892529 | -122.40224581930799 | (37.7604149289253, -122.402245819308) | |||
| 154308 | 154308 | 225938 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008664.0646 | 2101365.80196 | 37.7504395156908 | -122.41286278279101 | (37.7504395156908, -122.412862782791) | |||
| 154004 | 154004 | 81925 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2316 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50640 | 6007582.8644 | 2120346.37282 | 37.80249487840621 | -122.417947010953 | (37.8024948784062, -122.417947010953) | |
| 153603 | 153603 | 128862 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 689 Hayes St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004674.24665 | 2110845.64244 | 37.7762441372985 | -122.427335092236 | (37.7762441372985, -122.427335092236) | |||
| 153251 | 153251 | 192405 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1900 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6012343.89644 | 2104716.4470599997 | 37.759845520476205 | -122.40037289568899 | (37.7598455204762, -122.400372895689) | |||
| 153095 | 153095 | 219000 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1775 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 3ft | 5992776.7043 | 2103406.16926 | 37.7551372592989 | -122.467950350926 | (37.7551372592989, -122.467950350926) |
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");