trees
3,709 rows where qSpecies_id = 9 sorted by qLegalStatus_id descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15423 | 85309 | - 12 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/26/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.7706407896873 | -122.442827504693 | (37.7706407896873, -122.442827504693) | 15 | 5 | 11 | 29492 | 9 |
188548 | 85310 | - 12 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/27/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.7706407896873 | -122.442827504693 | (37.7706407896873, -122.442827504693) | 15 | 5 | 11 | 29492 | 9 |
15934 | 113606 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
38713 | 113610 | Section 143 10 | Olea europaea :: Olive Tree 9 | 595 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009000 | 2105472 | 37.7617330585457 | -122.411991234579 | (37.7617330585457, -122.411991234579) | 8 | 4 | 7 | 28859 | 19 | |||
59693 | 113605 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
65275 | 113613 | Section 143 10 | Olea europaea :: Olive Tree 9 | 595 ALABAMA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009000 | 2105472 | 37.7617330585457 | -122.411991234579 | (37.7617330585457, -122.411991234579) | 8 | 4 | 7 | 28859 | 19 | |||
69927 | 113600 | Section 143 10 | Olea europaea :: Olive Tree 9 | 550 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773946 | 6009233 | 2105681 | 37.7623199946126 | -122.411200142124 | (37.7623199946126, -122.411200142124) | 8 | 4 | 7 | 28859 | 19 | |
71895 | 113602 | Section 143 10 | Olea europaea :: Olive Tree 9 | 550 FLORIDA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233 | 2105681 | 37.7623199946126 | -122.411200142124 | (37.7623199946126, -122.411200142124) | 8 | 4 | 7 | 28859 | 19 | ||
89445 | 113603 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
106808 | 113611 | Section 143 10 | Olea europaea :: Olive Tree 9 | 595 ALABAMA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009000 | 2105472 | 37.7617330585457 | -122.411991234579 | (37.7617330585457, -122.411991234579) | 8 | 4 | 7 | 28859 | 19 | |||
115452 | 113608 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
138839 | 113607 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
157435 | 113601 | Section 143 10 | Olea europaea :: Olive Tree 9 | 550 FLORIDA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233 | 2105681 | 37.7623199946126 | -122.411200142124 | (37.7623199946126, -122.411200142124) | 8 | 4 | 7 | 28859 | 19 | ||
163668 | 113604 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
181612 | 113609 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
193056 | 113612 | Section 143 10 | Olea europaea :: Olive Tree 9 | 595 ALABAMA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009000 | 2105472 | 37.7617330585457 | -122.411991234579 | (37.7617330585457, -122.411991234579) | 8 | 4 | 7 | 28859 | 19 | |||
5653 | 215048 | Private 9 | Olea europaea :: Olive Tree 9 | 1719 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782897 | 5990885.18116 | 2103671.34742 | 37.7557559568771 | -122.474511074324 | (37.7557559568771, -122.474511074324) | 1 | 8 | 4 | 56 | 12 | |
5987 | 262213 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 66 Clarendon Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997837 | 2104660 | 37.7588708842054 | -122.450540844653 | (37.7588708842054, -122.450540844653) | 15 | 5 | 11 | 28862 | 12 | ||||
7701 | 97237 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125 Excelsior Ave | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 | |||
101616 | 102250 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125X Powhattan Ave | 3 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
106561 | 97238 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125 Excelsior Ave | 1 | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 |
108303 | 102249 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125X Powhattan Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
117229 | 102248 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125X Powhattan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
1005 | 39481 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
1571 | 56051 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 49 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 36 | Permit Number 12140 | 6003182.54972715 | 2108023.57751638 | 37.7684109649411 | -122.43229368198 | (37.7684109649411, -122.43229368198) | 15 | 5 | 5 | 28862 | 3 | ||
2359 | 35980 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 349 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39134 | 6006399.96537133 | 2097866.62265006 | 37.740704214618 | -122.420443871581 | (37.740704214618, -122.420443871581) | 2 | 7 | 7 | 28859 | 2 | ||
2689 | 8750 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3301 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5996889.89707 | 2112871.05246 | 37.7813620597582 | -122.454409481549 | (37.7813620597582, -122.454409481549) | 11 | 6 | 2 | 54 | 16 | |||
2714 | 113322 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | 7 | 9 | 5 | 28862 | 3 | ||||
2927 | 35280 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
3574 | 218861 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 44 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995517.64423 | 2107073.72636 | 37.7653653316693 | -122.458736946766 | (37.7653653316693, -122.458736946766) | 15 | 5 | 11 | 56 | 12 | |||
4903 | 88595 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 399 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52536 | 6004228 | 2109402 | 37.7722550008378 | -122.428775842479 | (37.7722550008378, -122.428775842479) | 7 | 9 | 11 | 28852 | 10 | ||
6162 | 46753 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 378 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44855 | 5993270.29922187 | 2089695.37971007 | 37.7175193444423 | -122.465247516931 | (37.7175193444423, -122.465247516931) | 9 | 8 | 6 | 64 | 24 | ||
6841 | 45453 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 191 Corona St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.7252189362985 | -122.466364051503 | (37.7252189362985, -122.466364051503) | 9 | 8 | 4 | 59 | 40 | ||
6966 | 35281 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
7927 | 17200 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 200X Olive St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6006498.35844 | 2113758.48472 | 37.7843450883742 | -122.421231867498 | (37.7843450883742, -122.421231867498) | 7 | 9 | 11 | 28858 | 41 | |||
9251 | 64294 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 369 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | 11 | Permit Number 25100 | 6004186.81103281 | 2098943.74928531 | 37.7435367899994 | -122.428172863442 | (37.7435367899994, -122.428172863442) | 2 | 7 | 5 | 63 | 22 | |
9743 | 34866 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 579 Miramar Ave | 1 | Median : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | 9 | 7 | 4 | 28861 | 40 | ||
10720 | 39483 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
13401 | 35284 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
14355 | 35285 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
14364 | 107684 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
14962 | 41296 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 65 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 41973 | 6006281.33179879 | 2109112.42754659 | 37.7715759040746 | -122.421652604165 | (37.7715759040746, -122.421652604165) | 8 | 2 | 9 | 28853 | 19 | ||
15184 | 32343 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2885 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36904 | 5999249.30586492 | 2118007.60671846 | 37.7956007178544 | -122.446616785481 | (37.7956007178544, -122.446616785481) | 13 | 9 | 1 | 57 | 17 | |||
15190 | 210598 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 44 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | 16 | Width 4ft | Permit Number 9937 | 5995535.69173 | 2107072.5304 | 37.7653630851686 | -122.458674438482 | (37.7653630851686, -122.458674438482) | 15 | 5 | 11 | 56 | 12 | |
16111 | 231958 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 666 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1987 12:00:00 AM | 23 | Width 3ft | Permit Number 24827 | 6002282.99843 | 2098885.82408 | 37.7432698388419 | -122.434751624897 | (37.7432698388419, -122.434751624897) | 2 | 7 | 5 | 63 | 22 | |
16339 | 39482 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
16480 | 50938 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4752 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48543 | 5998450.03825367 | 2105698.06494287 | 37.7617562199837 | -122.448495440986 | (37.7617562199837, -122.448495440986) | 15 | 5 | 11 | 29492 | 9 | ||
16991 | 112614 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1799x 22ND ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 12/09/2015 12:00:00 AM | 3 | Permit Number 776524 | 6012792 | 2103743 | 37.7571976263526 | -122.398754797925 | (37.7571976263526, -122.398754797925) | 10 | 3 | 8 | 28856 | 29 | ||
17332 | 38426 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 126 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1999 12:00:00 AM | Permit Number 41732 | 6001233.109597 | 2094965.61225629 | 37.7324461904854 | -122.438101100943 | (37.7324461904854, -122.438101100943) | 9 | 7 | 5 | 63 | 40 | ||
17696 | 39128 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 755 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40809 | 6007359.12700155 | 2102919.00118427 | 37.7546309134503 | -122.417485428329 | (37.7546309134503, -122.417485428329) | 2 | 4 | 7 | 28859 | 19 | ||
17767 | 35283 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
18440 | 60477 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1343 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1982 12:00:00 AM | Permit Number 20072 | 6002221.27409585 | 2113110.91985101 | 37.7823249851452 | -122.435982713361 | (37.7823249851452, -122.435982713361) | 15 | 5 | 11 | 29490 | 41 | ||
18590 | 210743 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 45 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1972 12:00:00 AM | 14 | Width 4ft | Permit Number 9938 | 5995615.49185 | 2107032.26685 | 37.7652571180555 | -122.458395515563 | (37.7652571180555, -122.458395515563) | 15 | 5 | 11 | 56 | 12 | |
19289 | 210749 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 233 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2016 12:00:00 AM | 12 | Width 3ft | Permit Number 11397 | 5994993.96262 | 2107017.74813 | 37.7651815165374 | -122.460544170371 | (37.7651815165374, -122.460544170371) | 15 | 5 | 11 | 56 | 12 | |
19401 | 45516 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2975 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | Permit Number 44280 | 5988544.38188689 | 2095413.25132317 | 37.7329454972405 | -122.482001286035 | (37.7329454972405, -122.482001286035) | 1 | 8 | 4 | 64 | 35 | ||
19750 | 17216 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 299X Olive St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006076.21174 | 2113649.43361 | 37.7840218527702 | -122.422684597748 | (37.7840218527702, -122.422684597748) | 7 | 9 | 11 | 28858 | 41 | |||
20650 | 53524 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 226 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1969 12:00:00 AM | 3 | 3x3 | Permit Number 6436 | 5994753.48246338 | 2088426.05628518 | 37.7141195040923 | -122.460028964628 | (37.7141195040923, -122.460028964628) | 9 | 8 | 6 | 28861 | 24 | |
20783 | 42043 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | 2 | 4 | 5 | 28862 | 22 | ||
21121 | 51223 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 78 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2004 12:00:00 AM | Permit Number 47589 | 5999349.25090269 | 2107863.63052883 | 37.7677536935842 | -122.445541163796 | (37.7677536935842, -122.445541163796) | 15 | 5 | 11 | 29492 | 9 | ||
21201 | 47307 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 905 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45238 | 6009420.31304698 | 2103898.06138647 | 37.7574349528314 | -122.410426393727 | (37.7574349528314, -122.410426393727) | 2 | 4 | 7 | 28859 | 19 | ||
21706 | 88180 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 435 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51188 | 6011272.5 | 2112058.5 | 37.7799453198016 | -122.404595202044 | (37.7799453198016, -122.404595202044) | 14 | 2 | 9 | 28853 | 34 | ||
22392 | 4382 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2391X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007031.7831469 | 2120474.7837859 | 37.8028164322768 | -122.419863147129 | (37.8028164322768, -122.419863147129) | 5 | 1 | 1 | 28858 | 32 | |||
23017 | 17880 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2204 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003377.8686741 | 2115231.1135652 | 37.788212139478 | -122.432132867359 | (37.788212139478, -122.432132867359) | 13 | 9 | 1 | 29490 | 27 | |||
23770 | 39620 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 176 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41019 | 5997495.40415115 | 2106779.2398399 | 37.7646702234482 | -122.451875122756 | (37.7646702234482, -122.451875122756) | 15 | 5 | 11 | 29492 | 9 | ||
24003 | 48767 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 837 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | Permit Number 46025 | 6001146.78889593 | 2099651.30348098 | 37.7453070923234 | -122.438735172895 | (37.7453070923234, -122.438735172895) | 2 | 4 | 5 | 63 | 22 | |||
25049 | 33825 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 323 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1997 12:00:00 AM | 4 | Permit Number 37842 | 6006459.82825526 | 2097977.59191142 | 37.7410122846705 | -122.42024476202 | (37.7410122846705, -122.42024476202) | 2 | 7 | 7 | 28859 | 2 | ||
25147 | 87468 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 147 Laidley St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2008 12:00:00 AM | 3x3 | Permit Number 50383 | 6003836 | 2097532 | 37.7396405954937 | -122.429285233348 | (37.7396405954937, -122.429285233348) | 2 | 7 | 5 | 63 | 7 | |||
25642 | 103578 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
25812 | 42775 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 595 Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | 7 | 9 | 11 | 28852 | 10 | ||
25877 | 52000 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 222 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1973 12:00:00 AM | Permit Number 48218 | 6003679.11274535 | 2101599.81538645 | 37.7508009907308 | -122.430117797464 | (37.7508009907308, -122.430117797464) | 2 | 4 | 5 | 28862 | 22 | |||
26300 | 108974 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3059 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773634 | 6009172.8 | 2101543.2 | 37.7509551538616 | -122.411116061085 | (37.7509551538616, -122.411116061085) | 2 | 4 | 7 | 28859 | 19 |
26374 | 65083 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 453 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/09/1995 12:00:00 AM | Permit Number 27047 | 6010566.1381684 | 2112563.56806909 | 37.7812926155318 | -122.407074445388 | (37.7812926155318, -122.407074445388) | 14 | 2 | 9 | 28853 | 34 | ||
26382 | 82437 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 539 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50245 | 6009859.63908286 | 2098999.33240433 | 37.7440087468647 | -122.408561465079 | (37.7440087468647, -122.408561465079) | 2 | 7 | 7 | 28859 | 2 | ||
26538 | 49701 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3224@ PRECITA Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/25/2005 12:00:00 AM | Permit Number 46520 | 6008982.54318387 | 2099905.81339366 | 37.7464485829446 | -122.411658311185 | (37.7464485829446, -122.411658311185) | 2 | 7 | 7 | 28859 | 2 | ||
27253 | 108790 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 964 Avalon Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774648 | 6005260.71538 | 2092108.77889 | 37.7248301904685 | -122.423973622591 | (37.7248301904685, -122.423973622591) | 9 | 7 | 6 | 309 | 5 | |
27942 | 43715 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 31 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43356 | 5995595.90606819 | 2090114.46838183 | 37.7188039024441 | -122.457239310884 | (37.7188039024441, -122.457239310884) | 9 | 8 | 6 | 28861 | 24 | ||
29566 | 43027 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3615 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | Permit Number 42890 | 6005490.1381461 | 2105449.62279736 | 37.7614740690255 | -122.424128859066 | (37.7614740690255, -122.424128859066) | 2 | 4 | 5 | 28859 | 19 | |||
29924 | 46800 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 296 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44889 | 5994480.57701846 | 2094690.84310418 | 37.7313054013186 | -122.461426117294 | (37.7313054013186, -122.461426117294) | 9 | 8 | 4 | 59 | 40 | |||
31133 | 89121 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1455 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51791 | 6002022 | 2099858 | 37.7459243843383 | -122.435723628141 | (37.7459243843383, -122.435723628141) | 2 | 7 | 5 | 63 | 22 | ||
32165 | 103580 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
32285 | 39796 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1920 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
32349 | 88001 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 801 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952 | 2121180 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | 5 | 1 | 1 | 28858 | 32 | ||
32559 | 38709 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1900 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1998 12:00:00 AM | Permit Number 40614 | 6000044.14141087 | 2111300.00488868 | 37.7772287555823 | -122.443384488436 | (37.7772287555823, -122.443384488436) | 15 | 5 | 11 | 29490 | 16 | ||
32931 | 219812 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 580 Douglass St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782000 | 6001173.63424 | 2102984.05508 | 37.7544595580667 | -122.438881134568 | (37.7544595580667, -122.438881134568) | 2 | 4 | 5 | 28862 | 22 | |
33506 | 44313 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2150 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2001 12:00:00 AM | Permit Number 43711 | 6001880.60996644 | 2113983.70033588 | 37.7847020596058 | -122.437223769823 | (37.7847020596058, -122.437223769823) | 13 | 6 | 11 | 29490 | 13 | |||
33766 | 38707 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1900 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1998 12:00:00 AM | Permit Number 40614 | 6000044.14141087 | 2111300.00488868 | 37.7772287555823 | -122.443384488436 | (37.7772287555823, -122.443384488436) | 15 | 5 | 11 | 29490 | 16 | ||
33921 | 43570 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1604 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43231 | 6002560.91042795 | 2100907.07838403 | 37.7488355032508 | -122.433935126175 | (37.7488355032508, -122.433935126175) | 2 | 4 | 5 | 28862 | 22 | ||
34575 | 95869 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 585 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 767589 | 6010187.2 | 2119540 | 37.8004270041515 | -122.408877749885 | (37.8004270041515, -122.408877749885) | 3 | 1 | 10 | 308 | 23 | ||
34740 | 12506 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 LAKE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5995351 | 2115102 | 37.7873992668989 | -122.459894934345 | (37.7873992668989, -122.459894934345) | 11 | 6 | 1 | 54 | 11 | |||
35570 | 68419 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 94 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32262 | 5993499.28123568 | 2093584.8530568 | 37.728212096333 | -122.464738324511 | (37.728212096333, -122.464738324511) | 9 | 8 | 4 | 59 | 40 | ||
35665 | 37546 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 830 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39987 | 6008596.95727106 | 2115265.79023303 | 37.7886018721806 | -122.414078094846 | (37.7886018721806, -122.414078094846) | 5 | 1 | 10 | 28858 | 21 | ||
35922 | 11146 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
36811 | 46745 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | ||
37049 | 37025 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 410 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39635 | 6003833.74081357 | 2100145.79948593 | 37.7468173585654 | -122.429479398489 | (37.7468173585654, -122.429479398489) | 2 | 7 | 5 | 63 | 22 | ||
37165 | 84952 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 8 Kronquist Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2007 12:00:00 AM | Permit Number 49383 | 6002223 | 2100219 | 37.7469270204759 | -122.43505441311 | (37.7469270204759, -122.43505441311) | 2 | 7 | 5 | 63 | 22 | |||
37613 | 49955 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 823 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46736 | 6012467.34839499 | 2104144.40371857 | 37.7582816988758 | -122.399905762693 | (37.7582816988758, -122.399905762693) | 10 | 3 | 8 | 28856 | 29 | ||
37891 | 79374 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 532 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50243 | 6009806.51936766 | 2099019.13677638 | 37.7440601502387 | -122.40874653873 | (37.7440601502387, -122.40874653873) | 2 | 7 | 7 | 28859 | 2 | ||
38425 | 43408 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 521 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43151 | 6001773.04601386 | 2101442.02033721 | 37.7502595844098 | -122.436697841973 | (37.7502595844098, -122.436697841973) | 2 | 4 | 5 | 28862 | 22 | ||
38488 | 51294 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1217 Shafter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2004 12:00:00 AM | Permit Number 47666 | 6016937.80385774 | 2092637.74842389 | 37.7269349786738 | -122.383643722332 | (37.7269349786738, -122.383643722332) | 10 | 3 | 8 | 58 | 1 | |||
38591 | 103581 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 |
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) );