trees
2,180 rows where qSpecies_id = 57 sorted by PlotSize
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
125 | 92934 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 339 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5992211 | 2096907 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) | 1 | 8 | 4 | 59 | 40 | ||||
918 | 62597 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 7 | Permit Number 22903 | 5984441.0146 | 2110622.99108 | 37.7744677278845 | -122.497309882833 | (37.7744677278845, -122.497309882833) | 11 | 6 | 2 | 55 | 26 | |
1783 | 61503 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 174 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/1986 12:00:00 AM | 8 | Permit Number 23383 | 5989631.93083 | 2114222.6944 | 37.7846543745532 | -122.479617149177 | (37.7846543745532, -122.479617149177) | 11 | 6 | 2 | 55 | 26 | |
1826 | 62206 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 50 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 13 | Permit Number 22328 | 6001109.87298 | 2093671.7514 | 37.7288865370674 | -122.438434491679 | (37.7288865370674, -122.438434491679) | 9 | 7 | 6 | 28861 | 25 | |
2171 | 61848 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21887 | 6010218.02478734 | 2103088.23113889 | 37.755256026984 | -122.407610478643 | (37.755256026984, -122.407610478643) | 2 | 4 | 7 | 28859 | 19 | ||
2396 | 61859 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1160 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | 8 | Permit Number 21899 | 6010253.66087773 | 2102459.66274806 | 37.75353211276 | -122.407442925811 | (37.75353211276, -122.407442925811) | 2 | 4 | 7 | 28859 | 19 | |
2536 | 73723 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2243 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000588.661 | 2119935.00811 | 37.8009692657904 | -122.442120815418 | (37.8009692657904, -122.442120815418) | 13 | 9 | 1 | 57 | 17 | |||
3257 | 62475 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 14 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 14 | Permit Number 22646 | 6001230.17424 | 2093762.35137 | 37.729142145995 | -122.438025089712 | (37.729142145995, -122.438025089712) | 9 | 7 | 6 | 28861 | 25 | |
3425 | 60034 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 108 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 7 | Permit Number 19523 | 6014255.56955 | 2112594.84947 | 37.7815842801353 | -122.394312917534 | (37.7815842801353, -122.394312917534) | 6 | 2 | 9 | 28856 | 6 | |
4618 | 31345 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 270 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 10 | Permit Number 34956 | 6006088.23081 | 2111255.80978 | 37.7774502243821 | -122.422472877923 | (37.7774502243821, -122.422472877923) | 7 | 9 | 11 | 28852 | 10 | |
4815 | 98680 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
5401 | 40626 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 721 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1999 12:00:00 AM | 5 | Permit Number 41627 | 6008236.32931 | 2114467.53897 | 37.7863898065975 | -122.415269286755 | (37.7863898065975, -122.415269286755) | 13 | 1 | 9 | 28858 | 36 | |
5540 | 64827 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 274 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1989 12:00:00 AM | Permit Number 25836 | 6004793.11366146 | 2099029.61430965 | 37.74380684184 | -122.426082529577 | (37.74380684184, -122.426082529577) | 2 | 7 | 5 | 63 | 22 | ||
6273 | 173900 | Private 9 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
6285 | 72175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2243 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6000606.57902 | 2119937.60106 | 37.8009774064533 | -122.442058997842 | (37.8009774064533, -122.442058997842) | 13 | 9 | 1 | 57 | 17 | |||
7016 | 61846 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1032 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21885 | 6010211.80559334 | 2103200.31460596 | 37.7555634350502 | -122.407639888906 | (37.7555634350502, -122.407639888906) | 2 | 4 | 7 | 28859 | 19 | ||
7160 | 62593 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 731 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22899 | 5984434.98291 | 2110845.23688 | 37.7750775975018 | -122.497347157504 | (37.7750775975018, -122.497347157504) | 11 | 6 | 2 | 55 | 26 | |
7648 | 62594 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 735 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22900 | 5984433.86075 | 2110817.89863 | 37.7750024687546 | -122.497349020618 | (37.7750024687546, -122.497349020618) | 11 | 6 | 2 | 55 | 26 | |
7855 | 60037 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 84 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 13 | Permit Number 19526 | 6014370.64542 | 2112704.82281 | 37.7818926378878 | -122.393922507437 | (37.7818926378878, -122.393922507437) | 6 | 2 | 9 | 28856 | 6 | |
8214 | 73718 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 73 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6001058.66667 | 2093583.83186 | 37.7286422173636 | -122.438605218052 | (37.7286422173636, -122.438605218052) | 9 | 7 | 6 | 28861 | 25 | |||
8666 | 72016 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 112 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6014238.82874 | 2112579.70736 | 37.7815417727734 | -122.394369772655 | (37.7815417727734, -122.394369772655) | 6 | 2 | 9 | 28856 | 6 | |||
9097 | 74222 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2030 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012358.62681 | 2102848.31202 | 37.7547168532055 | -122.400190745215 | (37.7547168532055, -122.400190745215) | 10 | 3 | 8 | 28856 | 29 | |||
9252 | 73860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1652 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6008793.24364 | 2118610.57457 | 37.7977968533 | -122.413635639483 | (37.7977968533, -122.413635639483) | 3 | 1 | 10 | 308 | 21 | |||
9311 | 71535 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1145 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6007520.46607 | 2118819.96047 | 37.7983002218264 | -122.418054666102 | (37.7983002218264, -122.418054666102) | 5 | 1 | 10 | 28858 | 32 | |||
9420 | 62591 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 759 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 9 | Permit Number 22897 | 5984439.68457 | 2110661.64848 | 37.7745737920548 | -122.497317337939 | (37.7745737920548, -122.497317337939) | 11 | 6 | 2 | 55 | 26 | |
9666 | 60024 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 181 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 14 | Permit Number 19511 | 6014126.74175 | 2112333.046 | 37.7808582655241 | -122.394740263669 | (37.7808582655241, -122.394740263669) | 6 | 2 | 9 | 28856 | 6 | |
9894 | 60029 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 21 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 17 | Permit Number 19517 | 6014545.42984 | 2112673.52396 | 37.7818164104522 | -122.393315638611 | (37.7818164104522, -122.393315638611) | 6 | 2 | 9 | 28856 | 6 | |
10089 | 83062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1375 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6016802.22624 | 2097268.63088 | 37.7396429656544 | -122.384434818109 | (37.7396429656544, -122.384434818109) | 10 | 3 | 8 | 58 | 1 | |||
10205 | 173902 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10259 | 66383 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 73 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 6 | Permit Number 29509 | 5997500.2628 | 2113257.2822 | 37.782457530461 | -122.452325802952 | (37.782457530461, -122.452325802952) | 15 | 6 | 1 | 54 | 31 | |
10830 | 67725 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1340 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1993 12:00:00 AM | Permit Number 31343 | 5992114.71357014 | 2106313.78524878 | 37.7630825579563 | -122.470451434039 | (37.7630825579563, -122.470451434039) | 1 | 8 | 11 | 56 | 12 | ||
10883 | 62592 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | Permit Number 22898 | 5984437.65774708 | 2110651.26442232 | 37.7745451616246 | -122.497323582278 | (37.7745451616246, -122.497323582278) | 11 | 6 | 2 | 55 | 26 | ||
11334 | 51578 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47872 | ||||||||||||||
11770 | 61941 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 178 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1985 12:00:00 AM | Permit Number 21999 | 6005366.58200406 | 2100230.03647017 | 37.7471353221182 | -122.424184964624 | (37.7471353221182, -122.424184964624) | 2 | 7 | 5 | 28859 | 22 | ||
11890 | 72130 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2030 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012329.14835 | 2102847.44399 | 37.7547128260461 | -122.400292629422 | (37.7547128260461, -122.400292629422) | 10 | 3 | 8 | 28856 | 29 | |||
12299 | 70030 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 66 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5998160.61879 | 2114184.40287 | 37.7850409692213 | -122.450108115392 | (37.7850409692213, -122.450108115392) | 15 | 6 | 1 | 54 | 31 | |||
12880 | 71814 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 68 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 5995915.83222 | 2114038.69637 | 37.7845121880339 | -122.457863769922 | (37.7845121880339, -122.457863769922) | 11 | 6 | 1 | 54 | 31 | |||
12964 | 60035 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 135 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 15 | Permit Number 19524 | 6014295.81848 | 2112435.53684 | 37.7811490811156 | -122.394162517581 | (37.7811490811156, -122.394162517581) | 6 | 2 | 9 | 28856 | 6 | |
13051 | 55532 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 630 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | Permit Number 11496 | 5993837.97104338 | 2106679.85882422 | 37.7641871892319 | -122.464517899057 | (37.7641871892319, -122.464517899057) | 11 | 8 | 11 | 56 | 12 | |||
13190 | 60028 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 33 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 10 | Permit Number 19516 | 6014481.96574 | 2112615.13715 | 37.7816525674538 | -122.393531108971 | (37.7816525674538, -122.393531108971) | 6 | 2 | 9 | 28856 | 6 | |
13575 | 247947 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 9 Joy St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6010380.59474 | 2098877.37331 | 37.7437030359631 | -122.406751516274 | (37.7437030359631, -122.406751516274) | 2 | 7 | 7 | 28859 | 2 | ||||
13747 | 59130 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 555 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1980 12:00:00 AM | 10 | Permit Number 18435 | 5992502.82437 | 2111669.37553 | 37.7778100081451 | -122.469498976775 | (37.7778100081451, -122.469498976775) | 11 | 6 | 2 | 54 | 11 | |
14305 | 73447 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6007557.7828 | 2115066.68598 | 37.7879967592968 | -122.417659373585 | (37.7879967592968, -122.417659373585) | 13 | 1 | 10 | 28858 | 21 | |||
14609 | 70619 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6007580.409 | 2115068.8992 | 37.7880041094384 | -122.417581247698 | (37.7880041094384, -122.417581247698) | 13 | 1 | 10 | 28858 | 21 | |||
14672 | 62212 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 11 | Permit Number 22335 | 6001303.33369 | 2093769.88226 | 37.7291669843608 | -122.437772711138 | (37.7291669843608, -122.437772711138) | 9 | 7 | 6 | 28861 | 25 | |
14725 | 71312 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1534 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/2015 12:00:00 AM | 13 | 6000471.9495 | 2110316.0552 | 37.7745514662119 | -122.44183393089 | (37.7745514662119, -122.44183393089) | 15 | 5 | 11 | 29492 | 16 | ||
15001 | 60031 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 136 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 16 | Permit Number 19519 | 6014189.65421 | 2112531.72054 | 37.7814072782548 | -122.394536533027 | (37.7814072782548, -122.394536533027) | 6 | 2 | 9 | 28856 | 6 | |
15480 | 59583 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 4071 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/1981 12:00:00 AM | Permit Number 18981 | 6002727.56027236 | 2101791.13153415 | 37.7512723603586 | -122.433422018052 | (37.7512723603586, -122.433422018052) | 2 | 4 | 5 | 28862 | 22 | ||
15535 | 247946 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 15 Joy St | 2 | Front Yard : Yard | Tree | Private 2 | 39 | 6010368.2533 | 2098885.09245 | 37.7437235405125 | -122.406794734117 | (37.7437235405125, -122.406794734117) | 2 | 7 | 7 | 28859 | 2 | ||||
15927 | 72147 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 73 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001070.59946 | 2093593.78195 | 37.7286702168354 | -122.43856467842 | (37.7286702168354, -122.43856467842) | 9 | 7 | 6 | 28861 | 25 | |||
16415 | 104004 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2179 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992553.4 | 2100640.7 | 37.7475310970527 | -122.468521397227 | (37.7475310970527, -122.468521397227) | 1 | 8 | 4 | 29491 | 40 | |||||
16674 | 62213 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 37 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 13 | Permit Number 22336 | 6001177.27304 | 2093672.32892 | 37.7288919563899 | -122.438201526774 | (37.7288919563899, -122.438201526774) | 9 | 7 | 6 | 28861 | 25 | |
17343 | 60021 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 76 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 14 | Permit Number 19508 | 6014385.60562 | 2112720.25781 | 37.781935850286 | -122.393871832437 | (37.781935850286, -122.393871832437) | 6 | 2 | 9 | 28856 | 6 | |
17977 | 61561 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2018 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 13 | Permit Number 21521 | 6012372.92464 | 2102851.20002 | 37.754725580248 | -122.400141501934 | (37.754725580248, -122.400141501934) | 10 | 3 | 8 | 28856 | 29 | |
18310 | 60036 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 147 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 12 | Permit Number 19525 | 6014255.98068 | 2112398.36524 | 37.7810448020107 | -122.394297734267 | (37.7810448020107, -122.394297734267) | 6 | 2 | 9 | 28856 | 6 | |
18528 | 66992 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 173 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30345 | 5995611.62082258 | 2091036.47990525 | 37.7213364301148 | -122.457251654811 | (37.7213364301148, -122.457251654811) | 9 | 8 | 6 | 28861 | 24 | ||
18638 | 60588 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 516 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 12 | Permit Number 20205 | 6000644.6678 | 2110770.9269 | 37.7758102690094 | -122.441269110246 | (37.7758102690094, -122.441269110246) | 15 | 5 | 11 | 29492 | 10 | |
18649 | 73588 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1145 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007504.43189 | 2118817.2788 | 37.7982919561693 | -122.418109959117 | (37.7982919561693, -122.418109959117) | 5 | 1 | 10 | 28858 | 32 | |||
18665 | 60026 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 104 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 16 | Permit Number 19514 | 6014265.09477 | 2112604.60863 | 37.781611606035 | -122.394280648053 | (37.781611606035, -122.394280648053) | 6 | 2 | 9 | 28856 | 6 | |
20777 | 41179 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1768 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 8 | Permit Number 41898 | 6001615.11314 | 2121098.92482 | 37.8042235156744 | -122.438652307458 | (37.8042235156744, -122.438652307458) | 13 | 9 | 1 | 57 | 17 | |
20799 | 108149 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
20975 | 68850 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 235 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32813 | 5999189.08755836 | 2094052.99169606 | 37.7298238896011 | -122.445102154978 | (37.7298238896011, -122.445102154978) | 9 | 7 | 4 | 28861 | 40 | ||
21077 | 62018 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1611 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1985 12:00:00 AM | 7 | Permit Number 22090 | 5999587.6363 | 2114469.4142 | 37.7859050916356 | -122.445191601832 | (37.7859050916356, -122.445191601832) | 15 | 6 | 1 | 29490 | 31 | ||
21748 | 207991 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 378 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5999591.13062 | 2094983.54982 | 37.7324019240113 | -122.443779078947 | (37.7324019240113, -122.443779078947) | 9 | 7 | 4 | 63 | 40 | ||||
21778 | 61936 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 145 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2015 12:00:00 AM | 3 | Permit Number 21993 | 6005587.19063437 | 2100190.09001467 | 37.7470380920929 | -122.423419277525 | (37.7470380920929, -122.423419277525) | 2 | 7 | 5 | 28859 | 22 | |
22007 | 59094 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 627 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 11 | Permit Number 18395 | 5994067.68279 | 2111215.68706 | 37.7766546137994 | -122.464052687917 | (37.7766546137994, -122.464052687917) | 11 | 6 | 2 | 54 | 11 | ||
22693 | 33770 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3101 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.7590111673758 | -122.41160061802 | (37.7590111673758, -122.41160061802) | 2 | 4 | 7 | 28859 | 19 | ||||
23570 | 122138 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5991116.91399 | 2114978.91933 | 37.7868169072323 | -122.474534863989 | (37.7868169072323, -122.474534863989) | 11 | 6 | 1 | 54 | 33 | ||||
23799 | 62094 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 415 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1985 12:00:00 AM | 10 | Permit Number 22183 | 6013254.03052 | 2105108.1707 | 37.7609718188263 | -122.397252634924 | (37.7609718188263, -122.397252634924) | 10 | 3 | 8 | 28856 | 29 | |
23849 | 65924 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 86 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28940 | 5995916.1594989 | 2113912.59060771 | 37.784165954142 | -122.457853509092 | (37.784165954142, -122.457853509092) | 11 | 6 | 1 | 54 | 31 | ||
24257 | 106128 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2204 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6012212.28641 | 2101900.78254 | 37.7521069828692 | -122.400630274471 | (37.7521069828692, -122.400630274471) | 10 | 3 | 8 | 28856 | 29 | ||||
25770 | 61942 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1985 12:00:00 AM | Permit Number 22000 | 6005289.72791626 | 2100225.80996813 | 37.7471193773829 | -122.424450419529 | (37.7471193773829, -122.424450419529) | 2 | 7 | 5 | 28859 | 22 | ||
25788 | 40954 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 117 Gillette Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41809 | 6013102.88048258 | 2086808.22702407 | 37.7107155607107 | -122.396492619427 | (37.7107155607107, -122.396492619427) | 10 | 3 | 8 | 309 | 1 | ||||
26356 | 65822 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2231 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1990 12:00:00 AM | 5 | Permit Number 28812 | 6000656.13395 | 2119945.18642 | 37.8010010577013 | -122.44188806188 | (37.8010010577013, -122.44188806188) | 13 | 9 | 1 | 57 | 17 | |
26550 | 122134 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5991116.74625 | 2115003.65081 | 37.7868848032576 | -122.4745372499 | (37.7868848032576, -122.4745372499) | 11 | 6 | 1 | 54 | 33 | ||||
26783 | 41176 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1529 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 9 | Permit Number 41895 | 6002871.19311 | 2121292.04704 | 37.8048251531279 | -122.434319365747 | (37.8048251531279, -122.434319365747) | 13 | 9 | 1 | 57 | 17 | |
26786 | 59149 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 218 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1980 12:00:00 AM | 7 | Permit Number 18458 | 5987761.12595 | 2114471.82373 | 37.7852295614332 | -122.486107720545 | (37.7852295614332, -122.486107720545) | 11 | 6 | 2 | 55 | 26 | ||
26834 | 122133 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 15th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5991114.06572 | 2115007.37065 | 37.7868948615896 | -122.474546795399 | (37.7868948615896, -122.474546795399) | 11 | 6 | 1 | 54 | 33 | ||||
26907 | 57576 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29580 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | ||
28411 | 34516 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 23 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1997 12:00:00 AM | Permit Number 38227 | 6006103.90835028 | 2100218.50622556 | 37.7471452669413 | -122.421634526851 | (37.7471452669413, -122.421634526851) | 2 | 7 | 5 | 28859 | 22 | ||
28646 | 42768 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 837 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42744 | 6003836.146 | 2110735.9706 | 37.7758955707266 | -122.430226485287 | (37.7758955707266, -122.430226485287) | 7 | 9 | 11 | 29492 | 10 | ||
30250 | 59329 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1014 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28034 | 6009143.5478602 | 2103242.41669988 | 37.7556191813831 | -122.411337245149 | (37.7556191813831, -122.411337245149) | 2 | 4 | 7 | 28859 | 19 | ||
30344 | 247848 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 149 Chapman St | 3 | Side Yard : Yard | Tree | Private 2 | 37 | 6009193.51112 | 2098205.92163 | 37.7417928858333 | -122.410808770816 | (37.7417928858333, -122.410808770816) | 10 | 7 | 7 | 28859 | 2 | ||||
30922 | 61857 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1131 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21897 | 6010295.90088737 | 2102630.50178879 | 37.7540035629897 | -122.407308892489 | (37.7540035629897, -122.407308892489) | 10 | 4 | 7 | 28859 | 19 | ||
30950 | 66558 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3726 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 29744 | 6005466.23183665 | 2104329.54931664 | 37.7583972608009 | -122.424131882152 | (37.7583972608009, -122.424131882152) | 2 | 4 | 5 | 28859 | 19 | ||
31163 | 227298 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 4233 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6002393.51458 | 2100323.84062 | 37.7472245688541 | -122.434472284662 | (37.7472245688541, -122.434472284662) | 2 | 4 | 5 | 63 | 22 | ||||
31714 | 67465 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 937 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1992 12:00:00 AM | 9 | Permit Number 30978 | 6008961.1272 | 2090382.77007 | 37.7202991536555 | -122.41105982826 | (37.7202991536555, -122.41105982826) | 9 | 3 | 7 | 309 | 28 | ||
32214 | 61853 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1123 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21892 | 6010293.32119713 | 2102675.26098556 | 37.7541263174163 | -122.407320968841 | (37.7541263174163, -122.407320968841) | 10 | 4 | 7 | 28859 | 19 | ||
32432 | 34780 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1167 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38419 | 6008092.50780159 | 2101138.05263813 | 37.7497820686377 | -122.414823157313 | (37.7497820686377, -122.414823157313) | 2 | 4 | 7 | 28859 | 19 | ||
32961 | 34389 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38137 | 6004014.39109162 | 2097091.94465812 | 37.7384424015374 | -122.428637072989 | (37.7384424015374, -122.428637072989) | 2 | 7 | 5 | 63 | 7 | ||
33376 | 67278 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 58 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1992 12:00:00 AM | 3 | Permit Number 30752 | 6004928.68664 | 2091573.73243 | 37.7233423191649 | -122.42508335531 | (37.7233423191649, -122.42508335531) | 9 | 7 | 6 | 28861 | 5 | |
33758 | 101245 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1301X 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.7638658419872 | -122.465411719392 | (37.7638658419872, -122.465411719392) | 1 | 8 | 11 | 56 | 12 | |||
33910 | 50451 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 12 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47097 | 5999287.88101991 | 2108301.76865452 | 37.7689532065783 | -122.445784947419 | (37.7689532065783, -122.445784947419) | 15 | 5 | 11 | 29492 | 9 | |||
34136 | 61855 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1127 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21894 | 6010294.61104225 | 2102652.88138717 | 37.7540649402035 | -122.40731493066 | (37.7540649402035, -122.40731493066) | 10 | 4 | 7 | 28859 | 19 | ||
34652 | 108151 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2232 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
35970 | 122754 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 693 Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 6011277.36342 | 2105334.1858 | 37.7614821606899 | -122.404105006665 | (37.7614821606899, -122.404105006665) | 10 | 3 | 8 | 28856 | 29 | |||
36670 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
37184 | 227290 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 685 29th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6002218.42059 | 2098832.30166 | 37.7431192122842 | -122.434971090944 | (37.7431192122842, -122.434971090944) | 2 | 7 | 5 | 63 | 7 | ||||
37311 | 60032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 301 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19520 | 6014916.63829129 | 2112653.79570554 | 37.7817828574395 | -122.39203004009 | (37.7817828574395, -122.39203004009) | 6 | 2 | 9 | 28856 | 6 | ||
39231 | 41268 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );