Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10369 | 10369 | 83563 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 422 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769753 | 6002333.8721199995 | 2090986.9240400002 | 37.721584152666104 | -122.434011205875 | (37.7215841526661, -122.434011205875) | |
| 11369 | 11369 | 83554 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 117X Peru Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003920.58239 | 2093359.5974299998 | 37.728188908672294 | -122.428695428367 | (37.7281889086723, -122.428695428367) |
| 11687 | 11687 | 83518 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 117X Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003951.4498 | 2093338.17621 | 37.7281318376981 | -122.428587192249 | (37.7281318376981, -122.428587192249) |
| 12350 | 12350 | 83555 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 117X Peru Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003936.8249699995 | 2093347.62291 | 37.7281569485605 | -122.428638423918 | (37.7281569485605, -122.428638423918) |
| 13067 | 13067 | 83533 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 242 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769751 | 6002979.54268 | 2092016.08462 | 37.724446620113 | -122.43185274573099 | (37.724446620113, -122.431852745731) |
| 13749 | 13749 | 68842 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 602 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 5 | 3x3 | Permit Number 767166 | 6014359.28345 | 2104329.14494 | 37.7588942535933 | -122.39337550020399 | (37.7588942535933, -122.393375500204) |
| 23771 | 23771 | 116544 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001586.02621 | 2088182.95127 | 37.713842599620904 | -122.436395723209 | (37.7138425996209, -122.436395723209) | |||
| 28351 | 28351 | 248531 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997658.267999999 | 2107761.8815 | 37.767377634072794 | -122.451382700243 | (37.7673776340728, -122.451382700243) | |||
| 31529 | 31529 | 52954 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 975 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 5 | Permit Number 48941 | 6000767.51384 | 2091342.1163299999 | 37.7224704120511 | -122.43945112037399 | (37.7224704120511, -122.439451120374) | |
| 33778 | 33778 | 52557 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1671 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 5 | Permit Number 48653 | 5984052.4061 | 2103791.5706 | 37.7556877987927 | -122.498149511058 | (37.7556877987927, -122.498149511058) | |
| 34279 | 34279 | 227550 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3957 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003307.61262 | 2104748.70742 | 37.7594260532954 | -122.431627264983 | (37.7594260532954, -122.431627264983) | |||
| 34972 | 34972 | 244513 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 500 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004128.882 | 2109777.8057 | 37.7732812611379 | -122.429145501014 | (37.7732812611379, -122.429145501014) | |||
| 37420 | 37420 | 207024 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997067.34432 | 2090557.5942799998 | 37.7201050223995 | -122.452185117661 | (37.7201050223995, -122.452185117661) | |||
| 37552 | 37552 | 227586 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003707.3650400005 | 2095900.15245 | 37.735152630897495 | -122.42961364516898 | (37.7351526308975, -122.429613645169) | |||
| 38046 | 38046 | 227115 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 587 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007890.87999 | 2104550.47449 | 37.75914047177721 | -122.415761992927 | (37.7591404717772, -122.415761992927) | |||
| 38399 | 38399 | 129386 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 929 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009490.7484 | 2116033.66261 | 37.7907604245028 | -122.411039958651 | (37.7907604245028, -122.411039958651) | |||
| 39062 | 39062 | 88481 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014818.59944 | 2096228.0421 | 37.7366758342199 | -122.391220684988 | (37.7366758342199, -122.391220684988) | |
| 40740 | 40740 | 129388 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2507 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006666.99925 | 2119949.9372900003 | 37.8013547799481 | -122.421088199869 | (37.8013547799481, -122.421088199869) | |||
| 43875 | 43875 | 227122 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1137 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6001978.98288 | 2100703.16052 | 37.7482425519531 | -122.435932838524 | (37.7482425519531, -122.435932838524) | |||
| 44702 | 44702 | 227100 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 56 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004326.55063 | 2108840.26945 | 37.770718202624295 | -122.428394902803 | (37.7707182026243, -122.428394902803) | |||
| 45759 | 45759 | 206989 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1304 11th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5992723.56277 | 2106565.73006 | 37.7638095171187 | -122.468363979738 | (37.7638095171187, -122.468363979738) | |||
| 46936 | 46936 | 207047 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 654 Joost Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997739.24902 | 2095008.6617599998 | 37.7323650733825 | -122.450183245677 | (37.7323650733825, -122.450183245677) | |||
| 51471 | 51471 | 116543 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001574.8493099995 | 2088164.89401 | 37.713792383287796 | -122.43643306305 | (37.7137923832878, -122.43643306305) | |||
| 56096 | 56096 | 65853 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3415 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51130 | 6000770.44597 | 2120073.90569 | 37.8013609996628 | -122.44150173651501 | (37.8013609996628, -122.441501736515) | |
| 56157 | 56157 | 95935 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767632 | 5987262.82019 | 2111075.2653 | 37.7758745231149 | -122.48758207690001 | (37.7758745231149, -122.4875820769) |
| 56440 | 56440 | 117883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 734 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5982620.39521 | 2110769.29715 | 37.7747625699566 | -122.503618485147 | (37.7747625699566, -122.503618485147) | |||
| 56726 | 56726 | 227158 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3318 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008087.45284 | 2104471.6208599997 | 37.7589350063619 | -122.415076566546 | (37.7589350063619, -122.415076566546) | |||
| 56854 | 56854 | 88482 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014826.8932300005 | 2096240.8429 | 37.7367114428676 | -122.391192904038 | (37.7367114428676, -122.391192904038) | |
| 57488 | 57488 | 250555 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988156.37986 | 2115366.75845 | 37.7877098242971 | -122.484805955556 | (37.7877098242971, -122.484805955556) | |||
| 60679 | 60679 | 207022 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997053.5846 | 2090532.92812 | 37.720036506659206 | -122.452230901246 | (37.7200365066592, -122.452230901246) | |||
| 63861 | 63861 | 207046 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 654 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997758.19926 | 2095006.4821 | 37.7323601729864 | -122.450117573561 | (37.7323601729864, -122.450117573561) | |||
| 66540 | 66540 | 83309 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1519 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50153 | 5982468.6778 | 2104743.2959 | 37.758207981102295 | -122.50369693305099 | (37.7582079811023, -122.503696933051) | |
| 71687 | 71687 | 50032 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 33 Tulane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 5 | Permit Number 46764 | 6007353.74197 | 2093754.84576 | 37.729467879523895 | -122.416854825683 | (37.7294678795239, -122.416854825683) | |
| 72194 | 72194 | 121883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 18th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5990230.48175 | 2114847.31405 | 37.786404156248004 | -122.477592056385 | (37.786404156248, -122.477592056385) | |||
| 73263 | 73263 | 129389 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2507 Larkin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006655.24817 | 2120043.6921200003 | 37.801611544485205 | -122.421135524881 | (37.8016115444852, -122.421135524881) | |||
| 73444 | 73444 | 34680 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1904 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52535 | 6003705.30059 | 2119372.14104 | 37.7996008996227 | -122.43129571912701 | (37.7996008996227, -122.431295719127) | |
| 77138 | 77138 | 129378 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2500 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002236.43678 | 2116865.63553 | 37.7926353355998 | -122.436199040575 | (37.7926353355998, -122.436199040575) | |||
| 78971 | 78971 | 51607 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 5 | 3x3 | Permit Number 47904 | 5997656.30420255 | 2107807.08178851 | 37.7675016300781 | -122.45139275313 | (37.7675016300781, -122.45139275313) |
| 118167 | 118167 | 43321 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 283 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49915 | 6004368.565719999 | 2091597.24704 | 37.7233752280736 | -122.427021263027 | (37.7233752280736, -122.427021263027) | |
| 118839 | 118839 | 88270 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 288 States St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51256 | 6000346.0 | 2106829.0 | 37.764969709442504 | -122.44201926680701 | (37.7649697094425, -122.442019266807) | ||
| 129699 | 129699 | 227161 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005575.79788 | 2096114.93647 | 37.73584799837779 | -122.423169051236 | (37.7358479983778, -122.423169051236) | |||
| 134831 | 134831 | 176914 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1300 Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009346.093669999 | 2094283.90387 | 37.7310324255937 | -122.41000437762 | (37.7310324255937, -122.41000437762) | |||
| 150165 | 150165 | 88483 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014835.95113 | 2096251.5284900002 | 37.7367412859786 | -122.39116233337201 | (37.7367412859786, -122.391162333372) | |
| 150344 | 150344 | 207049 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 662 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997703.569180001 | 2095007.7992 | 37.7323606631136 | -122.450306536421 | (37.7323606631136, -122.450306536421) | |||
| 150847 | 150847 | 52442 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2310 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | Permit Number 48553 | 6003588.30454 | 2116614.49532 | 37.7920224826905 | -122.43150359293301 | (37.7920224826905, -122.431503592933) | |
| 151872 | 151872 | 116550 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001534.78323 | 2088160.3445099997 | 37.7137776146169 | -122.43657122050399 | (37.7137776146169, -122.436571220504) | |||
| 153309 | 153309 | 88186 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 43 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51193 | 6008751.52799 | 2109978.60624 | 37.774093208961204 | -122.41316928526001 | (37.7740932089612, -122.41316928526) | |
| 153780 | 153780 | 227138 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 280 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997418.344880001 | 2106450.2788299997 | 37.7637625662163 | -122.452117912216 | (37.7637625662163, -122.452117912216) | |||
| 154400 | 154400 | 141717 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2545 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998369.6346 | 2111707.5824 | 37.778252224784005 | -122.44920648801201 | (37.778252224784, -122.449206488012) | |||
| 155776 | 155776 | 176897 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 338 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006634.64196 | 2092369.41813 | 37.7256233218417 | -122.419242591383 | (37.7256233218417, -122.419242591383) | |||
| 157083 | 157083 | 227578 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 18 Dehon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6003773.299980001 | 2106438.61168 | 37.7640925103737 | -122.43013724663601 | (37.7640925103737, -122.430137246636) | |||
| 163285 | 163285 | 227571 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 579 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002573.48599 | 2103832.3664599997 | 37.756868362499205 | -122.43410072706301 | (37.7568683624992, -122.434100727063) | |||
| 164675 | 164675 | 250554 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988163.80572 | 2115366.95271 | 37.7877107901693 | -122.484780278081 | (37.7877107901693, -122.484780278081) | |||
| 165898 | 165898 | 227147 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 195 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008297.42871 | 2097716.19697 | 37.7403979249162 | -122.41387250470899 | (37.7403979249162, -122.413872504709) | |||
| 167979 | 167979 | 95712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 642 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767468 | 6003074.18539 | 2089625.7401 | 37.7178886288451 | -122.431355025819 | (37.7178886288451, -122.431355025819) |
| 168588 | 168588 | 227137 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 180 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997464.66679 | 2106771.33887 | 37.7646467688489 | -122.451980864539 | (37.7646467688489, -122.451980864539) | |||
| 176002 | 176002 | 95742 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 86 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767488 | 6004830.443109999 | 2091416.58174 | 37.7229052675357 | -122.42541178684799 | (37.7229052675357, -122.425411786848) |
| 176219 | 176219 | 88398 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51376 | 5987449.923219999 | 2113199.01189 | 37.7817166413541 | -122.48709085924 | (37.7817166413541, -122.48709085924) | |
| 178000 | 178000 | 95108 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 445 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54037 | 6002085.32525 | 2093826.71651 | 37.7293674729177 | -122.435073368138 | (37.7293674729177, -122.435073368138) |
| 178499 | 178499 | 227109 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 72 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008318.15108 | 2098296.22562 | 37.741991719651 | -122.41384187381 | (37.741991719651, -122.41384187381) | |||
| 179235 | 179235 | 191222 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1143 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013778.5148599995 | 2106149.81223 | 37.76386112381729 | -122.39551163825001 | (37.7638611238173, -122.39551163825) | |||
| 179963 | 179963 | 227566 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 91 Clover Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6000468.027480001 | 2104951.63177 | 37.7598218728073 | -122.44146247932301 | (37.7598218728073, -122.441462479323) | |||
| 181980 | 181980 | 60927 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1506 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1983 12:00:00 AM | 5 | Permit Number 20728 | 6010428.9415 | 2094674.9694599998 | 37.732166840331104 | -122.406288313254 | (37.7321668403311, -122.406288313254) | ||
| 185083 | 185083 | 227152 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008287.17043 | 2099413.88012 | 37.7450588116185 | -122.414028044267 | (37.7450588116185, -122.414028044267) | |||
| 186693 | 186693 | 247762 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 61 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6001652.093859999 | 2108463.90123 | 37.769533087721896 | -122.437618918075 | (37.7695330877219, -122.437618918075) | |||
| 188573 | 188573 | 206988 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1304 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5992723.70798 | 2106532.5962799997 | 37.76371854889079 | -122.468361066814 | (37.7637185488908, -122.468361066814) |
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");