trees
3,709 rows where qSpecies_id = 9 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | ||||||||||||||
4304 | 17630 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 150 Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10M | |||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
15594 | 19769 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
17923 | 19768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
18560 | 19875 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY33 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
67 | 99921 | Section 806 (d) 5 | Olea europaea :: Olive Tree 9 | 1740 Jones St | 1 | Front Yard : Yard | Tree | Private 2 | 06/01/2015 12:00:00 AM | 3 | Permit Number 774389 | 6008331.64636 | 2118443.68708 | 37.7973126906849 | -122.415221079511 | (37.7973126906849, -122.415221079511) | 5 | 1 | 10 | 308 | 21 | ||
136 | 11131 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2400X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007074.9072505 | 2120528.613771 | 37.802966665104 | -122.419717737051 | (37.802966665104, -122.419717737051) | 5 | 1 | 1 | 28858 | 32 | |||
304 | 132028 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 33x Battery St | 1 | Median : Yard | Tree | DPW 1 | 27 | 6012842.61776 | 2116100.99756 | 37.7911327033699 | -122.399447311639 | (37.7911327033699, -122.399447311639) | 4 | 1 | 10 | 28854 | 6 | ||||
324 | 97786 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 810 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6012446.82878 | 2118928.41788 | 37.7988740576432 | -122.401015485586 | (37.7988740576432, -122.401015485586) | 3 | 1 | 10 | 28860 | 6 | |||
975 | 4380 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2421X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007006.0129161 | 2120659.6131485 | 37.8033224749672 | -122.419965449311 | (37.8033224749672, -122.419965449311) | 5 | 1 | 1 | 28858 | 32 | |||
1088 | 20259 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2015 07:41:00 AM | 3 | 3X3 | 6009947.7744 | 2120592.07204 | 37.8033023200197 | -122.40978056566 | (37.8033023200197, -122.40978056566) | 3 | 1 | 10 | 308 | 23 | ||
1842 | 11178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.8062914977061 | -122.420560679149 | (37.8062914977061, -122.420560679149) | 5 | 1 | 1 | 28858 | 32 | |||
3058 | 11168 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6006944.2763295 | 2121452.6056321 | 37.8054963520093 | -122.420235406119 | (37.8054963520093, -122.420235406119) | 5 | 1 | 1 | 28858 | 32 | |||
3400 | 71791 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 470 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6011261.07929 | 2119033.68709 | 37.7990968853742 | -122.405126006053 | (37.7990968853742, -122.405126006053) | 3 | 1 | 10 | 308 | 23 | |||
3655 | 131989 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006994.979 | 2120718.72375 | 37.803484156018 | -122.420007829916 | (37.803484156018, -122.420007829916) | 5 | 1 | 1 | 28858 | 32 | |||
5805 | 131998 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2526 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007014.37433 | 2120962.81861 | 37.8041554711661 | -122.419958043454 | (37.8041554711661, -122.419958043454) | 5 | 1 | 1 | 28858 | 32 | |||
7121 | 13051 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 548 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:01:00 PM | 3 | 3x3 | 6009711.5863 | 2120552.0553 | 37.803179205163 | -122.410595078527 | (37.803179205163, -122.410595078527) | 3 | 1 | 10 | 308 | 23 | ||
9669 | 71248 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1853 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009517.1243 | 2120069.0751 | 37.8018421572412 | -122.411233884286 | (37.8018421572412, -122.411233884286) | 3 | 1 | 10 | 308 | 23 | |||
10896 | 13070 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 630 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/05/2019 12:00:00 AM | 22 | 3x3 | 6009332.6794 | 2120506.3975 | 37.8030325899081 | -122.4119030734 | (37.8030325899081, -122.4119030734) | 3 | 1 | 10 | 308 | 23 | ||
10904 | 131990 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 12:00:00 AM | 3 | Width 3ft | 6006996.42169 | 2120694.04403 | 37.8034164730582 | -122.420001084983 | (37.8034164730582, -122.420001084983) | 5 | 1 | 1 | 28858 | 32 | ||
12828 | 131988 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 12:00:00 AM | 3 | Width 3ft | 6006993.00733 | 2120736.62098 | 37.8035331861796 | -122.420015923817 | (37.8035331861796, -122.420015923817) | 5 | 1 | 1 | 28858 | 32 | ||
13779 | 48583 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1172 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 6 | Permit Number 45898 | 6008021.61269 | 2118241.60717 | 37.7967404007911 | -122.416279558156 | (37.7967404007911, -122.416279558156) | 5 | 1 | 10 | 28858 | 21 | |
15274 | 74231 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2054 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6009468.6226 | 2120763.8774 | 37.8037471914209 | -122.411450838489 | (37.8037471914209, -122.411450838489) | 3 | 1 | 10 | 308 | 23 | |||
15600 | 131950 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 28 Russell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007151.45426 | 2118977.15538 | 37.7987110636187 | -122.419342718288 | (37.7987110636187, -122.419342718288) | 5 | 1 | 10 | 28858 | 32 | |||
16856 | 11172 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2717 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006856.95142 | 2121692.8865 | 37.8061511809927 | -122.420554673483 | (37.8061511809927, -122.420554673483) | 5 | 1 | 1 | 28858 | 32 | |||
19260 | 13019 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 426 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 01:54:00 PM | 3 | 4X4 | 6010271 | 2120661 | 37.8035096874313 | -122.408666892744 | (37.8035096874313, -122.408666892744) | 3 | 1 | 10 | 308 | 23 | ||
20204 | 132002 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2347 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007031.64315 | 2120451.58082 | 37.8027527149307 | -122.419861984153 | (37.8027527149307, -122.419861984153) | 5 | 1 | 1 | 28858 | 32 | |||
20724 | 112714 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 416 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008746.75593 | 2121471.08922 | 37.8056485022522 | -122.413998966505 | (37.8056485022522, -122.413998966505) | 3 | 1 | 10 | 308 | 23 | |||
21129 | 132012 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 902 Vallejo St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6009174.97876 | 2118751.12637 | 37.7982042021283 | -122.412324664466 | (37.7982042021283, -122.412324664466) | 3 | 1 | 10 | 308 | 21 | |||
21629 | 132003 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6007044.49031 | 2120339.60529 | 37.8024459822598 | -122.419809576178 | (37.8024459822598, -122.419809576178) | 5 | 1 | 1 | 28858 | 32 | |||
21812 | 132031 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6012377.67956 | 2118452.2597 | 37.7975627840449 | -122.401221288234 | (37.7975627840449, -122.401221288234) | 3 | 1 | 10 | 28860 | 4 | |||
21852 | 12978 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 300 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6010840.9455 | 2120711.3367 | 37.8036798042781 | -122.406698110931 | (37.8036798042781, -122.406698110931) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
23557 | 131943 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1657 Hyde St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6007355.06996 | 2118080.96965 | 37.7962618274862 | -122.418574556979 | (37.7962618274862, -122.418574556979) | 5 | 1 | 10 | 28858 | 32 | |||
25908 | 132007 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6007057.56905 | 2120239.89866 | 37.8021729498859 | -122.419757238308 | (37.8021729498859, -122.419757238308) | 5 | 1 | 1 | 28858 | 32 | |||
26318 | 11153 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2603 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006916.69653 | 2121280.21725 | 37.8050214634311 | -122.420318606842 | (37.8050214634311, -122.420318606842) | 5 | 1 | 1 | 28858 | 32 | |||
29341 | 107488 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 13 | Median : Cutout | Tree | DPW 1 | 6 | 6011453.59321 | 2119920.31769 | 37.8015421177278 | -122.404522284896 | (37.8015421177278, -122.404522284896) | 3 | 1 | 10 | 308 | 23 | ||||
30787 | 132008 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6007059.59383 | 2120223.92691 | 37.8021292095665 | -122.419749097642 | (37.8021292095665, -122.419749097642) | 5 | 1 | 1 | 28858 | 32 | |||
31824 | 84812 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 666 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | 6 | Permit No. 49331 | 6009753.6478 | 2119867.4125 | 37.8013017036595 | -122.410401151722 | (37.8013017036595, -122.410401151722) | 3 | 1 | 10 | 308 | 23 | ||
32147 | 131951 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 28 Russell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007136.46126 | 2118974.91701 | 37.7987040731903 | -122.419394440107 | (37.7987040731903, -122.419394440107) | 5 | 1 | 10 | 28858 | 32 | |||
32179 | 87737 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 9 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.28256 | 37.8051028305372 | -122.4252793245 | (37.8051028305372, -122.4252793245) | 5 | 1 | 1 | 28858 | 32 | ||
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 | ||
32723 | 143257 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 661 LOMBARD ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6009374.1767 | 2120464.0392 | 37.8029186125655 | -122.41175647573 | (37.8029186125655, -122.41175647573) | 3 | 1 | 10 | 308 | 23 | |||
32861 | 11174 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2721 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006871.9159428 | 2121607.3582758 | 37.8059171856884 | -122.420496811264 | (37.8059171856884, -122.420496811264) | 5 | 1 | 1 | 28858 | 32 | |||
33315 | 132044 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 444 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2002 12:00:00 AM | 7 | Width 4ft | 6012372.27446 | 2117831.7295 | 37.795858655114 | -122.401196364438 | (37.795858655114, -122.401196364438) | 3 | 1 | 10 | 28860 | 4 | ||
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 | ||
34833 | 11155 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2615 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6006917.28019 | 2121296.80497 | 37.805067041968 | -122.420317765078 | (37.805067041968, -122.420317765078) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
35927 | 131985 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006981.76086 | 2120815.46029 | 37.8037490252481 | -122.420060441131 | (37.8037490252481, -122.420060441131) | 5 | 1 | 1 | 28858 | 32 | |||
36787 | 132027 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 29 Alta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011619.60003 | 2119917.50994 | 37.8015436843535 | -122.403947625309 | (37.8015436843535, -122.403947625309) | 3 | 1 | 10 | 308 | 23 | |||
36863 | 131936 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1654 Hyde St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6007422.60958 | 2118093.12969 | 37.7962990180462 | -122.418341718011 | (37.7962990180462, -122.418341718011) | 5 | 1 | 10 | 28858 | 32 | |||
36974 | 131978 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2553 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006942.77558 | 2121093.18937 | 37.8045094020391 | -122.420215075084 | (37.8045094020391, -122.420215075084) | 5 | 1 | 1 | 28858 | 32 | |||
37560 | 1759 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2606X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006953 | 2121208 | 37.8048252188779 | -122.42018784574 | (37.8048252188779, -122.42018784574) | 5 | 1 | 1 | 28858 | 32 | |||
37823 | 132035 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 647 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6012461.09894 | 2118446.83137 | 37.7975525326807 | -122.400932251525 | (37.7975525326807, -122.400932251525) | 3 | 1 | 10 | 28860 | 4 | |||
37851 | 7706 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2500X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007008.1963938 | 2121001.9906569 | 37.8042626795816 | -122.41998220419 | (37.8042626795816, -122.41998220419) | 5 | 1 | 1 | 28858 | 32 | |||
39137 | 11183 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2765 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/1997 12:00:00 AM | 12 | 3X3 | 6006851.5978528 | 2121751.8788051 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | 5 | 1 | 1 | 28858 | 32 | ||
40790 | 132019 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1116 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | 6007503.17736 | 2119909.69915 | 37.8012913975493 | -122.41819179113 | (37.8012913975493, -122.41819179113) | 5 | 1 | 1 | 28858 | 32 | ||||
42403 | 131952 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 30 Russell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007110.60778 | 2118970.55106 | 37.798690629231 | -122.419483591709 | (37.798690629231, -122.419483591709) | 5 | 1 | 10 | 28858 | 32 | |||
43156 | 132011 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 43 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6007585.3855 | 2119382.38752 | 37.799848159233 | -122.417869913879 | (37.799848159233, -122.417869913879) | 5 | 1 | 1 | 28858 | 32 | ||||
45231 | 131964 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2616 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6006972.36413 | 2121248.27564 | 37.8049368965806 | -122.420123694077 | (37.8049368965806, -122.420123694077) | 5 | 1 | 1 | 28858 | 32 | |||
46156 | 11134 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2454 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007041.13953 | 2120754.1462 | 37.8035840176492 | -122.419850604133 | (37.8035840176492, -122.419850604133) | 5 | 1 | 1 | 28858 | 32 | |||
46511 | 88000 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 801 Bay St | 3 | 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 | ||
47475 | 131969 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 851 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006677.69504 | 2121126.15503 | 37.8045849774818 | -122.421134754189 | (37.8045849774818, -122.421134754189) | 5 | 1 | 1 | 28858 | 32 | |||
48925 | 131979 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2553 Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006943.6735 | 2121075.27291 | 37.8044602585979 | -122.420210695394 | (37.8044602585979, -122.420210695394) | 5 | 1 | 1 | 28858 | 32 | |||
52281 | 131991 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2423 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007008.85362 | 2120634.9778 | 37.803254992598 | -122.4199538697 | (37.803254992598, -122.4199538697) | 5 | 1 | 1 | 28858 | 32 | |||
52438 | 131984 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006962.8063 | 2120946.08648 | 37.8041066235873 | -122.420135310616 | (37.8041066235873, -122.420135310616) | 5 | 1 | 1 | 28858 | 32 | |||
54945 | 11135 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2454 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007038.94291 | 2120769.93446 | 37.8036272444521 | -122.419859326652 | (37.8036272444521, -122.419859326652) | 5 | 1 | 1 | 28858 | 32 | |||
58356 | 142625 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1701 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010023.1854 | 2119954.1032 | 37.8015548410599 | -122.409474550368 | (37.8015548410599, -122.409474550368) | 3 | 1 | 10 | 308 | 23 | |||
59462 | 132033 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6012415.9055 | 2118457.49881 | 37.7975793018971 | -122.40108938378 | (37.7975793018971, -122.40108938378) | 3 | 1 | 10 | 28860 | 4 | |||
60326 | 13084 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 11:03:00 AM | 3 | 3X3 | 6009204.3394 | 2120486.8898 | 37.8029718256171 | -122.412345818777 | (37.8029718256171, -122.412345818777) | 3 | 1 | 10 | 308 | 23 | ||
61173 | 37547 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 830 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 12 | Permit Number 39987 | 6008602.44706 | 2115263.43418 | 37.788595711371 | -122.414058934193 | (37.788595711371, -122.414058934193) | 5 | 1 | 10 | 28858 | 21 | |
61850 | 131983 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006960.65003 | 2120965.01562 | 37.8041584766956 | -122.420144116771 | (37.8041584766956, -122.420144116771) | 5 | 1 | 1 | 28858 | 32 | |||
62257 | 132025 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 31 Alta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011577.53087 | 2119913.7481 | 37.8015310048082 | -122.404092939544 | (37.8015310048082, -122.404092939544) | 3 | 1 | 10 | 308 | 23 | |||
62815 | 87731 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.28256 | 37.8051028305372 | -122.4252793245 | (37.8051028305372, -122.4252793245) | 5 | 1 | 1 | 28858 | 32 | ||
62969 | 143256 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 661 LOMBARD ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6009354.5304 | 2120461.1132 | 37.8029094763595 | -122.411824255457 | (37.8029094763595, -122.411824255457) | 3 | 1 | 10 | 308 | 23 | |||
67638 | 107486 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 8 | Median : Cutout | Tree | DPW 1 | 9 | 6011455.57226 | 2119886.90358 | 37.8014504813279 | -122.404513083014 | (37.8014504813279, -122.404513083014) | 3 | 1 | 10 | 308 | 23 | ||||
67718 | 131994 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2423 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007017.73446 | 2120554.82778 | 37.8030354213191 | -122.419917446259 | (37.8030354213191, -122.419917446259) | 5 | 1 | 1 | 28858 | 32 | |||
69612 | 97787 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 810 Battery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012442.48599 | 2118956.93353 | 37.7989521125088 | -122.401032517841 | (37.7989521125088, -122.401032517841) | 3 | 1 | 10 | 28860 | 6 | |||
70015 | 73571 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1831 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51558 | 6009530.0528 | 2119982.9616 | 37.8016064359732 | -122.411183059023 | (37.8016064359732, -122.411183059023) | 3 | 1 | 10 | 308 | 23 | |
70258 | 87733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005465.59287 | 2121464.41753 | 37.8054453543938 | -122.425353437905 | (37.8054453543938, -122.425353437905) | 5 | 1 | 1 | 28858 | 32 | ||
72200 | 143254 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 661 LOMBARD ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6009304.3696 | 2120454.8431 | 37.8028894460766 | -122.411997395012 | (37.8028894460766, -122.411997395012) | 3 | 1 | 10 | 308 | 23 | |||
74108 | 107482 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 4 | Median : Cutout | Tree | DPW 1 | 5 | 6011457.97806 | 2119852.64786 | 37.8013565579188 | -122.404502345126 | (37.8013565579188, -122.404502345126) | 3 | 1 | 10 | 308 | 23 | ||||
74994 | 87736 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 8 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.28256 | 37.8051028305372 | -122.4252793245 | (37.8051028305372, -122.4252793245) | 5 | 1 | 1 | 28858 | 32 | ||
75048 | 251405 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 540 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:08:00 PM | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | 3 | 1 | 10 | 308 | 23 | |||
76007 | 107485 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 7 | Median : Cutout | Tree | DPW 1 | 5 | 6011457.45538 | 2119866.47345 | 37.8013944904094 | -122.404505127604 | (37.8013944904094, -122.404505127604) | 3 | 1 | 10 | 308 | 23 | ||||
76145 | 87732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005468.85489 | 2121438.02655 | 37.8053730758726 | -122.425340270033 | (37.8053730758726, -122.425340270033) | 5 | 1 | 1 | 28858 | 32 | ||
76276 | 11166 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2655 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006897.54428 | 2121449.51941 | 37.8054852447207 | -122.420396909886 | (37.8054852447207, -122.420396909886) | 5 | 1 | 1 | 28858 | 32 | |||
76712 | 132018 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 955 Green St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6008453.78402 | 2118980.23859 | 37.798792791306 | -122.414836443949 | (37.798792791306, -122.414836443949) | 5 | 1 | 10 | 308 | 32 | ||||
77610 | 132032 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6012396.48224 | 2118454.98922 | 37.7975713276168 | -122.401156417438 | (37.7975713276168, -122.401156417438) | 3 | 1 | 10 | 28860 | 4 | |||
80466 | 132005 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007046.81462 | 2120319.61315 | 37.8023912198477 | -122.419800113487 | (37.8023912198477, -122.419800113487) | 5 | 1 | 1 | 28858 | 32 | |||
83772 | 132042 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 38 Gold St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012073.61656 | 2118198.71012 | 37.7968496297558 | -122.402255597631 | (37.7968496297558, -122.402255597631) | 3 | 1 | 10 | 308 | 4 | |||
84138 | 132036 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 647 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012461.83664 | 2118431.88129 | 37.7975115244927 | -122.400928647939 | (37.7975115244927, -122.400928647939) | 3 | 1 | 10 | 28860 | 4 |
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) );