Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45 | 45 | 27522 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3201 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5998967.7443 | 2114917.3257 | 37.787099536792 | -122.44736849888001 | (37.787099536792, -122.44736849888) | |||
| 121 | 121 | 59839 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1981 12:00:00 AM | 3 | Permit Number 19293 | 6016946.5018 | 2093669.1216 | 37.729767407645895 | -122.383685429115 | (37.7297674076459, -122.383685429115) | |
| 193 | 193 | 6069 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1930 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2015 12:00:00 AM | 3 | 3X3 | 6001175.3543 | 2112495.6639 | 37.7805761758993 | -122.439557004629 | (37.7805761758993, -122.439557004629) | ||
| 441 | 441 | 251295 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 220 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | 3x3 | Permit Number 27117 | 5982087.0 | 2112698.0 | 37.7800268469822 | -122.50560657808902 | (37.7800268469822, -122.505606578089) | ||
| 579 | 579 | 2702 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2121 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003192.7078 | 2114808.0993 | 37.7870401500361 | -122.432743262211 | (37.7870401500361, -122.432743262211) | |||
| 706 | 706 | 2833 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6008452.59238 | 2116301.4374700002 | 37.7914373972624 | -122.41465089583099 | (37.7914373972624, -122.414650895831) | |||
| 802 | 802 | 64866 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1989 12:00:00 AM | 13 | Permit Number 25884 | 5997401.9097 | 2109840.7512 | 37.773070992957 | -122.45241943675501 | (37.773070992957, -122.452419436755) | |
| 872 | 872 | 5299 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001101.8528 | 2114070.3216 | 37.7848955998057 | -122.43992421757 | (37.7848955998057, -122.43992421757) | |||
| 1031 | 1031 | 8753 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3330 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1993 12:00:00 AM | 6 | 3X3 | 5996823.9268 | 2112988.7445 | 37.7816814274235 | -122.45464621041799 | (37.7816814274235, -122.454646210418) | ||
| 1426 | 1426 | 5257 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1199 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001336.2739 | 2112445.4083 | 37.780447344039395 | -122.43899670569701 | (37.7804473440394, -122.438996705697) | |||
| 1490 | 1490 | 8186 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1247 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001773.6755 | 2111139.4897 | 37.7768864982616 | -122.437389990835 | (37.7768864982616, -122.437389990835) | |||
| 1564 | 1564 | 106910 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3536 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773298 | 5997359.139830001 | 2116076.9553400003 | 37.7901915187728 | -122.453017625461 | (37.7901915187728, -122.453017625461) | |
| 1900 | 1900 | 8769 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3416 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1992 12:00:00 AM | 3 | 3X3 | 5996444.0483 | 2112944.9189 | 37.78153929807 | -122.455957233363 | (37.78153929807, -122.455957233363) | ||
| 2073 | 2073 | 252864 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1660 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000023.0 | 2106990.0 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | ||||
| 2136 | 2136 | 24780 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5982810.69991 | 2112498.67348 | 37.779522119266204 | -122.503088254558 | (37.7795221192662, -122.503088254558) | |||
| 2451 | 2451 | 2187 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1040 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6000917.5615 | 2112301.3252 | 37.7800278959817 | -122.440434888409 | (37.7800278959817, -122.440434888409) | |||
| 2475 | 2475 | 213240 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 72 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 11/24/1982 12:00:00 AM | 14 | Width 3ft | Permit Number 20046 | 5997197.846969999 | 2089560.74227 | 37.7173753740534 | -122.451662146612 | (37.7173753740534, -122.451662146612) | |
| 2599 | 2599 | 56658 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2436 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5987881.10051 | 2113316.56801 | 37.7820645490157 | -122.485607837735 | (37.7820645490157, -122.485607837735) | ||||
| 2609 | 2609 | 23699 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2100X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6005145.75001 | 2116914.64586 | 37.7929347693837 | -122.42613619164301 | (37.7929347693837, -122.426136191643) | ||
| 2671 | 2671 | 8707 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3100 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1986 12:00:00 AM | 12 | 3X3 | 5997465.2361 | 2113075.7189 | 37.781956998716396 | -122.452433873123 | (37.7819569987164, -122.452433873123) | ||
| 2742 | 2742 | 2689 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2103 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6003388.0503 | 2114834.422 | 37.7871235022131 | -122.43206930161199 | (37.7871235022131, -122.432069301612) | |||
| 2755 | 2755 | 2701 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2121 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003174.2357 | 2114805.7903 | 37.787032762464705 | -122.432807006492 | (37.7870327624647, -122.432807006492) | |||
| 2803 | 2803 | 8755 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3330 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1993 12:00:00 AM | 3 | 3X3 | 5996762.334 | 2112977.2381 | 37.7816463009434 | -122.454858459552 | (37.7816463009434, -122.454858459552) | ||
| 2808 | 2808 | 232604 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 509 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 28219 | 6003467.96193 | 2095980.6299 | 37.7353600451305 | -122.430447088284 | (37.7353600451305, -122.430447088284) | |
| 2832 | 2832 | 232603 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 519 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1989 12:00:00 AM | 15 | Width 3ft | Permit Number 28180 | 6003417.91848 | 2095942.05224 | 37.7352512847143 | -122.430617355104 | (37.7352512847143, -122.430617355104) | |
| 2870 | 2870 | 2203 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1120 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 7x5 | 6000884.7346 | 2112533.821 | 37.780664400973 | -122.440565131493 | (37.780664400973, -122.440565131493) | |||
| 2934 | 2934 | 250407 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/16/1997 12:00:00 AM | 12 | Width 4ft | Permit Number 38521 | 5987994.17396 | 2115794.4903599997 | 37.78887480516529 | -122.485398549405 | (37.7888748051653, -122.485398549405) | |
| 2940 | 2940 | 250421 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5987880.27353 | 2115792.69032 | 37.788863226412296 | -122.485792492053 | (37.7888632264123, -122.485792492053) | |||
| 2944 | 2944 | 232231 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 111 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 7 | Width 3ft | Permit Number 37780 | 6003645.44992 | 2108813.0512099997 | 37.7706049033258 | -122.430748898054 | (37.7706049033258, -122.430748898054) | |
| 2955 | 2955 | 232230 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 111 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 7 | Width 3ft | Permit Number 37780 | 6003632.85461 | 2108809.4147799998 | 37.7705942049744 | -122.430792205812 | (37.7705942049744, -122.430792205812) | |
| 2983 | 2983 | 250419 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | 8 | Width 4ft | Permit Number 38081 | 5987849.1846199995 | 2115791.00757 | 37.7888567944531 | -122.48589993045601 | (37.7888567944531, -122.485899930456) | |
| 2985 | 2985 | 250408 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Seacliff Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5988046.91633 | 2115796.65095 | 37.7888838100916 | -122.485216228949 | (37.7888838100916, -122.485216228949) | |||
| 2987 | 2987 | 250422 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987891.12003 | 2115793.8659200002 | 37.7888670862959 | -122.48575505145399 | (37.7888670862959, -122.485755051454) | |||
| 3001 | 3001 | 7734 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3x3 | 6006417.36011 | 2111247.6082200003 | 37.777446266458 | -122.42133372647699 | (37.777446266458, -122.421333726477) | |||
| 3017 | 3017 | 250423 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987905.22883 | 2115793.56651 | 37.7888670863011 | -122.485706215587 | (37.7888670863011, -122.485706215587) | |||
| 3089 | 3089 | 2184 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1030 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6000920.2689 | 2112277.9741 | 37.779963933965995 | -122.440423847121 | (37.779963933966, -122.440423847121) | |||
| 3157 | 3157 | 6076 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1950 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001110.3773 | 2112486.1881 | 37.780546459454996 | -122.439781110889 | (37.780546459455, -122.439781110889) | |||
| 3167 | 3167 | 210018 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 129 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 10 | Width 3ft | Permit Number 25335 | 5995846.58682 | 2096221.4645200002 | 37.7355866437016 | -122.45681426186701 | (37.7355866437016, -122.456814261867) | |
| 3173 | 3173 | 6353 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1985 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1992 12:00:00 AM | 6 | 3X3 | 6001392.1135 | 2112821.0565 | 37.7814819554931 | -122.43883045753701 | (37.7814819554931, -122.438830457537) | ||
| 3177 | 3177 | 46976 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 94122 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44996 | ||||||||
| 3314 | 3314 | 8704 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3040 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997630.7244 | 2113099.07 | 37.7820305944204 | -122.45186304771099 | (37.7820305944204, -122.451863047711) | |||
| 3470 | 3470 | 8669 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998067.7961 | 2113159.1399 | 37.7822205542064 | -122.450355317805 | (37.7822205542064, -122.450355317805) | |||
| 3476 | 3476 | 8169 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1178 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6002155.3413 | 2111245.817 | 37.7772001368339 | -122.436077305312 | (37.7772001368339, -122.436077305312) | |||
| 3477 | 3477 | 22794 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1015X Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6000886.4267 | 2112199.4602 | 37.7797464277805 | -122.440535289267 | (37.7797464277805, -122.440535289267) | |||
| 3487 | 3487 | 18489 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 29 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6010385.55842 | 2113872.45132 | 37.784876392368396 | -122.40779148690201 | (37.7848763923684, -122.407791486902) | |||
| 3635 | 3635 | 210326 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1515 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1992 12:00:00 AM | 6 | Width 2ft | Permit Number 31364 | 5994586.35542 | 2105191.7373900004 | 37.760144306721 | -122.46182156022499 | (37.760144306721, -122.461821560225) | |
| 3648 | 3648 | 210351 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 15 | Width 4ft | Permit Number 35554 | 5992053.09945 | 2099023.47402 | 37.743061697037895 | -122.470133645862 | (37.7430616970379, -122.470133645862) | |
| 3659 | 3659 | 209947 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 13 | Width 3ft | Permit Number 35554 | 5992051.55672 | 2099045.56782 | 37.7431222717841 | -122.47014058862301 | (37.7431222717841, -122.470140588623) | |
| 3770 | 3770 | 94964 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3098 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2010 12:00:00 AM | 12 | 5999368.8526 | 2116683.0767599996 | 37.791970737501 | -122.446107814943 | (37.791970737501, -122.446107814943) | |||
| 3861 | 3861 | 253579 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3862 | 3862 | 253583 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3865 | 3865 | 253578 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3866 | 3866 | 253581 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3867 | 3867 | 253577 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3869 | 3869 | 253580 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 350 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011789.5496 | 2116050.32639 | 37.79093482122921 | -122.403087348315 | (37.7909348212292, -122.403087348315) | ||
| 3870 | 3870 | 253584 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 3871 | 3871 | 253582 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 465 Pine St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/29/2017 12:00:00 AM | 3 | 3x3 | 6011680.1618800005 | 2116341.3084 | 37.7917276793349 | -122.403486307981 | (37.7917276793349, -122.403486307981) | ||
| 4018 | 4018 | 2214 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1180 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5x6 | 6000870.8593 | 2112663.4365 | 37.7810195019401 | -122.440622432274 | (37.7810195019401, -122.440622432274) | |||
| 4275 | 4275 | 24939 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7315 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 10:40:00 AM | 3 | 3X3 | 5984290.37601 | 2112411.90952 | 37.7793707517194 | -122.497963093664 | (37.7793707517194, -122.497963093664) | ||
| 4310 | 4310 | 7733 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3x3 | 6006420.56293 | 2111227.36292 | 37.7773908583325 | -122.42132120880501 | (37.7773908583325, -122.421321208805) | |||
| 4706 | 4706 | 2834 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X3 | 6008517.592999999 | 2116245.0199599997 | 37.791286140299 | -122.414422000399 | (37.791286140299, -122.414422000399) | |||
| 4808 | 4808 | 248401 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 721 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 10 | Width 0ft | Permit Number 35191 | 5998539.5007 | 2108099.8388 | 37.7683559999766 | -122.44835899152099 | (37.7683559999766, -122.448358991521) | |
| 5297 | 5297 | 9909 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1850 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005266.16067 | 2116037.55632 | 37.790533307027296 | -122.425657110207 | (37.7905333070273, -122.425657110207) | |||
| 5344 | 5344 | 5307 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6001124.6062 | 2113907.9724 | 37.7844511257674 | -122.43983385427099 | (37.7844511257674, -122.439833854271) | |||
| 5407 | 5407 | 5304 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6001115.9968 | 2113959.0141 | 37.7845907831124 | -122.439867300639 | (37.7845907831124, -122.439867300639) | |||
| 5411 | 5411 | 8150 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002846.3106 | 2111341.485 | 37.7775020483312 | -122.433693863913 | (37.7775020483312, -122.433693863913) | |||
| 5533 | 5533 | 8673 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997990.2975 | 2113148.3104 | 37.7821863836314 | -122.45062264598499 | (37.7821863836314, -122.450622645985) | |||
| 5556 | 5556 | 6080 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1970 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001000.0518 | 2112470.2823 | 37.7804965057813 | -122.440161637274 | (37.7804965057813, -122.440161637274) | |||
| 5564 | 5564 | 8191 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1280 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6001633.6542 | 2111170.6819 | 37.7769641829366 | -122.437876600816 | (37.7769641829366, -122.437876600816) | |||
| 5603 | 5603 | 34246 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38056 | ||||||||||
| 5617 | 5617 | 35204 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 5651 | 5651 | 8712 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3120 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997408.0428 | 2113069.6273 | 37.781936995917896 | -122.45263129483801 | (37.7819369959179, -122.452631294838) | |||
| 5688 | 5688 | 18490 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 29 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | 6010377.42756 | 2113906.8182 | 37.784970300477 | -122.407822041378 | (37.784970300477, -122.407822041378) | |||
| 5705 | 5705 | 2688 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2103 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1991 12:00:00 AM | 6 | 3X3 | 6003377.8906 | 2114832.113 | 37.7871165862827 | -122.432104286971 | (37.7871165862827, -122.432104286971) | ||
| 5849 | 5849 | 21633 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1615 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004763.9583 | 2114678.6617 | 37.786773733259395 | -122.42729786002701 | (37.7867737332594, -122.427297860027) | |||
| 5877 | 5877 | 84829 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2680 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2011 12:00:00 AM | 3 | 3x3 | Permit Number 53660 | 5999399.8288 | 2113638.7489 | 37.7836135792544 | -122.44578160080499 | (37.7836135792544, -122.445781600805) |
| 5969 | 5969 | 111118 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 5997454.0334 | 2109847.6499 | 37.7730929211041 | -122.45223963309401 | (37.7730929211041, -122.452239633094) | |||
| 6011 | 6011 | 66459 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 26 Wood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 12 | Permit Number 29609 | 5998393.1041 | 2113638.7682 | 37.7835561003446 | -122.449264468811 | (37.7835561003446, -122.449264468811) | |
| 6014 | 6014 | 14505 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999117.4959 | 2111218.7139 | 37.7769526647296 | -122.44658418923201 | (37.7769526647296, -122.446584189232) | |||
| 6141 | 6141 | 52814 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2760 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2006 12:00:00 AM | 7 | 3x3 | Permit Number 48840 | 6000107.62416 | 2118092.47214 | 37.795882726364496 | -122.44365296252701 | (37.7958827263645, -122.443652962527) | |
| 6158 | 6158 | 111117 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5997427.9716 | 2109844.5838 | 37.7730830093731 | -122.452329562425 | (37.7730830093731, -122.452329562425) | |||
| 6183 | 6183 | 53961 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2456 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 14 | 3x3 | Permit Number 9676 | 6002263.92073 | 2116681.1159200002 | 37.7921302538612 | -122.436090735194 | (37.7921302538612, -122.436090735194) | |
| 6275 | 6275 | 94965 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3098 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2010 12:00:00 AM | 16 | 4x9 | 5999357.80905 | 2116682.46141 | 37.7919684172533 | -122.446145981273 | (37.7919684172533, -122.446145981273) | ||
| 6442 | 6442 | 18493 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 45 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6010362.59726 | 2113973.56841 | 37.785152750446 | -122.407878058349 | (37.785152750446, -122.407878058349) | |||
| 6488 | 6488 | 6051 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1900 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1993 12:00:00 AM | 6 | 3X3 | 6001294.8172 | 2112514.6155 | 37.780635010552395 | -122.439145085226 | (37.7806350105524, -122.439145085226) | ||
| 6596 | 6596 | 84828 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2680 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2011 12:00:00 AM | 3 | 3x3 | Permit Number 53660 | 5999419.5799 | 2113641.8213 | 37.783623142966 | -122.445713490833 | (37.783623142966, -122.445713490833) |
| 6634 | 6634 | 2698 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2117 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003253.6657 | 2114814.1027 | 37.78706009082521 | -122.432532790607 | (37.7870600908252, -122.432532790607) | |||
| 6674 | 6674 | 5302 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6001111.6921 | 2113998.3714 | 37.7846986031206 | -122.439885016276 | (37.7846986031206, -122.439885016276) | |||
| 6690 | 6690 | 2830 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6008514.679409999 | 2116307.39052 | 37.791457230925396 | -122.41443649656401 | (37.7914572309254, -122.414436496564) | |||
| 6730 | 6730 | 2692 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2105 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6003365.8837 | 2114830.7276 | 37.7871121015843 | -122.432145729207 | (37.7871121015843, -122.432145729207) | |||
| 6754 | 6754 | 8718 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3145 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5997330.7134 | 2112954.0563 | 37.781615237280704 | -122.45289047303899 | (37.7816152372807, -122.452890473039) | |||
| 6805 | 6805 | 106911 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3536 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773298 | 5997340.42216 | 2116075.24554 | 37.7901857514154 | -122.45308226334998 | (37.7901857514154, -122.45308226335) | |
| 6825 | 6825 | 35207 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 6835 | 6835 | 35197 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 7167 | 7167 | 35203 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 7215 | 7215 | 2700 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2119 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003220.8778 | 2114813.1791 | 37.7870556954708 | -122.432646163369 | (37.7870556954708, -122.432646163369) | |||
| 7218 | 7218 | 8719 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3145 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997342.5582 | 2112956.0868 | 37.7816214912599 | -122.452849642485 | (37.7816214912599, -122.452849642485) | |||
| 7314 | 7314 | 8694 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3001 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997791.3055 | 2113016.6643 | 37.7818135259457 | -122.451301568097 | (37.7818135259457, -122.451301568097) | |||
| 7402 | 7402 | 8711 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3120 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997427.3329 | 2113071.9963 | 37.7819446058243 | -122.45256473134701 | (37.7819446058243, -122.452564731347) | |||
| 7420 | 7420 | 24657 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3030 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5997669.9813 | 2113103.8079 | 37.7820458518086 | -122.451727579321 | (37.7820458518086, -122.451727579321) |
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");