Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||
| 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 | ||||||||
| 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 | |||||||||
| 19427 | 19427 | 51055 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 640 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | Permit Number 47524 | 5991199.18695168 | 2100466.01651136 | 37.746973143605 | -122.47319139748001 | (37.746973143605, -122.47319139748) | |||
| 19752 | 19752 | 38951 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Urbano Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | ||
| 23692 | 23692 | 71227 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099845.9848 | 37.7450642803204 | -122.48543517398599 | (37.7450642803204, -122.485435173986) | ||
| 25716 | 25716 | 135893 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 323 Marina Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6001843.597519999 | 2121830.48703 | 37.806245186226505 | -122.437914052191 | (37.8062451862265, -122.437914052191) | ||||
| 30525 | 30525 | 36338 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 47 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39302 | 5995626.1352497 | 2092908.66266202 | 37.7264778306363 | -122.45733685578699 | (37.7264778306363, -122.457336855787) | ||
| 37561 | 37561 | 135901 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008342.534990001 | 2119419.33537 | 37.7999921901354 | -122.415252502723 | (37.7999921901354, -122.415252502723) | ||||
| 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) | ||
| 53597 | 53597 | 42437 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 550 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.45323030571801 | (37.7285785035344, -122.453230305718) | ||
| 56224 | 56224 | 50964 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 120 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 4 | Permit Number 47459 | 5996570.7873 | 2113602.9801 | 37.783353433045995 | -122.455566358041 | (37.783353433046, -122.455566358041) | ||
| 58952 | 58952 | 36362 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 136 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39316 | 5995674.40918334 | 2093601.67196771 | 37.7283834402433 | -122.45722008615101 | (37.7283834402433, -122.457220086151) | ||
| 61486 | 61486 | 34637 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1466 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38317 | 5988079.0097 | 2105334.7239 | 37.7601601497095 | -122.484337584053 | (37.7601601497095, -122.484337584053) | ||
| 61537 | 61537 | 71798 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2126 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 1 | 5997657.8233 | 2109919.8494 | 37.7733028345136 | -122.451539910128 | (37.7733028345136, -122.451539910128) | ||
| 71730 | 71730 | 31304 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005195.9419 | 2111461.818 | 37.7779654957454 | -122.425574267643 | (37.7779654957454, -122.425574267643) | |
| 74143 | 74143 | 50554 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2231 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | 3 | Permit Number 47178 | 5988525.9734 | 2100109.7092 | 37.7458396735364 | -122.482408920531 | (37.7458396735364, -122.482408920531) | ||
| 74745 | 74745 | 31301 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 529 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 8 | Permit Number 34944 | 6005236.8177 | 2111465.8481 | 37.7779788709631 | -122.425433150534 | (37.7779788709631, -122.425433150534) | |
| 75915 | 75915 | 46075 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 126 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2001 12:00:00 AM | 4 | Permit Number 44456 | 5996572.8178 | 2113519.7283 | 37.7831249622244 | -122.455553314082 | (37.7831249622244, -122.455553314082) | ||
| 76456 | 76456 | 178908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993776.62184 | 2086766.22044 | 37.7095057557476 | -122.463284972138 | (37.7095057557476, -122.463284972138) | ||||
| 77341 | 77341 | 33704 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 196 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | Permit Number 37772 | 6003356.08500561 | 2108810.32684763 | 37.7705810245056 | -122.431749619478 | (37.7705810245056, -122.431749619478) | ||
| 77792 | 77792 | 44459 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 700 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2001 12:00:00 AM | Permit Number 43780 | 5992847.73856031 | 2102166.91818183 | 37.751738698088296 | -122.46761457722201 | (37.7517386980883, -122.467614577222) | |||
| 77858 | 77858 | 40258 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3502 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 10 | Permit Number 41417 | 6006132.27744777 | 2102027.63127436 | 37.7521143101544 | -122.421664902947 | (37.7521143101544, -122.421664902947) | |
| 78342 | 78342 | 43353 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4184 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | Permit Number 43104 | 6002499.60919335 | 2104164.95121467 | 37.7577773673085 | -122.43437999795 | (37.7577773673085, -122.43437999795) | ||
| 78401 | 78401 | 49775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
| 78556 | 78556 | 40389 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 706 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41499 | 5994916.05908376 | 2092743.92651485 | 37.725984695353105 | -122.459779615207 | (37.7259846953531, -122.459779615207) | ||
| 78985 | 78985 | 42571 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 240 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42653 | 5992105.55983914 | 2095227.71522931 | 37.7326425353626 | -122.469675980927 | (37.7326425353626, -122.469675980927) | |||
| 79040 | 79040 | 84786 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | Permit No. 49308 | 5999615.8 | 2105217.4 | 37.76050301831479 | -122.444429006349 | (37.7605030183148, -122.444429006349) | |||
| 79215 | 79215 | 36343 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 86 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39306 | 5995650.14468705 | 2093191.07979615 | 37.7272546592748 | -122.457274278341 | (37.7272546592748, -122.457274278341) | ||
| 79803 | 79803 | 43861 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2345 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43481 | 5985730.68059538 | 2097009.14058612 | 37.7371633406591 | -122.491846290454 | (37.7371633406591, -122.491846290454) | ||
| 80073 | 80073 | 99924 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 125 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2012 12:00:00 AM | Permit Number 769009 | 5992063.9 | 2092889.6 | 37.7262202448731 | -122.469649855245 | (37.7262202448731, -122.469649855245) | |||
| 80130 | 80130 | 41681 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 48 Mars St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42135 | 5999546.48473392 | 2105510.97552161 | 37.761305148712296 | -122.444689836929 | (37.7613051487123, -122.444689836929) | ||
| 80535 | 80535 | 37888 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1301 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1998 12:00:00 AM | Permit Number 40164 | 5995819.25622169 | 2092686.22988595 | 37.725878173698796 | -122.45665316971001 | (37.7258781736988, -122.45665316971) | |||
| 80826 | 80826 | 36411 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 591 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39333 | 5995339.97501455 | 2093247.68753987 | 37.7273922712597 | -122.45835062173599 | (37.7273922712597, -122.458350621736) | ||
| 81043 | 81043 | 36374 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 154 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39322 | 5995692.70135689 | 2093744.11562313 | 37.72877560678 | -122.457167149483 | (37.72877560678, -122.457167149483) | ||
| 81284 | 81284 | 36372 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 150 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39321 | 5995693.36220348 | 2093704.91985042 | 37.7286680225798 | -122.457162030727 | (37.7286680225798, -122.457162030727) | ||
| 82956 | 82956 | 47713 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
| 84586 | 84586 | 42417 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 273 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42567 | 6000281.10617536 | 2094927.9398224999 | 37.732288562764104 | -122.441389689923 | (37.7322885627641, -122.441389689923) | ||
| 85561 | 85561 | 46331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2002 12:00:00 AM | Permit Number 44582 | 6005568.06039934 | 2110039.04677053 | 37.7740799306106 | -122.42418576450599 | (37.7740799306106, -122.424185764506) | ||
| 86335 | 86335 | 36357 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 130 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39314 | 5995668.43599177 | 2093556.12271173 | 37.728258029890796 | -122.457237441924 | (37.7282580298908, -122.457237441924) | ||
| 86365 | 86365 | 47987 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2359 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2002 12:00:00 AM | Permit Number 45719 | 5991665.05484131 | 2099376.71797109 | 37.7440091733338 | -122.471501121001 | (37.7440091733338, -122.471501121001) | |||
| 87438 | 87438 | 46637 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 670 Victoria St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2002 12:00:00 AM | Permit Number 44768 | 5993413.9529017 | 2091571.4332661 | 37.7226788173129 | -122.46488714503201 | (37.7226788173129, -122.464887145032) | |||
| 87596 | 87596 | 38259 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3153 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40364 | 6007746.96996202 | 2106161.2174207 | 37.763555108568795 | -122.416373793735 | (37.7635551085688, -122.416373793735) | |||
| 87744 | 87744 | 36013 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 97 Winfield St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1998 12:00:00 AM | Permit Number 39160 | 6007176.510261099 | 2098875.10334415 | 37.743517008192796 | -122.41783033575001 | (37.7435170081928, -122.41783033575) | |||
| 88383 | 88383 | 50723 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 495 Wilde Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2004 12:00:00 AM | Permit Number 47274 | 6010067.71310756 | 2089419.28604179 | 37.717715618678206 | -122.40716682601999 | (37.7177156186782, -122.40716682602) | |||
| 88392 | 88392 | 40947 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88209 Hoff St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.76357769940321 | -122.42054143219102 | (37.7635776994032, -122.420541432191) | |||
| 88495 | 88495 | 52095 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600 Rockdale Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2005 12:00:00 AM | Permit Number 48289 | 5997880.65002852 | 2097973.6742378003 | 37.7405143774984 | -122.44990800276699 | (37.7405143774984, -122.449908002767) | |||
| 89206 | 89206 | 41303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1387 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2000 12:00:00 AM | Permit Number 41977 | 6006476.01966821 | 2101521.23564445 | 37.7507432410359 | -122.420440247305 | (37.7507432410359, -122.420440247305) | |||
| 89273 | 89273 | 36428 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 301 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39338 | 5996108.64471019 | 2094137.0690645 | 37.729878441846104 | -122.455757608246 | (37.7298784418461, -122.455757608246) | |||
| 90511 | 90511 | 36385 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
| 90570 | 90570 | 48494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 688 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45836 | 6008651.5358149 | 2098064.55146278 | 37.7413743105027 | -122.412672757895 | (37.7413743105027, -122.412672757895) | |||
| 90596 | 90596 | 36418 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 30 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39336 | 5996667.86779385 | 2094605.95309618 | 37.7311979628573 | -122.45385816718701 | (37.7311979628573, -122.453858167187) | ||
| 90653 | 90653 | 36351 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 112 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39311 | 5995654.83604113 | 2093420.72201256 | 37.727885471049 | -122.45727466612 | (37.727885471049, -122.45727466612) | ||
| 90954 | 90954 | 40399 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41505 | 5995604.87049652 | 2092238.79242045 | 37.7246373060188 | -122.457361926036 | (37.7246373060188, -122.457361926036) | ||
| 91776 | 91776 | 36429 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 435 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | ||
| 91826 | 91826 | 43915 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1333 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43511 | 6010101.91204841 | 2101439.76995795 | 37.750723218416795 | -122.407895793997 | (37.7507232184168, -122.407895793997) | ||
| 92386 | 92386 | 44166 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Sycamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | Permit Number 43637 | 6006615.48283376 | 2105833.54152838 | 37.762591694443294 | -122.420263998944 | (37.7625916944433, -122.420263998944) | |||
| 92816 | 92816 | 48417 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2483 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | Permit Number 45795 | 6001088.95867007 | 2118610.64400879 | 37.7973614105806 | -122.440294547032 | (37.7973614105806, -122.440294547032) | ||
| 92867 | 92867 | 47347 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 752 Head St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45273 | 5993544.85331051 | 2090864.0101395 | 37.7207439512448 | -122.464383317404 | (37.7207439512448, -122.464383317404) | ||
| 93285 | 93285 | 36366 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39318 | 5995680.445182 | 2093645.04501164 | 37.7285028788434 | -122.45720235583299 | (37.7285028788434, -122.457202355833) | ||
| 93419 | 93419 | 49134 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | Permit Number 46261 | 5996360.20601003 | 2094239.45226773 | 37.7301739953755 | -122.454895331277 | (37.7301739953755, -122.454895331277) | |||
| 93452 | 93452 | 46779 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 91 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44870 | 6001525.5890631 | 2092130.31455081 | 37.724677740092 | -122.43688703011601 | (37.724677740092, -122.436887030116) | ||
| 93697 | 93697 | 42997 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 438 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42872 | 6004509.83171755 | 2110011.27832833 | 37.7739438776611 | -122.427844382866 | (37.7739438776611, -122.427844382866) | ||
| 94521 | 94521 | 40418 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 151 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/2003 12:00:00 AM | Permit Number 46528 | 5996223.22474594 | 2094448.33281394 | 37.7307396723187 | -122.455383980912 | (37.7307396723187, -122.455383980912) | ||
| 94593 | 94593 | 41878 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89 Belcher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42255 | 6003837.78738221 | 2107818.63847884 | 37.7678853828634 | -122.43001265375099 | (37.7678853828634, -122.430012653751) | ||
| 94605 | 94605 | 37878 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 591 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40158 | 5996748.50508252 | 2094082.2355121998 | 37.7297645826714 | -122.45354159093701 | (37.7297645826714, -122.453541590937) | ||
| 94705 | 94705 | 39015 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 979 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1998 12:00:00 AM | Permit Number 40771 | 6009183.08861003 | 2103470.3574564 | 37.756247272923005 | -122.41121660125201 | (37.756247272923, -122.411216601252) | |||
| 95071 | 95071 | 46636 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 191 Corona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44761 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
| 95446 | 95446 | 47355 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 375 Ralston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45280 | 5992186.942845901 | 2090329.99196799 | 37.7191993003756 | -122.46903830903099 | (37.7191993003756, -122.469038309031) | ||
| 95548 | 95548 | 53021 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 96@ 9TH AVE Sotelo Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | Permit Number 49000 | 5993602.62440104 | 2101416.64083644 | 37.7497221845739 | -122.464949618251 | (37.7497221845739, -122.464949618251) | |||
| 95706 | 95706 | 50751 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 159 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2004 12:00:00 AM | Permit Number 47292 | 5996528.05046834 | 2113286.09690266 | 37.7824809034135 | -122.45569129682801 | (37.7824809034135, -122.455691296828) | |||
| 95761 | 95761 | 34097 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37974 | 5995414.643408099 | 2093328.34737639 | 37.727618034343706 | -122.45809832977899 | (37.7276180343437, -122.458098329779) | |||
| 97005 | 97005 | 42206 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Decatur St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42477 | 6010764.11568001 | 2109415.80056324 | 37.772660655142005 | -122.40616769997101 | (37.772660655142, -122.406167699971) | |||
| 97505 | 97505 | 37287 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 699 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39818 | 6002432.10165251 | 2104152.77929012 | 37.757740114019 | -122.434612596377 | (37.757740114019, -122.434612596377) | |||
| 97903 | 97903 | 40465 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 388 Moultrie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41550 | 6007680.50464322 | 2097286.4495349 | 37.739183267142 | -122.415975165679 | (37.739183267142, -122.415975165679) | ||
| 98215 | 98215 | 42395 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 531 Gennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42554 | 5997433.46765796 | 2095082.84468997 | 37.732551258555105 | -122.451245745641 | (37.7325512585551, -122.451245745641) | ||
| 98376 | 98376 | 36381 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 169 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39325 | 5995613.8697915 | 2093829.77764032 | 37.729006286331796 | -122.457445868582 | (37.7290062863318, -122.457445868582) | ||
| 98400 | 98400 | 39755 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 183 Hancock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41121 | 6003118.27900273 | 2105026.07032459 | 37.7601768917443 | -122.432301882241 | (37.7601768917443, -122.432301882241) | ||
| 98555 | 98555 | 42815 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42760 | 6001684.72316119 | 2105247.9392865 | 37.760704701255 | -122.437275750105 | (37.760704701255, -122.437275750105) | ||
| 98796 | 98796 | 32922 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1392 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37251 | 5993527.89393066 | 2105989.81652966 | 37.7622746341272 | -122.465540224747 | (37.7622746341272, -122.465540224747) | ||
| 98840 | 98840 | 42078 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 Norwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | ||
| 99037 | 99037 | 40421 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 159 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41519 | 5996206.73591336 | 2094479.35177124 | 37.7308238967874 | -122.455443226068 | (37.7308238967874, -122.455443226068) | ||
| 99267 | 99267 | 30767 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1595 Underwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34647 | 6014606.20359025 | 2093675.42749231 | 37.729655084274995 | -122.39177660646999 | (37.729655084275, -122.39177660647) | ||
| 99511 | 99511 | 37265 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 100030 | 100030 | 42586 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 365 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42663 | 5992564.23479625 | 2094368.49404708 | 37.73030982758711 | -122.46802776610001 | (37.7303098275871, -122.4680277661) | ||
| 100407 | 100407 | 39165 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 650 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40829 | 6003647.87828687 | 2104486.94245858 | 37.758726590030896 | -122.430431782557 | (37.7587265900309, -122.430431782557) | ||
| 100670 | 100670 | 40531 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 130 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | Permit Number 41582 | 5993353.73347688 | 2094704.41991722 | 37.7312777588569 | -122.46532277558998 | (37.7312777588569, -122.46532277559) | |||
| 100790 | 100790 | 43005 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 205X Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | |||
| 101942 | 101942 | 45066 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2101 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2001 12:00:00 AM | Permit Number 43947 | 5987870.53797958 | 2100985.88306806 | 37.748207264307496 | -122.484739557427 | (37.7482072643075, -122.484739557427) | |||
| 102019 | 102019 | 39162 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 301x Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40829 | 6003629.0 | 2104450.0 | 37.758624085440104 | -122.43049443639099 | (37.7586240854401, -122.430494436391) | ||
| 103115 | 103115 | 36727 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 40 San Carlos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39510 | 6006611.80409232 | 2105730.31374512 | 37.7623080478131 | -122.420269395525 | (37.7623080478131, -122.420269395525) | ||
| 103451 | 103451 | 45442 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 681 Victoria St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44769 | 5993403.20841917 | 2091649.07320251 | 37.7228913782095 | -122.464929921893 | (37.7228913782095, -122.464929921893) | ||
| 104488 | 104488 | 45135 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1155 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2001 12:00:00 AM | Permit Number 43992 | 6001042.61306002 | 2109303.63872684 | 37.771804125001395 | -122.439787297823 | (37.7718041250014, -122.439787297823) | |||
| 105105 | 105105 | 39072 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2280X Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | |||
| 105752 | 105752 | 42035 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42358 | 6004596.89230657 | 2098983.86286022 | 37.7436701266667 | -122.42675775960501 | (37.7436701266667, -122.426757759605) | ||
| 106520 | 106520 | 37296 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 286 Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39824 | 6003747.0165405 | 2104527.26651018 | 37.758842925599396 | -122.430091793701 | (37.7588429255994, -122.430091793701) | ||
| 107407 | 107407 | 42076 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009273.0 | 2099431.0 | 37.7451611391058 | -122.41062041564501 | (37.7451611391058, -122.410620415645) | ||
| 107559 | 107559 | 50548 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
| 107822 | 107822 | 34377 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 192 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/1997 12:00:00 AM | Permit Number 38132 | 6004119.49989193 | 2097245.26729923 | 37.7388693385577 | -122.428284582088 | (37.7388693385577, -122.428284582088) | ||
| 108194 | 108194 | 35802 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 14 San Carlos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39047 | 6006607.12715637 | 2105811.74016352 | 37.762531362168296 | -122.420291350836 | (37.7625313621683, -122.420291350836) |
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");