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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 124435 | 124435 | 33658 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 575 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37746 | 6004659.15076187 | 2110673.58419475 | 37.7757708537128 | -122.427375053318 | (37.7757708537128, -122.427375053318) | |||
| 122776 | 122776 | 34009 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 18 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39435 | 6007439.60245605 | 2099473.00721902 | 37.7451735210906 | -122.416962980086 | (37.7451735210906, -122.416962980086) | ||
| 44833 | 44833 | 34144 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1754 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39666 | 6003955.69985192 | 2098004.27278913 | 37.740944124338895 | -122.428905023889 | (37.7409441243389, -122.428905023889) | ||
| 95313 | 95313 | 34169 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3738 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39486 | 6005390.32082668 | 2104325.33751818 | 37.758381409843295 | -122.424394116765 | (37.7583814098433, -122.424394116765) | ||
| 154249 | 154249 | 34233 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1690 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 8 | Permit Number 38046 | 5989683.0382 | 2103856.1412 | 37.7561936262155 | -122.47868193754299 | (37.7561936262155, -122.478681937543) | ||
| 168115 | 168115 | 34234 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 475 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1997 12:00:00 AM | 9 | Permit Number 38047 | 6009059.1086 | 2121116.8197 | 37.8046933049163 | -122.41289295806801 | (37.8046933049163, -122.412892958068) | ||
| 91732 | 91732 | 34299 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2460 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38087 | 6009686.14840404 | 2103014.07472331 | 37.7550226229561 | -122.409444639751 | (37.7550226229561, -122.409444639751) | ||
| 106596 | 106596 | 34441 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 75 Swiss Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38185 | 6001277.80934276 | 2096614.82991295 | 37.7369771019142 | -122.43806465824899 | (37.7369771019142, -122.438064658249) | ||
| 89217 | 89217 | 34443 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38187 | 6004317.14831895 | 2097838.60614012 | 37.740509693537504 | -122.427643467723 | (37.7405096935375, -122.427643467723) | ||
| 10474 | 10474 | 34625 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1466 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38307 | 5988697.9248 | 2105373.4338 | 37.76030245534 | -122.482199912019 | (37.76030245534, -122.482199912019) |
| 173732 | 173732 | 34626 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1474 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 0 | Permit Number 38308 | 5988706.220433701 | 2105294.39494794 | 37.760085918568 | -122.48216543102 | (37.760085918568, -122.48216543102) | |
| 102349 | 102349 | 34758 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38402 | 6007966.74070994 | 2102458.08144685 | 37.7533995021275 | -122.415351503246 | (37.7533995021275, -122.415351503246) | |
| 139926 | 139926 | 34898 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 267 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1997 12:00:00 AM | Permit Number 38503 | 6001403.8262241 | 2096433.01440588 | 37.736485044647495 | -122.43761594552299 | (37.7364850446475, -122.437615945523) | |||
| 109990 | 109990 | 35000 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 8028 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | Permit Number 38578 | 5982135.81465862 | 2112401.83483279 | 37.7792165374199 | -122.50541575084101 | (37.7792165374199, -122.505415750841) | |||
| 93635 | 93635 | 35001 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 8028 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | Permit Number 38578 | 5982135.81465862 | 2112401.83483279 | 37.7792165374199 | -122.50541575084101 | (37.7792165374199, -122.505415750841) | |||
| 47279 | 47279 | 35103 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 786 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38645 | 6001885.65115289 | 2089265.94057695 | 37.7168332689419 | -122.43543753433399 | (37.7168332689419, -122.435437534334) | ||
| 104807 | 104807 | 35134 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 849 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38664 | 6001545.25839951 | 2089134.40240899 | 37.716452756426 | -122.43660469328 | (37.716452756426, -122.43660469328) | ||
| 70350 | 70350 | 35250 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38738 | 6006287.30636 | 2119683.41372 | 37.800601562682296 | -122.42238315976999 | (37.8006015626823, -122.42238315977) | |
| 27440 | 27440 | 35252 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 7 | Permit Number 38738 | 6006246.10083 | 2119680.0646 | 37.8005900423666 | -122.42252550983801 | (37.8005900423666, -122.422525509838) | |
| 50358 | 50358 | 35258 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1304 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 11 | Permit Number 38744 | 6006066.5782 | 2120048.78389 | 37.8015923223752 | -122.42317295609199 | (37.8015923223752, -122.423172956092) | |
| 110851 | 110851 | 35265 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006296.38753209 | 2118756.6266107 | 37.79805735235279 | -122.422285851072 | (37.7980573523528, -122.422285851072) | |
| 56697 | 56697 | 35266 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2323 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | 3x3 | Permit Number 38750 | 6006292.04033 | 2118835.34945 | 37.798273260158 | -122.42230648984699 | (37.798273260158, -122.422306489847) |
| 55604 | 55604 | 35336 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2311 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2005 12:00:00 AM | 1 | Permit Number 48271 | 6010839.4517 | 2105063.96093 | 37.7607157062843 | -122.40560053693501 | (37.7607157062843, -122.405600536935) | |
| 135271 | 135271 | 35351 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1274 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 11 | 5x5 | Permit Number 38813 | 6012220.8536 | 2102461.75759 | 37.7536477760478 | -122.400640051912 | (37.7536477760478, -122.400640051912) |
| 81838 | 81838 | 35367 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | Permit Number 38827 | 6011631.49743277 | 2091601.49478662 | 37.723794911059606 | -122.401914809778 | (37.7237949110596, -122.401914809778) | ||
| 144903 | 144903 | 35368 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 627 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | Permit Number 38828 | 6011631.82829511 | 2091600.41039567 | 37.72379195201 | -122.401913589843 | (37.72379195201, -122.401913589843) | ||
| 85499 | 85499 | 35558 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 801 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38931 | 6005679.14966284 | 2104317.39620731 | 37.7583759105796 | -122.423394653078 | (37.7583759105796, -122.423394653078) | ||
| 144563 | 144563 | 35559 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 801 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38931 | 6005679.14966284 | 2104317.39620731 | 37.7583759105796 | -122.423394653078 | (37.7583759105796, -122.423394653078) | ||
| 102320 | 102320 | 35681 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4521 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2000 12:00:00 AM | Permit Number 41986 | 6000920.86314017 | 2101102.84545022 | 37.749279824800794 | -122.43962042595899 | (37.7492798248008, -122.439620425959) | |||
| 124166 | 124166 | 35786 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 580 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39038 | 6002648.18507624 | 2102127.11023082 | 37.752190374612205 | -122.433720516444 | (37.7521903746122, -122.433720516444) | |||
| 93949 | 93949 | 36079 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2170 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39193 | 6008724.90392173 | 2105792.20395445 | 37.7625968269406 | -122.412965325481 | (37.7625968269406, -122.412965325481) | ||
| 44871 | 44871 | 36124 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1324 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | 10 | Permit Number 39220 | 5988358.7841 | 2106301.1655 | 37.7628300220311 | -122.483440838848 | (37.7628300220311, -122.483440838848) | |
| 1362 | 1362 | 36186 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 133 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 8 | Permit Number 39255 | 5995881.41756 | 2113499.8369 | 37.783030646722004 | -122.45794382331002 | (37.783030646722, -122.45794382331) | |
| 124549 | 124549 | 36508 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 584 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2003 12:00:00 AM | Permit Number 39385 | 6007790.43718065 | 2096197.35426509 | 37.736199030760105 | -122.41551798135401 | (37.7361990307601, -122.415517981354) | ||
| 97900 | 97900 | 36509 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 734 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39386 | 6007727.24180812 | 2095500.96385803 | 37.7342833425639 | -122.41568718150499 | (37.7342833425639, -122.415687181505) | ||
| 92505 | 92505 | 36515 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 263 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39393 | 6006742.46472301 | 2095809.17822197 | 37.735074223818 | -122.41911373442801 | (37.735074223818, -122.419113734428) | ||
| 94212 | 94212 | 36529 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3653 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39401 | 6008503.02776352 | 2097873.6031148 | 37.7408416720866 | -122.413172749536 | (37.7408416720866, -122.413172749536) | ||
| 77394 | 77394 | 36576 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2959 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39438 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | ||
| 144588 | 144588 | 36580 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2970 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39441 | 6009675.57743886 | 2101054.36494821 | 37.7496411039984 | -122.40934290688699 | (37.7496411039984, -122.409342906887) | ||
| 141051 | 141051 | 36724 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 63 Rondel Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39508 | 6006392.72419267 | 2106420.79209113 | 37.7641915920141 | -122.421076141152 | (37.7641915920141, -122.421076141152) | ||
| 117079 | 117079 | 36725 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 67 Rondel Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39509 | 6006393.67991205 | 2106403.54296873 | 37.764144283858 | -122.42107161074499 | (37.764144283858, -122.421071610745) | ||
| 145514 | 145514 | 36912 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 462 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39558 | 6001795.24469861 | 2103152.27063521 | 37.7549567840787 | -122.436743488368 | (37.7549567840787, -122.436743488368) | ||
| 96769 | 96769 | 36919 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 699 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900.0 | 2102596.0 | 37.7534353511669 | -122.43634140628299 | (37.7534353511669, -122.436341406283) | ||
| 127101 | 127101 | 36920 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 699 Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900.0 | 2102596.0 | 37.7534353511669 | -122.43634140628299 | (37.7534353511669, -122.436341406283) | ||
| 122125 | 122125 | 36922 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 560 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39566 | 6001824.70318971 | 2102569.45422628 | 37.753358184191704 | -122.436599898251 | (37.7533581841917, -122.436599898251) | ||
| 99531 | 99531 | 37020 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1061 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39632 | 6008655.69574399 | 2102373.47059511 | 37.7532058777371 | -122.412962961361 | (37.7532058777371, -122.412962961361) | ||
| 77700 | 77700 | 37051 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 364 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39656 | 6003583.41460965 | 2098669.49042288 | 37.7427495797017 | -122.43023969551201 | (37.7427495797017, -122.430239695512) | ||
| 65053 | 65053 | 37086 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1426 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39686 | 5981873.63686209 | 2105374.96731705 | 37.7599073668224 | -122.505801636192 | (37.7599073668224, -122.505801636192) | |
| 86248 | 86248 | 37317 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 576 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39832 | 6002608.13051852 | 2103294.09534049 | 37.7553923649469 | -122.433942439191 | (37.7553923649469, -122.433942439191) | ||
| 122800 | 122800 | 37408 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1711 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39888 | 6002631.16896948 | 2100601.66569625 | 37.7480008987993 | -122.43367034777599 | (37.7480008987993, -122.433670347776) | ||
| 94512 | 94512 | 37474 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1642 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39945 | 5992805.4256232 | 2104283.42646812 | 37.7575476379464 | -122.467914829169 | (37.7575476379464, -122.467914829169) | ||
| 111164 | 111164 | 37693 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 566 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40079 | 6007847.07548842 | 2104633.16942482 | 37.7593650704509 | -122.415919346196 | (37.7593650704509, -122.415919346196) | ||
| 112305 | 112305 | 37713 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 879 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | 3x3 | Permit Number 40084 | 6007585.89861945 | 2104551.15151716 | 37.7591251811896 | -122.416816815015 | (37.7591251811896, -122.416816815015) | |
| 91151 | 91151 | 37714 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 879 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | 3x3 | Permit Number 40084 | 6007585.89861945 | 2104551.15151716 | 37.7591251811896 | -122.416816815015 | (37.7591251811896, -122.416816815015) | |
| 143156 | 143156 | 37729 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1424 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40093 | 6009274.50535547 | 2100894.4740613997 | 37.74917959981 | -122.410718543725 | (37.74917959981, -122.410718543725) | ||
| 111062 | 111062 | 37754 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1138 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40101 | 6008628.86236582 | 2101910.8796111 | 37.7519342006623 | -122.413023051242 | (37.7519342006623, -122.413023051242) | ||
| 10290 | 10290 | 37814 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003977.37565 | 2090552.2455 | 37.720483755714 | -122.428299091747 | (37.720483755714, -122.428299091747) |
| 12958 | 12958 | 37815 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003965.721940001 | 2090553.1315400002 | 37.7204855291627 | -122.42833943800899 | (37.7204855291627, -122.428339438009) |
| 2637 | 2637 | 37816 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003955.6668300005 | 2090537.19552 | 37.720441203374 | -122.428373060073 | (37.720441203374, -122.428373060073) |
| 104489 | 104489 | 37824 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 96417 | 96417 | 37825 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 78948 | 78948 | 37828 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2006 12:00:00 AM | 8 | 3x3 | Permit Number 48867 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 139322 | 139322 | 37829 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 2638 | 2638 | 37832 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48867 | 6003860.1558 | 2090386.44981 | 37.7200218836872 | -122.42869247048 | (37.7200218836872, -122.42869247048) |
| 2661 | 2661 | 37833 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003832.66245 | 2090342.4611400003 | 37.719899544415604 | -122.428784371324 | (37.7198995444156, -122.428784371324) |
| 142748 | 142748 | 37835 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 93136 | 93136 | 37837 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 23 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 110887 | 110887 | 37852 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 639 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40143 | 6003947.74961722 | 2091786.98448726 | 37.723872400431496 | -122.428489463759 | (37.7238724004315, -122.428489463759) | ||
| 80404 | 80404 | 37853 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 639 Excelsior Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40143 | 6003947.74961722 | 2091786.98448726 | 37.723872400431496 | -122.428489463759 | (37.7238724004315, -122.428489463759) | ||
| 90974 | 90974 | 37857 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 50 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.42496422599702 | (37.7235254489092, -122.424964225997) | ||
| 37273 | 37273 | 37949 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40189 | 6013245.07108 | 2104267.20859 | 37.7586622221997 | -122.39722464979602 | (37.7586622221997, -122.397224649796) | |
| 124022 | 124022 | 37952 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1308 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40191 | 6013419.73141926 | 2106176.98186548 | 37.763915762931106 | -122.396754475262 | (37.7639157629311, -122.396754475262) | ||
| 30607 | 30607 | 38043 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1523 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 8 | Permit Number 40245 | 6000097.0958 | 2114311.3232 | 37.7855000811005 | -122.44341765838199 | (37.7855000811005, -122.443417658382) | |
| 156125 | 156125 | 38044 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1523 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 11 | Permit Number 40245 | 6000092.6356 | 2114341.0582 | 37.785581471348706 | -122.443435225951 | (37.7855814713487, -122.443435225951) | |
| 168067 | 168067 | 38049 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2005 12:00:00 AM | 9 | Permit Number 47797 | 6000509.1373 | 2114490.0048 | 37.78601418351771 | -122.44200495026199 | (37.7860141835177, -122.442004950262) | |
| 176862 | 176862 | 38050 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2005 12:00:00 AM | 3 | Permit Number 47797 | 6000529.6397 | 2114492.1859 | 37.786021340576205 | -122.441934174319 | (37.7860213405762, -122.441934174319) | |
| 27735 | 27735 | 38051 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 0 | Permit Number 40248 | 6000571.40891222 | 2114495.1875696997 | 37.786031962456896 | -122.44178988005899 | (37.7860319624569, -122.441789880059) | |
| 69451 | 69451 | 38054 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2779 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/01/1999 12:00:00 AM | 7 | Permit Number 40250 | 6000242.4339 | 2114393.9483 | 37.7857352353713 | -122.442920768491 | (37.7857352353713, -122.442920768491) | |
| 150176 | 150176 | 38055 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2779 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1999 12:00:00 AM | 5 | Permit Number 40250 | 6000228.6146 | 2114392.8852 | 37.78573152849079 | -122.442968502827 | (37.7857315284908, -122.442968502827) | |
| 98289 | 98289 | 38068 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2299 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40258 | 6001654.0 | 2114215.0 | 37.7853242650019 | -122.438024337369 | (37.7853242650019, -122.438024337369) | |||
| 84208 | 84208 | 38069 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1654X SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40258 | 6001625.0 | 2114095.0 | 37.7849931264589 | -122.43811606926701 | (37.7849931264589, -122.438116069267) | |||
| 117697 | 117697 | 38332 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 680 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | 12 | Permit Number 40386 | 6007469.91383888 | 2105705.1165966997 | 37.7622871778741 | -122.417299722191 | (37.7622871778741, -122.417299722191) | |
| 123969 | 123969 | 38333 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 684 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40387 | 6006701.38591008 | 2112874.96361955 | 37.7819305989802 | -122.420466726707 | (37.7819305989802, -122.420466726707) | |||
| 98885 | 98885 | 38501 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2133 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | Permit Number 40492 | 6006816.69957876 | 2118509.8967936 | 37.797409229816104 | -122.42046789447399 | (37.7974092298161, -122.420467894474) | ||
| 129666 | 129666 | 38525 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3031 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/1998 12:00:00 AM | 11 | Permit Number 40508 | 6001946.95136 | 2118602.5164799998 | 37.7973879072825 | -122.437325094293 | (37.7973879072825, -122.437325094293) | ||
| 40082 | 40082 | 38526 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3031 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/1998 12:00:00 AM | 9 | Permit Number 40508 | 6001945.50794 | 2118614.30712 | 37.797420199240996 | -122.437330933595 | (37.797420199241, -122.437330933595) | ||
| 86777 | 86777 | 38531 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1426 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1998 12:00:00 AM | Permit Number 40513 | 6007984.37872155 | 2099748.42101744 | 37.74596037533 | -122.415098722892 | (37.74596037533, -122.415098722892) | ||
| 151645 | 151645 | 38575 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1511 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40535 | 6015329.8173 | 2094876.8945 | 37.732994214171704 | -122.389358843431 | (37.7329942141717, -122.389358843431) | |
| 118307 | 118307 | 38576 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1515 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/2005 12:00:00 AM | Permit Number 40536 | 6015316.8681654995 | 2094894.06453978 | 37.7330406417059 | -122.38940481098601 | (37.7330406417059, -122.389404810986) | ||
| 145627 | 145627 | 38582 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1565 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40542 | 6015429.1390942 | 2094459.97574961 | 37.7318549452945 | -122.388986360684 | (37.7318549452945, -122.388986360684) | ||
| 95504 | 95504 | 38702 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1508 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | Permit Number 40610 | 6001927.2408902 | 2111561.6017671 | 37.7780542409849 | -122.436888988053 | (37.7780542409849, -122.436888988053) | ||
| 96770 | 96770 | 39100 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3376 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40789 | 6006536.85037285 | 2102635.06060624 | 37.7538049769481 | -122.42030893490299 | (37.7538049769481, -122.420308934903) | ||
| 145188 | 145188 | 39196 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 948 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40848 | 6009924.75641086 | 2103679.40260243 | 37.756862830813105 | -122.408666394738 | (37.7568628308131, -122.408666394738) | ||
| 85747 | 85747 | 39220 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1143 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41443 | 6005801.05573922 | 2102320.92573379 | 37.752900946135604 | -122.422831161336 | (37.7529009461356, -122.422831161336) | ||
| 125085 | 125085 | 39221 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1143 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41443 | 6005801.05573922 | 2102320.92573379 | 37.752900946135604 | -122.422831161336 | (37.7529009461356, -122.422831161336) | ||
| 3793 | 3793 | 39226 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 770 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 9 | Permit Number 40869 | 5984798.64138 | 2110605.0729799997 | 37.774439483359 | -122.49607147975 | (37.774439483359, -122.49607147975) | ||
| 109349 | 109349 | 39488 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3838 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40946 | 6004210.35746859 | 2101925.0566577 | 37.751724101234004 | -122.42830388310301 | (37.751724101234, -122.428303883103) | ||
| 81412 | 81412 | 39503 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) | ||
| 122534 | 122534 | 39505 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) | ||
| 101744 | 101744 | 39506 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) |
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");