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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82128 | 82128 | 39988 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 702 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | Permit Number 41246 | 6020313.39222717 | 2093680.55714076 | 37.729984337867705 | -122.37204636190701 | (37.7299843378677, -122.372046361907) | ||
| 53060 | 53060 | 39989 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 710 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 12 | Permit Number 41247 | 6020263.29136 | 2093725.43573 | 37.73010481357829 | -122.372222673141 | (37.7301048135783, -122.372222673141) | |
| 73500 | 73500 | 39990 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 714 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41248 | 6020251.6051199995 | 2093735.0931099998 | 37.730130688869295 | -122.372263742486 | (37.7301306888693, -122.372263742486) | |
| 51306 | 51306 | 39991 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 724 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41249 | 6020211.31416 | 2093764.16933 | 37.730208312959995 | -122.372405046655 | (37.73020831296, -122.372405046655) | |
| 181388 | 181388 | 39992 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 744 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41250 | 6020175.81777 | 2093790.38567 | 37.7302783476475 | -122.372529577584 | (37.7302783476475, -122.372529577584) | |
| 132075 | 132075 | 39994 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 863 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2005 12:00:00 AM | 12 | 3x3 | Permit Number 41252 | 6019434.68731 | 2094262.5096 | 37.731533957726796 | -122.375124503897 | (37.7315339577268, -122.375124503897) |
| 131343 | 131343 | 39995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 869 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2004 12:00:00 AM | 6 | 3x3 | Permit Number 47551 | 6019405.77873 | 2094282.05396 | 37.7315860320638 | -122.375225801726 | (37.7315860320638, -122.375225801726) |
| 166526 | 166526 | 39997 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 871 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41255 | 6019390.137999999 | 2094293.5520799998 | 37.731616743009795 | -122.375280672083 | (37.7316167430098, -122.375280672083) | |
| 163542 | 163542 | 40000 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 14 | Permit Number 41257 | 6019376.91864 | 2094304.0292599997 | 37.7316447838739 | -122.375327100491 | (37.7316447838739, -122.375327100491) | |
| 167480 | 167480 | 40003 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019368.47353 | 2094309.06128 | 37.7316581360927 | -122.375356645916 | (37.7316581360927, -122.375356645916) | |
| 176782 | 176782 | 40001 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 12 | Permit Number 41257 | 6019355.96693 | 2094318.55144 | 37.7316835059849 | -122.375400541805 | (37.7316835059849, -122.375400541805) | |
| 151822 | 151822 | 39999 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 13 | Permit Number 41257 | 6019347.79521 | 2094325.03679 | 37.731700863794295 | -122.37542924278799 | (37.7317008637943, -122.375429242788) | |
| 168045 | 168045 | 40002 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019340.13593 | 2094332.72798 | 37.731721560802 | -122.375456255711 | (37.731721560802, -122.375456255711) | |
| 29494 | 29494 | 84619 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 895 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767653 | 6019276.35845 | 2094378.9880400002 | 37.7318450718732 | -122.37567995576799 | (37.7318450718732, -122.375679955768) |
| 120515 | 120515 | 40005 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 911 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41258 | 6019178.20708985 | 2094459.30382263 | 37.7320602007089 | -122.376024856319 | (37.7320602007089, -122.376024856319) | ||
| 122101 | 122101 | 39993 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 860 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | Permit Number 41251 | 6019175.31340513 | 2094526.32452806 | 37.73224406729229 | -122.376039506051 | (37.7322440672923, -122.376039506051) | ||
| 76012 | 76012 | 97025 | Property Tree 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 78805 | 78805 | 97021 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 81165 | 81165 | 97014 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 81341 | 81341 | 97022 | Property Tree 7 | Umbellularia californica :: California Bay 195 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 82893 | 82893 | 97042 | Property Tree 7 | Heteromeles arbutifolia :: Toyon 322 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 85013 | 85013 | 97015 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 87538 | 87538 | 97027 | Property Tree 7 | Myoporum laetum :: Myoporum 1 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 88802 | 88802 | 97029 | Property Tree 7 | Rhamnus californica :: Coffeeberry Tree 232 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 90248 | 90248 | 97040 | Property Tree 7 | Hakea suaveolens :: Sweet Hakea Tree 14 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 92954 | 92954 | 97034 | Property Tree 7 | :: 54 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 94845 | 94845 | 97016 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 99914 | 99914 | 97028 | Property Tree 7 | Morus alba :: White Mulberry 112 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 104476 | 104476 | 97043 | Property Tree 7 | Heteromeles arbutifolia :: Toyon 322 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 104783 | 104783 | 96999 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195A Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 107550 | 107550 | 97032 | Property Tree 7 | Griselinia lucida :: Griselinia 477 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 125485 | 125485 | 97041 | Property Tree 7 | Hakea suaveolens :: Sweet Hakea Tree 14 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 125835 | 125835 | 97004 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195A Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 127473 | 127473 | 97045 | Property Tree 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 128784 | 128784 | 97039 | Property Tree 7 | Hakea suaveolens :: Sweet Hakea Tree 14 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 140389 | 140389 | 97037 | Property Tree 7 | Griselinia lucida :: Griselinia 477 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 140586 | 140586 | 97044 | Property Tree 7 | Heteromeles arbutifolia :: Toyon 322 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 140629 | 140629 | 97038 | Property Tree 7 | Hakea suaveolens :: Sweet Hakea Tree 14 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 142369 | 142369 | 97035 | Property Tree 7 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 145213 | 145213 | 97026 | Property Tree 7 | Tilia cordata :: Littleleaf Linden 208 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 145522 | 145522 | 97036 | Property Tree 7 | Griselinia lucida :: Griselinia 477 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 86628 | 86628 | 39996 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 870 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41254 | 6019158.47829216 | 2094538.87688533 | 37.7322776068337 | -122.376098579608 | (37.7322776068337, -122.376098579608) | ||
| 117097 | 117097 | 39998 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 880 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41256 | 6019141.64317919 | 2094551.4292426002 | 37.732311146345296 | -122.376157653218 | (37.7323111463453, -122.376157653218) | ||
| 183664 | 183664 | 40006 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 930 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 12 | Permit Number 41259 | 6019126.39744 | 2094573.6221900003 | 37.7323712445238 | -122.376211900284 | (37.7323712445238, -122.376211900284) | |
| 160223 | 160223 | 40004 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 911 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 2 | Permit Number 41258 | 6019111.21169 | 2094496.3329 | 37.7321581870346 | -122.376259043617 | (37.7321581870346, -122.376259043617) | |
| 25972 | 25972 | 40007 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 939 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 19 | Permit Number 41260 | 6019022.80772 | 2094568.6170400002 | 37.7323517975898 | -122.37656969105 | (37.7323517975898, -122.37656969105) | |
| 167372 | 167372 | 40008 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 950 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 8 | Permit Number 41261 | 6018990.20826 | 2094681.6711099998 | 37.7326604269313 | -122.376690235261 | (37.7326604269313, -122.376690235261) | |
| 176927 | 176927 | 40009 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 963 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 5 | Permit Number 41262 | 6018899.57505 | 2094657.4041900001 | 37.732588803110204 | -122.377001897143 | (37.7325888031102, -122.377001897143) | |
| 59414 | 59414 | 83045 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 2 | 6018793.96585 | 2097631.53768 | 37.7407493718785 | -122.377573338964 | (37.7407493718785, -122.377573338964) | ||
| 173934 | 173934 | 83044 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 2 | 6018777.54715 | 2097643.31156 | 37.740780796002895 | -122.377630926146 | (37.7407807960029, -122.377630926146) | ||
| 33396 | 33396 | 52147 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 991 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 3 | Permit Number 48338 | 6018752.39982 | 2094769.7701 | 37.7328892306529 | -122.377518518074 | (37.7328892306529, -122.377518518074) | |
| 13616 | 13616 | 83038 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | |||
| 93206 | 93206 | 38450 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 951 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | ||
| 108500 | 108500 | 38452 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 951 Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | ||
| 142817 | 142817 | 38449 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 951 Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | ||
| 143689 | 143689 | 38451 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 951 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40470 | 6018291.77768285 | 2092676.14004217 | 37.7271151411395 | -122.378965676914 | (37.7271151411395, -122.378965676914) | ||
| 77781 | 77781 | 40025 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 201 Middle Point Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41269 | 6018237.888375901 | 2095348.52577329 | 37.7344500201686 | -122.37933752244801 | (37.7344500201686, -122.379337522448) | ||
| 86329 | 86329 | 38453 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 991 Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.727463804070396 | -122.379579913535 | (37.7274638040704, -122.379579913535) | ||
| 110769 | 110769 | 38456 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 991 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.727463804070396 | -122.379579913535 | (37.7274638040704, -122.379579913535) | ||
| 116083 | 116083 | 38454 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 991 Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.727463804070396 | -122.379579913535 | (37.7274638040704, -122.379579913535) | ||
| 123151 | 123151 | 38455 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 991 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40471 | 6018116.72112672 | 2092806.63595359 | 37.727463804070396 | -122.379579913535 | (37.7274638040704, -122.379579913535) | ||
| 42951 | 42951 | 74588 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1335 Griffith St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 7 | 6017904.0953 | 2092578.1569 | 37.7268247152753 | -122.380299097717 | (37.7268247152753, -122.380299097717) | ||
| 76962 | 76962 | 74742 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1335 Griffith St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 9 | 6017895.1835 | 2092564.7892 | 37.7267875184409 | -122.38032897727501 | (37.7267875184409, -122.380328977275) | ||
| 32408 | 32408 | 49732 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1300@ REVERE Griffith St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46533 | 6017891.63282432 | 2092647.03396297 | 37.727013150708 | -122.380346965446 | (37.727013150708, -122.380346965446) | ||
| 88706 | 88706 | 49725 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1300@ REVERE Griffith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46533 | 6017891.63282432 | 2092647.03396297 | 37.727013150708 | -122.380346965446 | (37.727013150708, -122.380346965446) | ||
| 114093 | 114093 | 49727 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1300@ REVERE Griffith St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46533 | 6017891.63282432 | 2092647.03396297 | 37.727013150708 | -122.380346965446 | (37.727013150708, -122.380346965446) | ||
| 129352 | 129352 | 49723 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1300@ REVERE Griffith St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46533 | 6017891.63282432 | 2092647.03396297 | 37.727013150708 | -122.380346965446 | (37.727013150708, -122.380346965446) | ||
| 47363 | 47363 | 74888 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1335 Griffith St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 7 | 6017884.362000001 | 2092550.785 | 37.7267484685203 | -122.380365414433 | (37.7267484685203, -122.380365414433) | ||
| 159277 | 159277 | 75024 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1335 Griffith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 6 | 6017873.5405 | 2092533.5979 | 37.72670067896139 | -122.380401630434 | (37.7267006789614, -122.380401630434) | ||
| 33484 | 33484 | 75118 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1335 Griffith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 9 | 6017861.446 | 2092515.1377 | 37.7266493234609 | -122.38044215870701 | (37.7266493234609, -122.380442158707) | ||
| 33254 | 33254 | 75201 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1335 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 3 | 6017848.7148 | 2092502.4066 | 37.726613663810795 | -122.380485286019 | (37.7266136638108, -122.380485286019) | ||
| 176691 | 176691 | 75284 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1335 Griffith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 3 | 6017835.3471 | 2092484.583 | 37.7265639860027 | -122.380530259866 | (37.7265639860027, -122.380530259866) | ||
| 88302 | 88302 | 38460 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1115 Quesada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | ||
| 106201 | 106201 | 38457 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1115 Quesada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | ||
| 111479 | 111479 | 38461 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1115 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | ||
| 126202 | 126202 | 38458 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1115 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | ||
| 138638 | 138638 | 38459 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1115 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | ||
| 183453 | 183453 | 75364 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1335 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 4 | 6017823.2525 | 2092467.3959 | 37.7265161261373 | -122.38057087677299 | (37.7265161261373, -122.380570876773) | ||
| 54594 | 54594 | 75439 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1335 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 8 | 6017811.7945 | 2092449.5723 | 37.7264665536825 | -122.380609248682 | (37.7264665536825, -122.380609248682) | ||
| 77624 | 77624 | 38448 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1401 Griffith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | ||
| 88152 | 88152 | 38445 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1401 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | ||
| 95746 | 95746 | 38446 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1401 Griffith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | ||
| 100560 | 100560 | 38447 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1401 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | ||
| 144938 | 144938 | 38444 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1401 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1998 12:00:00 AM | Permit Number 40469 | 6017766.83622374 | 2092391.04442296 | 37.7263033663533 | -122.380760602423 | (37.7263033663533, -122.380760602423) | ||
| 85656 | 85656 | 38467 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.38080993565399 | (37.7264471943371, -122.380809935654) | ||
| 89980 | 89980 | 38465 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100 Revere Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.38080993565399 | (37.7264471943371, -122.380809935654) | ||
| 109695 | 109695 | 38466 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.38080993565399 | (37.7264471943371, -122.380809935654) | ||
| 117719 | 117719 | 38469 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.38080993565399 | (37.7264471943371, -122.380809935654) | ||
| 126797 | 126797 | 38468 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.38080993565399 | (37.7264471943371, -122.380809935654) | ||
| 71513 | 71513 | 38473 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 98938 | 98938 | 38474 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 101554 | 101554 | 38472 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 116469 | 116469 | 38470 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101 Shafter Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 122369 | 122369 | 38471 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 31224 | 31224 | 60350 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1101 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 4 | Permit Number 19928 | 6017464.7861 | 2093286.0419 | 37.72874418038629 | -122.381867009636 | (37.7287441803863, -122.381867009636) | |
| 96516 | 96516 | 59851 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1119 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1981 12:00:00 AM | Permit Number 19307 | 6017428.44424481 | 2093319.71178593 | 37.7288346243781 | -122.381994988143 | (37.7288346243781, -122.381994988143) | ||
| 15279 | 15279 | 59852 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1123 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1981 12:00:00 AM | 18 | 4x4 | Permit Number 19308 | 6017402.1303 | 2093334.4078 | 37.728873523519894 | -122.382086980049 | (37.7288735235199, -122.382086980049) |
| 36876 | 36876 | 60351 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1151 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 13 | Permit Number 19929 | 6017264.1776 | 2093436.6356 | 37.729146601168296 | -122.382571007193 | (37.7291466011683, -122.382571007193) | |
| 14339 | 14339 | 59853 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1167 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 19309 | 6017186.1327 | 2093497.6426 | 37.7293098027153 | -122.382845061392 | (37.7293098027153, -122.382845061392) |
| 90798 | 90798 | 60352 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1171 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | Permit Number 19930 | 6017163.09585765 | 2093517.51572031 | 37.729363097577206 | -122.382926085128 | (37.7293630975772, -122.382926085128) |
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");