trees
272 rows where Supervisor Districts = 5 and qSpecies_id = 50 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14868 | 93885 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 61@ San Jose Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2010 12:00:00 AM | Permit Number 53373 | 6006171 | 2099937 | 37.7463760977894 | -122.421382540818 | (37.7463760977894, -122.421382540818) | 2 | 7 | 5 | 28859 | 2 | |||
158762 | 229744 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006129.97006 | 2100227.10081 | 37.7471703352582 | -122.421545017711 | (37.7471703352582, -122.421545017711) | 2 | 7 | 5 | 28859 | 22 | |||
168980 | 226358 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 603 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006078.34429 | 2099888.6136 | 37.7462380152724 | -122.421699497839 | (37.7462380152724, -122.421699497839) | 2 | 7 | 5 | 28859 | 2 | |||
52984 | 226359 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 18 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006091.22485 | 2103483.15861 | 37.7561085369955 | -122.421910253056 | (37.7561085369955, -122.421910253056) | 2 | 4 | 5 | 28859 | 19 | |||
120181 | 229745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6006000.19569 | 2099145.76871 | 37.7441939246187 | -122.421916967417 | (37.7441939246187, -122.421916967417) | 2 | 7 | 5 | 28859 | 2 | |||
1529 | 36010 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.7441837468315 | -122.421946122617 | (37.7441837468315, -122.421946122617) | 2 | 7 | 5 | 28859 | 2 | ||
42122 | 93487 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 643 San Jose Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53236 | 6005997.4 | 2099554.6 | 37.745316324998 | -122.421955670553 | (37.745316324998, -122.421955670553) | 2 | 7 | 5 | 28859 | 2 | |||
101368 | 40260 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3529 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41418 | 6006042.36187531 | 2101970.77964266 | 37.7519531379729 | -122.421971806823 | (37.7519531379729, -122.421971806823) | 2 | 4 | 5 | 28859 | 19 | ||
46491 | 226357 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 645 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005980.00754 | 2099557.6277 | 37.7453236574624 | -122.422016025938 | (37.7453236574624, -122.422016025938) | 2 | 7 | 5 | 28859 | 2 | |||
140480 | 226425 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3529 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005988.79838 | 2101974.74893 | 37.7519610156893 | -122.422157319311 | (37.7519610156893, -122.422157319311) | 2 | 4 | 5 | 28859 | 19 | |||
130325 | 35308 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3524 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38776 | 6006060.26352617 | 2105533.64133784 | 37.761736937829 | -122.422162997439 | (37.761736937829, -122.422162997439) | 8 | 4 | 5 | 28859 | 19 | ||
88827 | 226362 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 7 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005992.12876 | 2102270.13031 | 37.7527722527625 | -122.422166785593 | (37.7527722527625, -122.422166785593) | 2 | 4 | 5 | 28859 | 19 | |||
29877 | 39158 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40827 | 6006035.82025068 | 2105107.15671694 | 37.7605645323651 | -122.422217235752 | (37.7605645323651, -122.422217235752) | 2 | 4 | 5 | 28859 | 19 | ||
42787 | 39159 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40827 | 6006035.82025068 | 2105107.15671694 | 37.7605645323651 | -122.422217235752 | (37.7605645323651, -122.422217235752) | 2 | 4 | 5 | 28859 | 19 | ||
95435 | 229797 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 79 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006025.25664 | 2105073.13553 | 37.7604705223053 | -122.422251353344 | (37.7604705223053, -122.422251353344) | 2 | 4 | 5 | 28859 | 19 | |||
46170 | 229805 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3526 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6006031.82091 | 2105526.37435 | 37.7617153800751 | -122.422260852855 | (37.7617153800751, -122.422260852855) | 8 | 4 | 5 | 28859 | 19 | |||
41705 | 229798 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006019.29949 | 2105109.06322 | 37.7605688353024 | -122.422274509073 | (37.7605688353024, -122.422274509073) | 2 | 4 | 5 | 28859 | 19 | |||
72032 | 229799 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006019.54288 | 2105120.91089 | 37.7606013799572 | -122.422274509073 | (37.7606013799572, -122.422274509073) | 2 | 4 | 5 | 28859 | 19 | |||
126744 | 94041 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 5 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2010 12:00:00 AM | Permit Number 53451 | 6005890 | 2099632 | 37.7455227900977 | -122.422332540821 | (37.7455227900977, -122.422332540821) | 2 | 7 | 5 | 28859 | 22 | |||
40136 | 229839 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 70 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005996.27622 | 2105099.28876 | 37.7605406982241 | -122.422353441684 | (37.7605406982241, -122.422353441684) | 2 | 4 | 5 | 28859 | 19 | |||
99690 | 229838 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005984.45224 | 2105323.33984 | 37.7611552229594 | -122.422410255427 | (37.7611552229594, -122.422410255427) | 2 | 4 | 5 | 28859 | 19 | |||
165178 | 226466 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 7 28th St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6005836.7555 | 2099627.17961 | 37.7455065507954 | -122.422516309799 | (37.7455065507954, -122.422516309799) | 2 | 7 | 5 | 28859 | 22 | |||
166276 | 95624 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3548 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767391 | 6005934 | 2105520 | 37.761692359374 | -122.422598723522 | (37.761692359374, -122.422598723522) | 8 | 4 | 5 | 28859 | 19 | |
151810 | 226467 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 11 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005807.5274 | 2099625.67838 | 37.7455007798334 | -122.42261726947 | (37.7455007798334, -122.42261726947) | 2 | 7 | 5 | 28859 | 22 | |||
74807 | 10220 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1366 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6005800.08489 | 2101007.66776 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | 2 | 4 | 5 | 28859 | 19 | |||
35141 | 32262 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 10 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 3 | Permit Number 35561 | 6005748.8799 | 2099664.71545 | 37.7456046578383 | -122.422822837406 | (37.7456046578383, -122.422822837406) | 2 | 7 | 5 | 28859 | 22 | |
82268 | 229743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005873.02878 | 2106520.6426 | 37.7644364480055 | -122.422880717778 | (37.7644364480055, -122.422880717778) | 8 | 4 | 5 | 28859 | 19 | |||
130757 | 35314 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | 6 | 3x3 | Permit Number 38781 | 6005865.10533901 | 2106546.77110861 | 37.7645077436281 | -122.422909979953 | (37.7645077436281, -122.422909979953) | 8 | 4 | 5 | 28859 | 19 |
75595 | 63245 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3676 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/1988 12:00:00 AM | 3 | 3x3 | Permit Number 24178 | 6005805.15699581 | 2104348.35401431 | 37.7584680245234 | -122.422961063691 | (37.7584680245234, -122.422961063691) | 2 | 4 | 5 | 28859 | 19 |
176921 | 35574 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38942 | 6005781.80020082 | 2103418.56410023 | 37.7559137201977 | -122.422975758251 | (37.7559137201977, -122.422975758251) | 2 | 4 | 5 | 28859 | 19 | ||
121019 | 226360 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005779.63458 | 2103420.31022 | 37.7559183924354 | -122.422983371787 | (37.7559183924354, -122.422983371787) | 2 | 4 | 5 | 28859 | 19 | |||
12595 | 229844 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3676 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6005793.11557 | 2104343.58039 | 37.7584542377953 | -122.423002369088 | (37.7584542377953, -122.423002369088) | 2 | 4 | 5 | 28859 | 19 | |||
191205 | 226361 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005760.58737 | 2103420.35055 | 37.7559174283599 | -122.423049246236 | (37.7559174283599, -122.423049246236) | 2 | 4 | 5 | 28859 | 19 | |||
13239 | 35575 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | 7X6 | Permit Number 38943 | 6005733.52150857 | 2103415.89933022 | 37.7559036789868 | -122.423142532595 | (37.7559036789868, -122.423142532595) | 2 | 4 | 5 | 28859 | 19 | |
156800 | 10139 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 905 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2014 12:00:00 AM | 1 | 2X2 | 6005721.36321 | 2103691.71608 | 37.7566603214356 | -122.42320418504 | (37.7566603214356, -122.42320418504) | 2 | 4 | 5 | 28859 | 19 | ||
153280 | 226762 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 62 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005544.98011 | 2099653.84342 | 37.7455632989187 | -122.423527119901 | (37.7455632989187, -122.423527119901) | 2 | 7 | 5 | 28859 | 22 | |||
140189 | 226761 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 69 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005532.06027 | 2099607.16908 | 37.7454344125679 | -122.423568476998 | (37.7454344125679, -122.423568476998) | 2 | 7 | 5 | 28859 | 22 | |||
28580 | 10084 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 649 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2012 12:00:00 AM | 3 | 3X3 | 6005635.92874 | 2105201.33874 | 37.7608005699125 | -122.423606976082 | (37.7608005699125, -122.423606976082) | 2 | 4 | 5 | 28859 | 19 | ||
81761 | 10083 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 643 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2004 12:00:00 AM | 3 | 3X3 | 6005633.91176 | 2105224.85563 | 37.7608650279097 | -122.423615623972 | (37.7608650279097, -122.423615623972) | 2 | 4 | 5 | 28859 | 19 | ||
99483 | 34194 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 62 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1997 12:00:00 AM | Permit Number 38013 | 6005507.05529052 | 2099654.01670417 | 37.7455616340181 | -122.423658270556 | (37.7455616340181, -122.423658270556) | 2 | 7 | 5 | 28859 | 22 | |||
85315 | 33045 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 435 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2000 12:00:00 AM | Permit Number 37322 | 6005530.37891091 | 2101176.15171839 | 37.7497423846708 | -122.423685826158 | (37.7497423846708, -122.423685826158) | 2 | 4 | 5 | 28859 | 19 | ||
130054 | 229852 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3631 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005555.32091 | 2102533.44251 | 37.7534705997005 | -122.423696068331 | (37.7534705997005, -122.423696068331) | 2 | 4 | 5 | 28859 | 19 | |||
167928 | 226763 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 162 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005498.11754 | 2099940.99775 | 37.7463491139326 | -122.423709577049 | (37.7463491139326, -122.423709577049) | 2 | 7 | 5 | 28859 | 22 | |||
85838 | 33044 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 417 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37321 | 6005524.82070863 | 2101276.46802426 | 37.7500175164074 | -122.423712178429 | (37.7500175164074, -122.423712178429) | 2 | 4 | 5 | 28859 | 19 | ||
115963 | 229748 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3729 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005508.50814 | 2100776.42881 | 37.7486436028343 | -122.42373303855 | (37.7486436028343, -122.42373303855) | 2 | 4 | 5 | 28859 | 19 | |||
159162 | 87811 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3631 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50591 | 6005544 | 2102537 | 37.7534797286848 | -122.423735471432 | (37.7534797286848, -122.423735471432) | 2 | 4 | 5 | 28859 | 19 | ||
132383 | 42046 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 162 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45105 | 6005486.77037609 | 2099946.40187796 | 37.7463633118872 | -122.423749198438 | (37.7463633118872, -122.423749198438) | 2 | 7 | 5 | 28859 | 22 | ||
40238 | 46344 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 365 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44590 | 6005506.87362767 | 2101591.77673747 | 37.7508822683578 | -122.423796657689 | (37.7508822683578, -122.423796657689) | 2 | 4 | 5 | 28859 | 19 | ||
34432 | 229750 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 365 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005497.63156 | 2101589.27142 | 37.7508748675982 | -122.423828439536 | (37.7508748675982, -122.423828439536) | 2 | 4 | 5 | 28859 | 19 | |||
155463 | 36721 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 31 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39505 | 6005645.10091643 | 2108871.29821034 | 37.7708779241001 | -122.423836216701 | (37.7708779241001, -122.423836216701) | 8 | 2 | 5 | 28853 | 19 | ||
127792 | 33046 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.7495787038819 | -122.423850524117 | (37.7495787038819, -122.423850524117) | 2 | 4 | 5 | 28859 | 19 | ||
176006 | 33047 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.7495787038819 | -122.423850524117 | (37.7495787038819, -122.423850524117) | 2 | 4 | 5 | 28859 | 19 | ||
187304 | 228524 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 29 Pearl St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6005636.60822 | 2108865.67188 | 37.7708619961085 | -122.42386519304 | (37.7708619961085, -122.42386519304) | 8 | 2 | 5 | 28853 | 19 | |||
121342 | 226766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005428.90079 | 2099643.28917 | 37.7455277666988 | -122.423927754381 | (37.7455277666988, -122.423927754381) | 2 | 7 | 5 | 28859 | 22 | |||
55153 | 229747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005427.81149 | 2099645.37238 | 37.7455334252207 | -122.423931669125 | (37.7455334252207, -122.423931669125) | 2 | 7 | 5 | 28859 | 22 | |||
80034 | 95634 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 354 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | Permit Number 767401 | 6005462 | 2101644 | 37.7510231280856 | -122.42395554828 | (37.7510231280856, -122.42395554828) | 2 | 4 | 5 | 28859 | 19 | ||
166424 | 229855 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 354 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005458.16704 | 2101659.72097 | 37.7510660778443 | -122.42396992087 | (37.7510660778443, -122.42396992087) | 2 | 4 | 5 | 28859 | 19 | |||
12723 | 229788 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1799 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005571.35245 | 2107231.70655 | 37.7663718340174 | -122.423974702579 | (37.7663718340174, -122.423974702579) | 8 | 4 | 5 | 28853 | 19 | |||
181529 | 229746 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 170 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 8ft | 6005420.74895 | 2100228.937 | 37.7471353615169 | -122.423997581329 | (37.7471353615169, -122.423997581329) | 2 | 7 | 5 | 28859 | 22 | |||
8554 | 229854 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 318 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005450.52958 | 2101809.91595 | 37.7514780473814 | -122.424007011614 | (37.7514780473814, -122.424007011614) | 2 | 4 | 5 | 28859 | 19 | |||
55486 | 37153 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 170 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39733 | 6005417.81804662 | 2100232.85413732 | 37.7471459516063 | -122.42400799468 | (37.7471459516063, -122.42400799468) | 2 | 7 | 5 | 28859 | 22 | |||
132381 | 229787 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1799 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005558.49234 | 2107230.4627 | 37.7663676926515 | -122.424019094899 | (37.7663676926515, -122.424019094899) | 8 | 4 | 5 | 28853 | 19 | |||
184733 | 33040 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 318 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37317 | 6005440.04608192 | 2101847.29088497 | 37.751580078433 | -122.42404592247 | (37.751580078433, -122.42404592247) | 2 | 4 | 5 | 28859 | 19 | ||
25889 | 52052 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2005 12:00:00 AM | Permit Number 48254 | 6005362.31259493 | 2099645.76538508 | 37.7455308063117 | -122.424158182307 | (37.7455308063117, -122.424158182307) | 2 | 7 | 5 | 28859 | 22 | |||
49552 | 35556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 121 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38929 | 6005429.10148231 | 2103004.04163022 | 37.7547556297845 | -122.424166028327 | (37.7547556297845, -122.424166028327) | 2 | 4 | 5 | 28859 | 19 | ||
172051 | 35555 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 121 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38929 | 6005429.10148231 | 2103004.04163022 | 37.7547556297845 | -122.424166028327 | (37.7547556297845, -122.424166028327) | 2 | 4 | 5 | 28859 | 19 | ||
181262 | 35309 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3614 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38777 | 6005480.32103823 | 2105501.15439096 | 37.7616150083325 | -122.424166477384 | (37.7616150083325, -122.424166477384) | 8 | 4 | 5 | 28859 | 19 | ||
26900 | 35554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 117 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38928 | 6005427.85924462 | 2103026.46196551 | 37.754817120668 | -122.424171918741 | (37.754817120668, -122.424171918741) | 2 | 4 | 5 | 28859 | 19 | ||
100803 | 229843 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3731 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005450.41756 | 2104282.65689 | 37.7582676122766 | -122.424183240071 | (37.7582676122766, -122.424183240071) | 2 | 4 | 5 | 28859 | 19 | |||
136734 | 229853 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 204 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6005411.70889 | 2102466.72114 | 37.7532792905247 | -122.424187965125 | (37.7532792905247, -122.424187965125) | 2 | 4 | 5 | 28859 | 19 | |||
121690 | 229856 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 119 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005420.32438 | 2102982.74414 | 37.7546966562501 | -122.424194867403 | (37.7546966562501, -122.424194867403) | 2 | 4 | 5 | 28859 | 19 | |||
51280 | 229857 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 119 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005419.16743 | 2102997.26245 | 37.7547364548257 | -122.42419990093 | (37.7547364548257, -122.42419990093) | 2 | 4 | 5 | 28859 | 19 | |||
123697 | 229858 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 115 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005418.69368 | 2103014.66569 | 37.7547842133232 | -122.424202776932 | (37.7547842133232, -122.424202776932) | 2 | 4 | 5 | 28859 | 19 | |||
139718 | 34979 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 204 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | 4 | 4.5x5.5 | Permit Number 38560 | 6005404.47969691 | 2102506.81993306 | 37.7533889843192 | -122.424215816798 | (37.7533889843192, -122.424215816798) | 2 | 4 | 5 | 28859 | 19 | |
33217 | 229842 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3731 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005435.33161 | 2104281.13131 | 37.7582625715808 | -122.424235305437 | (37.7582625715808, -122.424235305437) | 2 | 4 | 5 | 28859 | 19 | |||
121545 | 104351 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3732 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2013 12:00:00 AM | 3x3 | Permit Number 769484 | 6005428.9 | 2104316.5 | 37.7583593225521 | -122.424260064239 | (37.7583593225521, -122.424260064239) | 2 | 4 | 5 | 28859 | 19 | ||
157178 | 229840 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3732 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005421.91572 | 2104323.47522 | 37.7583780804987 | -122.42428471508 | (37.7583780804987, -122.42428471508) | 2 | 4 | 5 | 28859 | 19 | |||
49291 | 35310 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38778 | 6005440.34891977 | 2105498.91525501 | 37.7616066031849 | -122.424304565555 | (37.7616066031849, -122.424304565555) | 8 | 4 | 5 | 28859 | 19 | ||
37213 | 229796 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005429.44821 | 2105495.57142 | 37.7615968062711 | -122.42434202887 | (37.7615968062711, -122.42434202887) | 8 | 4 | 5 | 28859 | 19 | |||
89909 | 40262 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3668 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45085 | 6005347.95435348 | 2101987.4938302 | 37.7519598434296 | -122.424374358675 | (37.7519598434296, -122.424374358675) | 2 | 4 | 5 | 28859 | 19 | ||
168291 | 229850 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005369.98342 | 2103227.02308 | 37.7553645467641 | -122.424386333963 | (37.7553645467641, -122.424386333963) | 2 | 4 | 5 | 28859 | 19 | |||
57912 | 229849 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005369.70063 | 2103246.31322 | 37.7554174970228 | -122.424388683912 | (37.7554174970228, -122.424388683912) | 2 | 4 | 5 | 28859 | 19 | |||
156239 | 35551 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38926 | 6005365.24269409 | 2103216.6337934 | 37.7553357524994 | -122.424401989918 | (37.7553357524994, -122.424401989918) | 2 | 4 | 5 | 28859 | 19 | ||
165980 | 35552 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38926 | 6005365.24269409 | 2103216.6337934 | 37.7553357524994 | -122.424401989918 | (37.7553357524994, -122.424401989918) | 2 | 4 | 5 | 28859 | 19 | ||
20883 | 229739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005381.68276 | 2105771.85713 | 37.7623527242205 | -122.424526883603 | (37.7623527242205, -122.424526883603) | 8 | 4 | 5 | 28859 | 19 | |||
153478 | 37047 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39653 | 6005177.12153831 | 2098757.26684492 | 37.7430807339727 | -122.424735348964 | (37.7430807339727, -122.424735348964) | 2 | 7 | 5 | 63 | 22 | ||
118059 | 229851 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3476 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005224.27496 | 2103144.25068 | 37.7551290439715 | -122.424884349738 | (37.7551290439715, -122.424884349738) | 2 | 4 | 5 | 28859 | 19 | |||
28908 | 229866 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005094.82025 | 2098749.88858 | 37.7430558262652 | -122.425019400031 | (37.7430558262652, -122.425019400031) | 2 | 7 | 5 | 63 | 22 | |||
130410 | 229841 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3772 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6005193.66428 | 2104309.81334 | 37.7583276770852 | -122.425073138141 | (37.7583276770852, -122.425073138141) | 2 | 4 | 5 | 28859 | 19 | |||
76307 | 229740 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 60 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005206.89439 | 2105762.97862 | 37.7623184735408 | -122.425130780182 | (37.7623184735408, -122.425130780182) | 8 | 4 | 5 | 28859 | 19 | |||
150983 | 229845 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6005155.25082 | 2103726.26853 | 37.756723229919 | -122.425164466987 | (37.756723229919, -122.425164466987) | 2 | 4 | 5 | 28859 | 19 | |||
190748 | 229846 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6005141.9373 | 2103725.25099 | 37.7567196838778 | -122.425210437638 | (37.7567196838778, -122.425210437638) | 2 | 4 | 5 | 28859 | 19 | |||
33298 | 229847 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6005127.97551 | 2103724.2468 | 37.7567161378508 | -122.42525865119 | (37.7567161378508, -122.42525865119) | 2 | 4 | 5 | 28859 | 19 | |||
1963 | 229848 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6005112.08271 | 2103723.92824 | 37.7567143652889 | -122.425313591669 | (37.7567143652889, -122.425313591669) | 2 | 4 | 5 | 28859 | 19 | |||
40413 | 40242 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
61584 | 40245 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
85186 | 40244 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
176868 | 40243 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
105814 | 229742 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 749 Dolores St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 8ft | 6005048.07948 | 2104060.60475 | 37.7576351838315 | -122.425558898838 | (37.7576351838315, -122.425558898838) | 2 | 4 | 5 | 28859 | 19 | |||
62332 | 5527 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 882 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6005005.94295 | 2103241.13664 | 37.7553827355522 | -122.425646301253 | (37.7553827355522, -122.425646301253) | 2 | 4 | 5 | 28862 | 22 |
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) );