Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2489 | 2489 | 119760 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2492 | 2492 | 119762 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2508 | 2508 | 119759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 3013 | 3013 | 39333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 5373 | 5373 | 31852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 5518 | 5518 | 39334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 6740 | 6740 | 39332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 11785 | 11785 | 31851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 11986 | 11986 | 31849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 14197 | 14197 | 39331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 15875 | 15875 | 31850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 15956 | 15956 | 31845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 44810 | 44810 | 53918 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 85021 | 85021 | 33758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 842 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | Permit Number 37811 | 5981102.7142707 | 2109980.14676383 | 37.77250644827279 | -122.508809756644 | (37.7725064482728, -122.508809756644) | |||
| 32419 | 32419 | 89550 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 5539 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5981409.7822199995 | 2111623.31383 | 37.7770361978186 | -122.50786956100401 | (37.7770361978186, -122.507869561004) | ||
| 135919 | 135919 | 85241 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4331 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2007 12:00:00 AM | 1 | Permit Number 49544 | 5981367.2124 | 2104841.304 | 37.7584122600662 | -122.507513483633 | (37.7584122600662, -122.507513483633) | ||
| 162332 | 162332 | 85242 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4331 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2007 12:00:00 AM | 1 | Permit Number 49544 | 5981385.546 | 2104841.9152 | 37.7584150182243 | -122.507450124372 | (37.7584150182243, -122.507450124372) | ||
| 62539 | 62539 | 183257 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981497.12 | 2105917.3408 | 37.7613744008584 | -122.50714403834999 | (37.7613744008584, -122.50714403835) | |||
| 45174 | 45174 | 184179 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1607 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981558.7987 | 2104123.9871 | 37.7564539963073 | -122.50679770031401 | (37.7564539963073, -122.506797700314) | |||
| 177635 | 177635 | 118425 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981790.15899 | 2111638.01027 | 37.7770989536906 | -122.506554832582 | (37.7770989536906, -122.506554832582) | |||
| 189051 | 189051 | 118424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5981802.00316 | 2111639.4369 | 37.7771035681701 | -122.50651396642 | (37.7771035681701, -122.50651396642) | |||
| 56421 | 56421 | 118423 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981811.815769999 | 2111640.57092 | 37.7771072596016 | -122.50648010623001 | (37.7771072596016, -122.50648010623) | |||
| 68693 | 68693 | 118431 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5981816.64658 | 2111695.18358 | 37.7772574943259 | -122.506467446284 | (37.7772574943259, -122.506467446284) | |||
| 170362 | 170362 | 118429 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5981844.98436 | 2111695.06236 | 37.7772588298958 | -122.50636940951 | (37.7772588298958, -122.50636940951) | |||
| 43146 | 43146 | 118427 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5981873.51616 | 2111696.39703 | 37.7772641742522 | -122.506270809551 | (37.7772641742522, -122.506270809551) | |||
| 111879 | 111879 | 68559 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 511 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32449 | 5981895.88613984 | 2112278.88841287 | 37.778864841011796 | -122.50623662905001 | (37.7788648410118, -122.50623662905) | ||
| 100869 | 100869 | 68558 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 508 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32448 | 5981947.34598034 | 2112294.26948127 | 37.7789101022126 | -122.50605975288799 | (37.7789101022126, -122.506059752888) | ||
| 157734 | 157734 | 46392 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2474 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 1 | Permit Number 44624 | 5982733.0582 | 2098295.9927 | 37.7405210225717 | -122.502305471655 | (37.7405210225717, -122.502305471655) | |
| 109056 | 109056 | 51769 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982925.7859 | 2104266.232 | 37.7569249636711 | -122.50208077934201 | (37.7569249636711, -122.502080779342) |
| 40255 | 40255 | 51768 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982945.3427 | 2104265.0097 | 37.756922756494106 | -122.50201305526699 | (37.7569227564941, -122.502013055267) |
| 186101 | 186101 | 51766 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 1 | Permit Number 48032 | 5982963.9827 | 2104265.9264 | 37.7569263685127 | -122.50194866004801 | (37.7569263685127, -122.501948660048) | ||
| 167545 | 167545 | 51767 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 1 | Permit Number 48032 | 5982982.0116 | 2104266.5376 | 37.756929105781495 | -122.501886355597 | (37.7569291057815, -122.501886355597) | ||
| 136211 | 136211 | 183297 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1279 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5983033.5705 | 2106401.2294 | 37.762793394201005 | -122.501865989484 | (37.762793394201, -122.501865989484) | |||
| 60980 | 60980 | 70441 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2443 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 2 | 5982992.9824 | 2098498.3633 | 37.741091945342795 | -122.501421735716 | (37.7410919453428, -122.501421735716) | ||
| 51315 | 51315 | 34818 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 443 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38451 | 5983428.96299375 | 2112819.28622042 | 37.780438749009704 | -122.500973171264 | (37.7804387490097, -122.500973171264) | ||
| 139180 | 139180 | 34817 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 443 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38451 | 5983428.96299375 | 2112819.28622042 | 37.780438749009704 | -122.500973171264 | (37.7804387490097, -122.500973171264) | ||
| 76643 | 76643 | 184445 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2143 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983233.2456 | 2100550.728 | 37.746741282577894 | -122.500742738194 | (37.7467412825779, -122.500742738194) | |||
| 25201 | 25201 | 183343 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1220 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983371.791 | 2106830.4783 | 37.7639918518381 | -122.500727966306 | (37.7639918518381, -122.500727966306) | |||
| 24630 | 24630 | 184291 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1543 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5983404.3155 | 2104639.3384 | 37.7579775103532 | -122.50045345703501 | (37.7579775103532, -122.500453457035) | |||
| 149853 | 149853 | 53802 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1758 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1972 12:00:00 AM | 1 | Permit Number 9494 | 5983498.0607 | 2103182.1267 | 37.7539819174643 | -122.500021533616 | (37.7539819174643, -122.500021533616) | ||
| 178771 | 178771 | 184275 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1535 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983712.9456 | 2104682.7299 | 37.7581147632448 | -122.499389306755 | (37.7581147632448, -122.499389306755) | |||
| 171595 | 171595 | 184311 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1563 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983718.446 | 2104512.8306 | 37.757648590113604 | -122.49935772939301 | (37.7576485901136, -122.499357729393) | |||
| 164030 | 164030 | 184601 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1763 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983763.5526 | 2103165.7132 | 37.753952428223 | -122.49910220128099 | (37.753952428223, -122.499102201281) | |||
| 123530 | 123530 | 88091 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51095 | 5984024.3 | 2104125.3 | 37.756602478656 | -122.498271356488 | (37.756602478656, -122.498271356488) | |||
| 188640 | 188640 | 184708 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984043.3081 | 2104133.2508 | 37.7566254238897 | -122.498206207845 | (37.7566254238897, -122.498206207845) | |||
| 51735 | 51735 | 88092 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51095 | 5984042.9711 | 2104115.7287 | 37.756577293333294 | -122.49820607925 | (37.7565772933333, -122.49820607925) | |
| 136125 | 136125 | 183176 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2446 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983967.9959 | 2098507.985 | 37.7411755776416 | -122.498051254673 | (37.7411755776416, -122.498051254673) | |||
| 135632 | 135632 | 183177 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2450 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983968.3342 | 2098473.4815 | 37.741080860242896 | -122.498047537544 | (37.7410808602429, -122.498047537544) | |||
| 178235 | 178235 | 51494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1767 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2005 12:00:00 AM | 1 | Permit Number 47806 | 5984074.2238 | 2103158.268 | 37.7539502052222 | -122.498027293704 | (37.7539502052222, -122.498027293704) | ||
| 157753 | 157753 | 184578 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1726 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984111.7886 | 2103392.1174 | 37.7545944930516 | -122.49791465490499 | (37.7545944930516, -122.497914654905) | |||
| 158401 | 158401 | 118027 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 51 Shore View Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5984327.56097 | 2112791.45591 | 37.780415056002205 | -122.49786249135201 | (37.7804150560022, -122.497862491352) | |||
| 85137 | 85137 | 88093 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1726 39th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51097 | 5984135.0 | 2103400.2 | 37.7546180463975 | -122.497834981734 | (37.7546180463975, -122.497834981734) | |||
| 70069 | 70069 | 118023 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 455 37th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5984366.09559 | 2112727.46699 | 37.780241619998 | -122.49772445801202 | (37.780241619998, -122.497724458012) | |||
| 41303 | 41303 | 118024 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 455 37th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5984366.776430001 | 2112718.2833 | 37.7802164441611 | -122.497721424423 | (37.7802164441611, -122.497721424423) | |||
| 72111 | 72111 | 69039 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1465 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 3 | Permit Number 33045 | 5984314.5522 | 2105205.1639 | 37.759584498582896 | -122.497347291362 | (37.7595844985829, -122.497347291362) | |
| 174540 | 174540 | 184306 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1562 38th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5984381.1972 | 2104548.1361 | 37.757784389614 | -122.497068306014 | (37.757784389614, -122.497068306014) | |||
| 45248 | 45248 | 184305 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1562 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5984382.3056 | 2104532.0637 | 37.757740324240295 | -122.497063286444 | (37.7577403242403, -122.497063286444) | |||
| 162516 | 162516 | 69047 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3627 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 1 | Permit Number 33054 | 5984427.5354 | 2106304.0281 | 37.762608292752105 | -122.497037654386 | (37.7626082927521, -122.497037654386) | |
| 82888 | 82888 | 69140 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2639 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33173 | 5984275.37028508 | 2097213.25013079 | 37.737638602389396 | -122.496892944046 | (37.7376386023894, -122.496892944046) | ||
| 55286 | 55286 | 186809 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 118 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984810.136 | 2106955.7691 | 37.7644202036906 | -122.495762474243 | (37.7644202036906, -122.495762474243) | |||
| 68183 | 68183 | 186811 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 116 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.3107 | 2106920.8907 | 37.7643249161453 | -122.495731627712 | (37.7643249161453, -122.495731627712) | |||
| 173050 | 173050 | 186810 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 117 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984819.4006 | 2106939.4198 | 37.7643758556702 | -122.49572922497102 | (37.7643758556702, -122.495729224971) | |||
| 155382 | 155382 | 186813 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 114 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.8556 | 2106897.4567 | 37.7642606048812 | -122.4957280144 | (37.7642606048812, -122.4957280144) | |||
| 95593 | 95593 | 96005 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3448 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2011 12:00:00 AM | 3x3 | Permit Number 767659 | 5984913.0 | 2111119.0 | 37.775857277323105 | -122.495713813843 | (37.7758572773231, -122.495713813843) | ||
| 75257 | 75257 | 186812 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 115 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984824.8504 | 2106905.6313 | 37.764283401100705 | -122.495707883417 | (37.7642834011007, -122.495707883417) | |||
| 186494 | 186494 | 182276 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3150 Kirkham St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985061.2024 | 2105018.6781 | 37.759116193094 | -122.494751291704 | (37.759116193094, -122.494751291704) | |||
| 70235 | 70235 | 79414 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2635 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52810 | 5984897.7294 | 2097238.629 | 37.7377447344094 | -122.49474305383 | (37.7377447344094, -122.49474305383) |
| 51415 | 51415 | 182275 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3150 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985063.5912 | 2105018.8618 | 37.7591168373077 | -122.49474304376001 | (37.7591168373077, -122.49474304376) | |||
| 124447 | 124447 | 32174 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.49433563765699 | (37.7296472241819, -122.494335637657) | ||
| 145196 | 145196 | 32175 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.49433563765699 | (37.7296472241819, -122.494335637657) | ||
| 18086 | 18086 | 32173 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 88347 | 88347 | 32171 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 107326 | 107326 | 32172 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 114564 | 114564 | 32169 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 127685 | 127685 | 32170 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 152743 | 152743 | 182409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1521 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985259.3217 | 2104833.2809 | 37.7586187384667 | -122.494052446724 | (37.7586187384667, -122.494052446724) | |||
| 149345 | 149345 | 92403 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1545 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52803 | 5985264.691000001 | 2104708.4468 | 37.7582762928221 | -122.494024677293 | (37.7582762928221, -122.494024677293) |
| 71523 | 71523 | 92404 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1545 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52803 | 5985265.6119 | 2104693.7127 | 37.7582358909523 | -122.494020406574 | (37.7582358909523, -122.494020406574) |
| 60297 | 60297 | 182224 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1599 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985275.2811 | 2104383.8376 | 37.7573856255252 | -122.493964129886 | (37.7573856255252, -122.493964129886) | |||
| 54613 | 54613 | 43848 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2634 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43470 | 5985245.7192 | 2097273.3217 | 37.7378603541939 | -122.493542458198 | (37.7378603541939, -122.493542458198) | |
| 70310 | 70310 | 43849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2638 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43471 | 5985246.7805 | 2097245.1976 | 37.73778319502121 | -122.49353671716999 | (37.7377831950212, -122.49353671717) | |
| 143293 | 143293 | 43850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2674 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 6 | Permit Number 43472 | 5985253.1482 | 2097047.7977 | 37.7372415601551 | -122.493500160872 | (37.7372415601551, -122.493500160872) | |
| 43063 | 43063 | 185135 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2678 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5985252.6176 | 2097020.7349 | 37.7371672218976 | -122.493500001953 | (37.7371672218976, -122.493500001953) | |||
| 182510 | 182510 | 43851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2678 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 6 | Permit Number 43473 | 5985253.1482 | 2097007.4687 | 37.737130827494504 | -122.49349719028 | (37.7371308274945, -122.49349719028) | |
| 61059 | 61059 | 182221 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2830 Lawton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985427.0921 | 2104352.0968 | 37.7573073554199 | -122.493436776332 | (37.7573073554199, -122.493436776332) | |||
| 77678 | 77678 | 50789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6900 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | ||
| 89242 | 89242 | 50787 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6900 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | |||
| 125717 | 125717 | 50788 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6900 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | |||
| 128771 | 128771 | 102810 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 490 33rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770137 | 5985656.77163 | 2112663.0068900003 | 37.780140206640205 | -122.493254729507 | (37.7801402066402, -122.493254729507) | |
| 104917 | 104917 | 102809 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 490 33rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 33567 | 5985658.04889 | 2112631.72376 | 37.780054386858794 | -122.493248005621 | (37.7800543868588, -122.493248005621) | ||
| 175887 | 175887 | 45626 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2226 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/01/2001 12:00:00 AM | 3 | Permit Number 44336 | 5985467.3253 | 2100031.8294 | 37.745447435936896 | -122.492979406528 | (37.7454474359369, -122.492979406528) | |
| 54310 | 54310 | 182541 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1587 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985582.1491 | 2104435.4669 | 37.7575453355233 | -122.492906676836 | (37.7575453355233, -122.492906676836) | |||
| 172408 | 172408 | 95443 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1634 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767305 | 5985639.2643 | 2104071.5459 | 37.7565494487406 | -122.49268234984 | (37.7565494487406, -122.49268234984) |
| 34748 | 34748 | 43826 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2657 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43454 | 5985520.0574 | 2097206.122 | 37.7376918862353 | -122.49258900314899 | (37.7376918862353, -122.492589003149) | |
| 39935 | 39935 | 43837 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2707 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43459 | 5985531.9387 | 2096872.5005 | 37.736776545221204 | -122.492523362027 | (37.7367765452212, -122.492523362027) | |
| 81224 | 81224 | 43843 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2729 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43465 | 5985530.78244018 | 2096757.50782257 | 37.736460738343204 | -122.49251889363501 | (37.7364607383432, -122.492518893635) | ||
| 33113 | 33113 | 183374 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2725 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985535.6187 | 2096728.138 | 37.736380379394 | -122.492500010635 | (37.736380379394, -122.492500010635) | |||
| 159299 | 159299 | 43835 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2690 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43458 | 5985569.0545 | 2097059.5514 | 37.737292307195396 | -122.492408808668 | (37.7372923071954, -122.492408808668) | |
| 185028 | 185028 | 43836 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2690 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43458 | 5985569.2648 | 2097041.677 | 37.737243241151496 | -122.492406765684 | (37.7372432411515, -122.492406765684) |
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");