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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36558 | 36558 | 225906 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3749 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005541.4535 | 2101364.78602 | 37.750260956187404 | -122.423660939909 | (37.7502609561874, -122.423660939909) | |||
| 36653 | 36653 | 225927 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 172 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004830.8864400005 | 2098735.49496 | 37.7430013921091 | -122.425930987935 | (37.7430013921091, -122.425930987935) | |||
| 37482 | 37482 | 225944 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3386 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005759.148709999 | 2103755.79247 | 37.7568383926032 | -122.42307806320801 | (37.7568383926032, -122.423078063208) | |||
| 37497 | 37497 | 102247 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 337 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 5x9 | 6014078.6922 | 2105447.06495 | 37.761948225348505 | -122.394424198727 | (37.7619482253485, -122.394424198727) | |||
| 38420 | 38420 | 244549 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1500 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999267.0062 | 2109103.195 | 37.7711525285338 | -122.44591479977801 | (37.7711525285338, -122.445914799778) | |||
| 38696 | 38696 | 32626 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 75 Boardman Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 14 | Permit Number 37080 | 6011867.62207 | 2109962.18755 | 37.7742225710588 | -122.402388956281 | (37.7742225710588, -122.402388956281) | |
| 39091 | 39091 | 219012 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 139 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995316.47386 | 2090822.54609 | 37.720732063003396 | -122.45825641200399 | (37.7207320630034, -122.458256412004) | |||
| 39266 | 39266 | 225908 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005343.316000001 | 2101393.98229 | 37.7503299359862 | -122.424348189214 | (37.7503299359862, -122.424348189214) | |||
| 39534 | 39534 | 244202 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003923.0756 | 2109749.7244 | 37.7731925042221 | -122.429855409854 | (37.7731925042221, -122.429855409854) | |||
| 39742 | 39742 | 192410 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011779.1081300005 | 2105360.6424 | 37.761582826304604 | -122.402371529224 | (37.7615828263046, -122.402371529224) | |||
| 40013 | 40013 | 62935 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 108 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23316 | 6007129.03577236 | 2097271.50045175 | 37.73911119992621 | -122.417880841628 | (37.7391111999262, -122.417880841628) | ||
| 40705 | 40705 | 192411 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011779.44506 | 2105347.31232 | 37.7615462436837 | -122.40236942660499 | (37.7615462436837, -122.402369426605) | |||
| 40965 | 40965 | 225919 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1683 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009340.70254 | 2099660.4482299997 | 37.745794948977 | -122.410402509267 | (37.745794948977, -122.410402509267) | |||
| 41412 | 41412 | 192412 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011780.95507 | 2105331.83928 | 37.761503842456605 | -122.402363116082 | (37.7615038424566, -122.402363116082) | |||
| 43000 | 43000 | 176515 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6006304.71292 | 2087396.6514 | 37.7119505816242 | -122.420030394781 | (37.7119505816242, -122.420030394781) | |||
| 43253 | 43253 | 219013 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995360.7073099995 | 2090920.7561700002 | 37.721004266213 | -122.458110615707 | (37.721004266213, -122.458110615707) | |||
| 43658 | 43658 | 123212 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 462 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5993143.5323 | 2112325.5219 | 37.7796486158053 | -122.467330287378 | (37.7796486158053, -122.467330287378) | |||
| 43767 | 43767 | 176500 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 162 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005731.33862 | 2087429.69303 | 37.712008985404 | -122.422014487205 | (37.712008985404, -122.422014487205) | |||
| 43922 | 43922 | 176514 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6006291.2518 | 2087400.97553 | 37.7119616963423 | -122.420077226985 | (37.7119616963423, -122.420077226985) | |||
| 44140 | 44140 | 225904 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 50 Camp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005635.69766 | 2106380.47503 | 37.7640381868445 | -122.42369161489701 | (37.7640381868445, -122.423691614897) | |||
| 44495 | 44495 | 225965 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 81 Bernal Heights Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009494.27227 | 2098224.22173 | 37.74185999325589 | -122.409770124916 | (37.7418599932559, -122.409770124916) | |||
| 44681 | 44681 | 225910 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 99 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6005408.28506 | 2103204.3544 | 37.7553044666341 | -122.42425226303101 | (37.7553044666341, -122.424252263031) | |||
| 45304 | 45304 | 225930 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 269 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006712.58135 | 2098072.63553 | 37.7412874920181 | -122.41937757332899 | (37.7412874920181, -122.419377573329) | |||
| 46231 | 46231 | 59941 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1706 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 0 | Permit Number 19415 | 5999632.27517388 | 2110547.02087839 | 37.7751377580465 | -122.444755123369 | (37.7751377580465, -122.444755123369) | |
| 47738 | 47738 | 219007 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 207 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995325.396369999 | 2091321.08064 | 37.7221014328296 | -122.45826163439501 | (37.7221014328296, -122.458261634395) | |||
| 49296 | 49296 | 225964 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 200 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007927.65948 | 2096983.8877299998 | 37.7383663914855 | -122.415099202478 | (37.7383663914855, -122.415099202478) | |||
| 49421 | 49421 | 66180 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1409 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/06/1990 12:00:00 AM | 12 | Permit Number 29257 | 6013724.4666 | 2104745.52937 | 37.76000226421429 | -122.395600181905 | (37.7600022642143, -122.395600181905) | |
| 49449 | 49449 | 219009 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 161 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995318.799459999 | 2090948.50153 | 37.7210780403007 | -122.458257484914 | (37.7210780403007, -122.458257484914) | |||
| 50087 | 50087 | 84421 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3450 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50587 | 6006545.62237249 | 2104975.62835635 | 37.7602321285391 | -122.420444723128 | (37.7602321285391, -122.420444723128) | ||
| 50153 | 50153 | 30919 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 212 Granada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34735 | 5995669.33198455 | 2091339.19890433 | 37.722170938941005 | -122.45707405071501 | (37.722170938941, -122.457074050715) | |||
| 51594 | 51594 | 225963 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 200 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007947.91694 | 2096980.6157799999 | 37.7383585458117 | -122.41502893034401 | (37.7383585458117, -122.415028930344) | |||
| 53261 | 53261 | 225947 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 114 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6003497.57041 | 2095097.9657299998 | 37.7329381267755 | -122.430281767707 | (37.7329381267755, -122.430281767707) | |||
| 53402 | 53402 | 128867 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001756.03579 | 2116033.5731 | 37.7903234016642 | -122.437801621649 | (37.7903234016642, -122.437801621649) | |||
| 56106 | 56106 | 59935 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1743 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 12 | Permit Number 19408 | 5999522.2814 | 2110138.642 | 37.774010176161106 | -122.445106249319 | (37.7740101761611, -122.445106249319) | |
| 56399 | 56399 | 219016 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 23 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998493.11217 | 2097521.42795 | 37.7393076426268 | -122.447757806504 | (37.7393076426268, -122.447757806504) | |||
| 57240 | 57240 | 41187 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 380 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 8 | Permit Number 46607 | 6013185.95339 | 2105307.79412 | 37.761516150579205 | -122.39750208615 | (37.7615161505792, -122.39750208615) | |
| 58127 | 58127 | 176510 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Brookdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006143.81597 | 2087479.5619400002 | 37.7121691699409 | -122.420592382928 | (37.7121691699409, -122.420592382928) | |||
| 58425 | 58425 | 67551 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 655 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 8 | Permit Number 31099 | 6011561.87177 | 2105285.59303 | 37.761364628288604 | -122.403117586111 | (37.7613646282886, -122.403117586111) | |
| 58427 | 58427 | 67493 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 740 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 8 | Permit Number 31018 | 6011800.9294 | 2105019.52264 | 37.760647405471204 | -122.402272073209 | (37.7606474054712, -122.402272073209) | |
| 58473 | 58473 | 225900 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6009378.42208 | 2107868.1744 | 37.768333627729504 | -122.410851658572 | (37.7683336277295, -122.410851658572) | |||
| 59507 | 59507 | 176502 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 170 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005669.88649 | 2087297.20509 | 37.7116417355373 | -122.42221747678002 | (37.7116417355373, -122.42221747678) | |||
| 59772 | 59772 | 225960 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 202 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008021.65482 | 2096973.39205 | 37.7383428544349 | -122.41477346894699 | (37.7383428544349, -122.414773468947) | |||
| 59849 | 59849 | 128863 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 628 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004545.79116 | 2110745.60377 | 37.7759621899439 | -122.42777232553499 | (37.7759621899439, -122.427772325535) | |||
| 60881 | 60881 | 192409 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6011776.86645 | 2105375.28628 | 37.7616229099979 | -122.40238031202 | (37.7616229099979, -122.40238031202) | |||
| 61102 | 61102 | 225917 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 85 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005793.09116 | 2104012.0395299997 | 37.757543902632605 | -122.42297888958099 | (37.7575439026326, -122.422978889581) | |||
| 61608 | 61608 | 32108 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 431 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 11 | Permit Number 35479 | 6002991.887619999 | 2105721.63802 | 37.7620795857172 | -122.432788699839 | (37.7620795857172, -122.432788699839) | |
| 62266 | 62266 | 78621 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2140 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 8 | 6011632.9456400005 | 2104677.50372 | 37.7596989192821 | -122.402829001752 | (37.7596989192821, -122.402829001752) | ||
| 64117 | 64117 | 245459 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007813.0325 | 2106805.2324 | 37.765327138725 | -122.416190917981 | (37.765327138725, -122.416190917981) | |||
| 64675 | 64675 | 225922 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 22 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009935.78986 | 2099989.5983599997 | 37.7467320650326 | -122.40836798561199 | (37.7467320650326, -122.408367985612) | |||
| 65167 | 65167 | 225973 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 478 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002948.31867 | 2105450.2559599997 | 37.761331964925 | -122.432919999069 | (37.761331964925, -122.432919999069) | |||
| 65253 | 65253 | 225977 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 310 Liberty St | 61 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6003712.20285 | 2103924.7270400003 | 37.7571865237503 | -122.43016921035499 | (37.7571865237503, -122.430169210355) | |||
| 65348 | 65348 | 142345 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1736 HAYES ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5999542.2107 | 2110186.9275 | 37.7741438933316 | -122.445040782661 | (37.7741438933316, -122.445040782661) | |||
| 66025 | 66025 | 69088 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33098 | 5992145.68632685 | 2105413.48754834 | 37.7606123691548 | -122.47027874523701 | (37.7606123691548, -122.470278745237) | ||
| 66184 | 66184 | 225934 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008672.01096 | 2101240.80305 | 37.7500967426882 | -122.412826467282 | (37.7500967426882, -122.412826467282) | |||
| 66285 | 66285 | 225948 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6003779.75499 | 2095097.5175400001 | 37.732952875676496 | -122.429306150766 | (37.7329528756765, -122.429306150766) | |||
| 66898 | 66898 | 225961 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 202 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007991.11967 | 2096976.87427 | 37.7383507001153 | -122.414879291246 | (37.7383507001153, -122.414879291246) | |||
| 66905 | 66905 | 244210 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 546 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003934.6479 | 2109752.6175 | 37.7732011032912 | -122.429815586143 | (37.7732011032912, -122.429815586143) | |||
| 67076 | 67076 | 192420 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 5ft | 6013708.5618199995 | 2104154.58233 | 37.7583787675789 | -122.395613785069 | (37.7583787675789, -122.395613785069) | |||
| 69064 | 69064 | 176509 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 127 Brookdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006088.90588 | 2087444.93251 | 37.7120709900614 | -122.420779711712 | (37.7120709900614, -122.420779711712) | |||
| 69394 | 69394 | 32276 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 9 | 6x6 | Permit Number 37277 | 6014077.27946 | 2105468.87126 | 37.7620080221813 | -122.39443061180599 | (37.7620080221813, -122.394430611806) |
| 69483 | 69483 | 32107 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 429 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 10 | Permit Number 35478 | 6002990.68319 | 2105750.27702 | 37.7621581531882 | -122.432794911471 | (37.7621581531882, -122.432794911471) | |
| 69724 | 69724 | 176518 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1501 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6007403.12553 | 2087360.3651400001 | 37.7119127723386 | -122.416231391376 | (37.7119127723386, -122.416231391376) | |||
| 70033 | 70033 | 128871 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2610 Clay St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6001562.056059999 | 2116003.40074 | 37.790229524119795 | -122.438470613846 | (37.7902295241198, -122.438470613846) | |||
| 70095 | 70095 | 59933 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 549 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1981 12:00:00 AM | 9 | Permit Number 19406 | 5999664.8686 | 2110448.6759 | 37.77486958773171 | -122.444635305779 | (37.7748695877317, -122.444635305779) | |
| 70499 | 70499 | 192417 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6013758.38911 | 2104156.54332 | 37.7583869235411 | -122.395441596376 | (37.7583869235411, -122.395441596376) | |||
| 70638 | 70638 | 225898 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009373.69267 | 2107922.6668599998 | 37.7684829862389 | -122.41087186634701 | (37.7684829862389, -122.410871866347) | |||
| 70913 | 70913 | 32088 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3972 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 12 | Permit Number 35461 | 6003219.31552 | 2104788.31954 | 37.759529813480604 | -122.43193546805901 | (37.7595298134806, -122.431935468059) | |
| 71189 | 71189 | 107181 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1520 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6x9 | 5999172.7 | 2109108.7 | 37.7711622584795 | -122.44624140323401 | (37.7711622584795, -122.446241403234) | |||
| 72097 | 72097 | 176499 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 162 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6005745.58119 | 2087451.7768599999 | 37.7120704261874 | -122.421966828522 | (37.7120704261874, -122.421966828522) | |||
| 72606 | 72606 | 219001 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1225 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994518.05416 | 2107169.56941 | 37.7655709877426 | -122.46220122250799 | (37.7655709877426, -122.462201222508) | |||
| 73222 | 73222 | 225974 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 478 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002948.609680001 | 2105430.29379 | 37.761277170124394 | -122.43291756641001 | (37.7612771701244, -122.43291756641) | |||
| 73383 | 73383 | 225950 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 646 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001193.5542 | 2102647.97152 | 37.7535378869843 | -122.438788164466 | (37.7535378869843, -122.438788164466) | |||
| 73386 | 73386 | 176503 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 170 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005661.68615 | 2087270.92863 | 37.711569123398796 | -122.422243953714 | (37.7115691233988, -122.422243953714) | |||
| 73632 | 73632 | 87141 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 169 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767576 | 6007945.36003 | 2109780.43285 | 37.7735037807007 | -122.415943932067 | (37.7735037807007, -122.415943932067) |
| 74298 | 74298 | 219014 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995361.04968 | 2090937.1170400002 | 37.721049208941004 | -122.45811061571999 | (37.721049208941, -122.45811061572) | |||
| 75133 | 75133 | 128874 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1270 Clay St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6008580.96851 | 2116980.96928 | 37.7933104368651 | -122.41425481461799 | (37.7933104368651, -122.414254814618) | |||
| 75594 | 75594 | 142692 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2410 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008497.9336 | 2121083.9891 | 37.8045716448485 | -122.414832641069 | (37.8045716448485, -122.414832641069) | |||
| 75984 | 75984 | 225936 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008666.40255 | 2101335.6889400003 | 37.7503569633096 | -122.412852569207 | (37.7503569633096, -122.412852569207) | |||
| 76270 | 76270 | 67546 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1139 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 19 | Permit Number 31092 | 6011964.43282 | 2103102.09088 | 37.755391686497205 | -122.40157181880501 | (37.7553916864972, -122.401571818805) | |
| 76617 | 76617 | 32627 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 75 Boardman Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 15 | Permit Number 37080 | 6011835.142990001 | 2109991.00563 | 37.774299885758 | -122.40250333475599 | (37.774299885758, -122.402503334756) | |
| 76670 | 76670 | 225926 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 448 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002953.29528 | 2099219.1530400002 | 37.7442231148112 | -122.43245771787 | (37.7442231148112, -122.43245771787) | |||
| 77013 | 77013 | 56360 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2100 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 30 | Permit Number 12506 | 6000958.47841613 | 2115569.02150374 | 37.7890024802988 | -122.440527774143 | (37.7890024802988, -122.440527774143) | |
| 77438 | 77438 | 51908 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 490X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52601 | 6002971.47862471 | 2105361.83743697 | 37.7610905025589 | -122.43283358188299 | (37.7610905025589, -122.432833581883) |
| 77631 | 77631 | 52211 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48395 | 6005137.28408737 | 2104311.29818782 | 37.758328569096 | -122.425268231472 | (37.758328569096, -122.425268231472) | ||
| 77677 | 77677 | 67084 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 200 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30482 | 6007092.73898781 | 2097018.14574656 | 37.738413501248004 | -122.417988384197 | (37.738413501248, -122.417988384197) | ||
| 77679 | 77679 | 73660 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2013 12:00:00 AM | 15 | Permit Number 770522 | 5995314.794096599 | 2090940.29616255 | 37.72105528015361 | -122.45827073660101 | (37.7210552801536, -122.458270736601) | ||
| 78037 | 78037 | 102652 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 203X Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.45920967451401 | (37.7139992025898, -122.459209674514) | |||||
| 78504 | 78504 | 59406 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 31 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 770712 | 6003751.60013387 | 2095492.67978387 | 37.73403630788339 | -122.42943165971 | (37.7340363078834, -122.42943165971) | ||
| 78703 | 78703 | 105804 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 117 ALPINE TER | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | |
| 78706 | 78706 | 36064 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394.0 | 2107812.0 | 37.76818025927739 | -122.410793808029 | (37.7681802592774, -122.410793808029) | |||
| 79347 | 79347 | 32986 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 10X Sierra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | |
| 79458 | 79458 | 45143 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1306 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43999 | 6000301.66695276 | 2109252.99284462 | 37.7716228610878 | -122.442346636259 | (37.7716228610878, -122.442346636259) | ||
| 79560 | 79560 | 7700 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 640 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x6 | 6008187.1407969 | 2121043.7620312 | 37.804443723648895 | -122.415905321467 | (37.8044437236489, -122.415905321467) | |||
| 79956 | 79956 | 67927 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31640 | 6003789.22877148 | 2095116.32621568 | 37.733005056394795 | -122.429274738173 | (37.7330050563948, -122.429274738173) | ||
| 80611 | 80611 | 117516 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1115 YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6010054.0 | 2102576.0 | 37.753840371529705 | -122.40814160377899 | (37.7538403715297, -122.408141603779) | |||
| 81265 | 81265 | 10174 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1038 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 2x2 | 6005692.3267338 | 2102916.9952861997 | 37.7545314795937 | -122.423249534916 | (37.7545314795937, -122.423249534916) | |||
| 81301 | 81301 | 21413 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 2692X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | ||||
| 81416 | 81416 | 66557 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3772 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | Permit Number 29741 | 6005175.23956871 | 2104313.40408574 | 37.758336495615204 | -122.42513711444799 | (37.7583364956152, -122.425137114448) | ||
| 81680 | 81680 | 34425 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2008 12:00:00 AM | 3x3 | Permit Number 50336 | 6003617.84008567 | 2095979.02625995 | 37.735364130918796 | -122.429928789613 | (37.7353641309188, -122.429928789613) | ||
| 81707 | 81707 | 35398 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 540 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38853 | 6003072.48314636 | 2098933.73753739 | 37.743446188104 | -122.43202521517 | (37.743446188104, -122.43202521517) |
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");