trees
6,714 rows where qSpecies_id = 7 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
1515 | 31846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
3055 | 20039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
3242 | 43297 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2000 12:00:00 AM | Permit Number 43066 | |||||||||||||
4991 | 20043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
6396 | 36746 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39516 | |||||||||||||
7114 | 20035 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
7286 | 33084 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
7976 | 20040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
9521 | 35167 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1998 12:00:00 AM | Permit Number 38700 | |||||||||||||
9968 | 31847 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14278 | 31848 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14721 | 20044 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
18188 | 33083 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
18800 | 20042 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
19322 | 46857 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44926 | ||||||||||||||
72 | 135801 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 16 Phoenix Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6008610.92916 | 2117913.61927 | 37.7958729471262 | -122.414217164494 | (37.7958729471262, -122.414217164494) | 5 | 1 | 10 | 308 | 21 | |||
752 | 32695 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1106 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 5 | 3x3 | Permit Number 37103 | 6008138.63139 | 2115547.98028 | 37.7893509440283 | -122.415683826556 | (37.7893509440283, -122.415683826556) | 13 | 1 | 10 | 28858 | 21 |
1955 | 55970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1246 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2017 12:00:00 AM | 3 | Permit Number 12041 | 6008815.91632 | 2116679.99391 | 37.7924972267216 | -122.413420580993 | (37.7924972267216, -122.413420580993) | 5 | 1 | 10 | 28857 | 21 | ||
2984 | 261389 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 611 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010649.76194 | 2118553.23001 | 37.7977434736118 | -122.407207494731 | (37.7977434736118, -122.407207494731) | 3 | 1 | 10 | 308 | 4 | |||||
3324 | 100985 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 03/23/2016 02:34:00 PM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |
5789 | 142614 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 GREENWICH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6009469.9119 | 2120131.871 | 37.8020119312896 | -122.411401700731 | (37.8020119312896, -122.411401700731) | 3 | 1 | 10 | 308 | 23 | |||
5866 | 73526 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 807 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009578.52705 | 2116144.74687 | 37.7910703569642 | -122.410744096059 | (37.7910703569642, -122.410744096059) | 5 | 1 | 10 | 28857 | 21 | |||
7922 | 135849 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2456 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007515.30382 | 2120841.49853 | 37.8038505659037 | -122.418215928918 | (37.8038505659037, -122.418215928918) | 5 | 1 | 1 | 308 | 32 | |||
8792 | 71157 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 807 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009578.49301 | 2116131.05118 | 37.7910327500084 | -122.410743246197 | (37.7910327500084, -122.410743246197) | 5 | 1 | 10 | 28857 | 21 | |||
13711 | 50946 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1134 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2014 12:00:00 AM | 3 | Permit Number 773916 | 6007565.24376916 | 2118876.40998362 | 37.7984577381814 | -122.417903725033 | (37.7984577381814, -122.417903725033) | 5 | 1 | 10 | 28858 | 32 | ||
14977 | 71423 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6009442.6696 | 2120129.5624 | 37.8020040644534 | -122.411495809181 | (37.8020040644534, -122.411495809181) | 3 | 1 | 10 | 308 | 23 | |||
17117 | 142613 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009456.5216 | 2120130.9476 | 37.8020086448232 | -122.411447972427 | (37.8020086448232, -122.411447972427) | 3 | 1 | 10 | 308 | 23 | |||
17712 | 71441 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6012101.83844 | 2118902.5962 | 37.7987839069199 | -122.402207456009 | (37.7987839069199, -122.402207456009) | 3 | 1 | 10 | 28860 | 6 | |||
21157 | 53443 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1955 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | 5 | Permit Number 23058 | 6007695.32961 | 2119167.05545 | 37.7992630980807 | -122.417474195999 | (37.7992630980807, -122.417474195999) | 5 | 1 | 10 | 28858 | 32 | |
24124 | 142520 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 7 | Width 0ft | 6009467.3323 | 2121175.1455 | 37.8048763586912 | -122.411484377145 | (37.8048763586912, -122.411484377145) | 3 | 1 | 10 | 308 | 23 | |||
25627 | 142658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 396 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009447.6089 | 2121213.6739 | 37.8049810417497 | -122.411555356166 | (37.8049810417497, -122.411555356166) | 3 | 1 | 10 | 308 | 23 | |||
26062 | 142655 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 55 VANDEWATER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009102.8791 | 2121306.4263 | 37.8052163739487 | -122.412754898161 | (37.8052163739487, -122.412754898161) | 3 | 1 | 10 | 308 | 23 | |||
27328 | 249807 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 258 Chestnut St | 6 | Back Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6010752.11734 | 2121021.55825 | 37.8045266258517 | -122.407027386026 | (37.8045266258517, -122.407027386026) | 3 | 1 | 10 | 308 | 23 | |||
27375 | 135795 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1106 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008156.60543 | 2115549.40456 | 37.7893558651186 | -122.415621739153 | (37.7893558651186, -122.415621739153) | 13 | 1 | 10 | 28858 | 21 | |||
28687 | 135856 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 220 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011197.01398 | 2120748.14382 | 37.803800783049 | -122.405468504785 | (37.803800783049, -122.405468504785) | 3 | 1 | 10 | 308 | 23 | |||
30108 | 135842 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1177 Greenwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6007263.48219 | 2119827.6474 | 37.8010526095424 | -122.419015420851 | (37.8010526095424, -122.419015420851) | 5 | 1 | 1 | 28858 | 32 | ||||
30486 | 142534 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2100 POWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6009442.0785 | 2120933.4916 | 37.8042114208681 | -122.411554687027 | (37.8042114208681, -122.411554687027) | 3 | 1 | 10 | 308 | 23 | |||
31121 | 135811 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1188 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007357.99127 | 2118847.16 | 37.7983657590324 | -122.418618809023 | (37.7983657590324, -122.418618809023) | 5 | 1 | 10 | 28858 | 32 | |||
31296 | 135822 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1941 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007711.58797 | 2119054.8847 | 37.7989560200535 | -122.417409982592 | (37.7989560200535, -122.417409982592) | 5 | 1 | 10 | 28858 | 32 | |||
31713 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 1150 Lombard St | 10 | Front Yard : Yard | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.420576003873 | (37.8027004912885, -122.420576003873) | 5 | 1 | 1 | 28858 | 32 | ||
35451 | 65039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1989 12:00:00 AM | 6 | Permit Number 26091 | 6008677.06955 | 2119030.1621 | 37.7989424124088 | -122.414067334761 | (37.7989424124088, -122.414067334761) | 5 | 1 | 10 | 308 | 32 | ||
35699 | 121688 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 800 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6008462.12689 | 2120388.3747 | 37.8026596503908 | -122.414907290765 | (37.8026596503908, -122.414907290765) | 5 | 1 | 10 | 308 | 32 | ||||
36477 | 249963 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 271 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6011592.60874 | 2120072.38059 | 37.8019674134157 | -122.404051933175 | (37.8019674134157, -122.404051933175) | 3 | 1 | 10 | 308 | 23 | |||
37974 | 142616 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1867 POWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009512.0452 | 2120108.7843 | 37.801950904005 | -122.411254267134 | (37.801950904005, -122.411254267134) | 3 | 1 | 10 | 308 | 23 | |||
40310 | 13074 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 645X Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | |||
40495 | 249833 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 333 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011234.89731 | 2120366.37397 | 37.8027546547576 | -122.405310505601 | (37.8027546547576, -122.405310505601) | 3 | 1 | 10 | 308 | 23 | |||
42347 | 135851 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 787 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007518.53532 | 2120901.3436 | 37.8040150672041 | -122.418208991563 | (37.8040150672041, -122.418208991563) | 5 | 1 | 1 | 308 | 32 | |||
45294 | 135858 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 220 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011178.53707 | 2120744.35584 | 37.8037893490595 | -122.405532178584 | (37.8037893490595, -122.405532178584) | 3 | 1 | 10 | 308 | 23 | |||
45702 | 113955 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1441 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009717.46061 | 2118594.91218 | 37.7978057026147 | -122.410436472191 | (37.7978057026147, -122.410436472191) | 3 | 1 | 10 | 308 | 4 | |||
47208 | 249808 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 258 Chestnut St | 7 | Back Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6010714.23144 | 2121016.75548 | 37.8045113184913 | -122.407158155531 | (37.8045113184913, -122.407158155531) | 3 | 1 | 10 | 308 | 23 | |||
47976 | 135834 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6008624.12392 | 2119028.66096 | 37.7989353167715 | -122.414250438519 | (37.7989353167715, -122.414250438519) | 5 | 1 | 10 | 308 | 32 | |||
49676 | 135819 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1955 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007698.59451 | 2119147.16202 | 37.7992086594047 | -122.417461487661 | (37.7992086594047, -122.417461487661) | 5 | 1 | 10 | 28858 | 32 | |||
50273 | 135846 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2430 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6007526.598 | 2120747.58183 | 37.8035933301309 | -122.41817018222 | (37.8035933301309, -122.41817018222) | 5 | 1 | 1 | 308 | 32 | |||
52032 | 135836 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6008591.77677 | 2119025.88036 | 37.7989258649019 | -122.41436217388 | (37.7989258649019, -122.41436217388) | 5 | 1 | 10 | 308 | 32 | |||
52923 | 249809 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 258 Chestnut St | 8 | Back Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010708.45628 | 2121025.23541 | 37.8045342790877 | -122.407178739215 | (37.8045342790877, -122.407178739215) | 3 | 1 | 10 | 308 | 23 | |||
53270 | 143244 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1913 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6009926.8482 | 2120632.4472 | 37.8034120074717 | -122.409855833569 | (37.8034120074717, -122.409855833569) | 3 | 1 | 10 | 308 | 23 | |||
53654 | 142540 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2100 POWELL ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009421.7884 | 2121061.7254 | 37.8045623807522 | -122.411633968656 | (37.8045623807522, -122.411633968656) | 3 | 1 | 10 | 308 | 23 | |||
54918 | 135804 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1613 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008352.68547 | 2117970.55983 | 37.7960147828127 | -122.415114771533 | (37.7960147828127, -122.415114771533) | 5 | 1 | 10 | 28858 | 21 | |||
57068 | 85390 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1060 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2007 12:00:00 AM | 5 | Permit Number 49660 | 6009093.49986 | 2117706.63601 | 37.7953317162473 | -122.412532734295 | (37.7953317162473, -122.412532734295) | 3 | 1 | 10 | 308 | 21 | ||
60169 | 135857 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 220 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011195.52799 | 2120759.07991 | 37.8038307277799 | -122.405474417834 | (37.8038307277799, -122.405474417834) | 3 | 1 | 10 | 308 | 23 | |||
62880 | 62976 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1950 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 7 | Permit Number 23365 | 6007747.12203 | 2119162.34513 | 37.7992530787278 | -122.417294641847 | (37.7992530787278, -122.417294641847) | 5 | 1 | 10 | 308 | 32 | |
64171 | 249873 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 230 Greenwich St | 9 | Back Yard : Yard | Tree | Private 2 | 26 | Width 0ft | 6011670.78297 | 2120474.23594 | 37.8030751776447 | -122.403809705266 | (37.8030751776447, -122.403809705266) | 3 | 1 | 10 | 28860 | 6 | |||
64459 | 53232 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1469 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1991 12:00:00 AM | 10 | Permit Number 29642 | 6007065.8379 | 2117721.11108 | 37.7952574583051 | -122.419549817763 | (37.7952574583051, -122.419549817763) | 5 | 1 | 10 | 28858 | 32 | ||
65747 | 53178 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2420 REVISED Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2006 12:00:00 AM | 5 | Permit Number 49096 | 6007531.88349 | 2120715.221 | 37.8035047729776 | -122.418149595852 | (37.8035047729776, -122.418149595852) | 5 | 1 | 1 | 308 | 32 | ||
66909 | 135840 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1177 Greenwich St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6007238.19952 | 2119824.86734 | 37.8010435524736 | -122.419102712642 | (37.8010435524736, -122.419102712642) | 5 | 1 | 1 | 28858 | 32 | ||||
69988 | 249835 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 333 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6011233.03828 | 2120380.52255 | 37.8027933993566 | -122.40531793578 | (37.8027933993566, -122.40531793578) | 3 | 1 | 10 | 308 | 23 | |||
71064 | 135847 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2434 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6007523.40269 | 2120763.66368 | 37.8036373069691 | -122.418182380615 | (37.8036373069691, -122.418182380615) | 5 | 1 | 1 | 308 | 32 | |||
72088 | 135832 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 11 | Front Yard : Yard | Tree | Private 2 | 4 | 6008638.14569 | 2119013.6558 | 37.7988949039377 | -122.414200856206 | (37.7988949039377, -122.414200856206) | 5 | 1 | 10 | 308 | 32 | ||||
72760 | 135833 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 12 | Front Yard : Yard | Tree | Private 2 | 2 | 6008637.50385 | 2119009.84925 | 37.7988844160443 | -122.414202807733 | (37.7988844160443, -122.414202807733) | 5 | 1 | 10 | 308 | 32 | ||||
74062 | 106161 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 827 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770049 | 6006757.57528 | 2121490.32366 | 37.8055893943007 | -122.420884191365 | (37.8055893943007, -122.420884191365) | 5 | 1 | 1 | 28858 | 32 | |
74533 | 135835 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6008609.07224 | 2119027.30535 | 37.7989307491201 | -122.414302426519 | (37.7989307491201, -122.414302426519) | 5 | 1 | 10 | 308 | 32 | |||
76016 | 135859 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 220 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011176.6986 | 2120755.37641 | 37.8038195060395 | -122.405539317394 | (37.8038195060395, -122.405539317394) | 3 | 1 | 10 | 308 | 23 | |||
77449 | 13073 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 645X Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | |||
77623 | 249829 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 339 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011201.84726 | 2120367.04696 | 37.8027546547757 | -122.405424923615 | (37.8027546547757, -122.405424923615) | 3 | 1 | 10 | 308 | 23 | |||
79948 | 135854 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 220 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011219.52919 | 2120749.38326 | 37.8038054451262 | -122.405390676534 | (37.8038054451262, -122.405390676534) | 3 | 1 | 10 | 28860 | 23 | |||
80029 | 55403 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1254 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/1973 12:00:00 AM | 7 | Permit Number 11342 | 6011509.51714 | 2119661.57098 | 37.8008347874628 | -122.404310539521 | (37.8008347874628, -122.404310539521) | 3 | 1 | 10 | 308 | 23 | ||
80924 | 135806 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 22 Aladdin Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6008809.71493 | 2119549.22227 | 37.8003750720026 | -122.413645068874 | (37.8003750720026, -122.413645068874) | 3 | 1 | 10 | 308 | 32 | |||
81802 | 113954 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1441 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6009714.20821 | 2118628.89779 | 37.797898836429 | -122.410450127476 | (37.797898836429, -122.410450127476) | 3 | 1 | 10 | 308 | 4 | |||
81844 | 112372 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 15 Vandewater St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009194.601 | 2121319.3086 | 37.8052568931935 | -122.412438393162 | (37.8052568931935, -122.412438393162) | 3 | 1 | 10 | 308 | 23 | |||
81940 | 142537 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 2100 POWELL ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009436.3973 | 2120993.5505 | 37.8043760089549 | -122.411578593269 | (37.8043760089549, -122.411578593269) | 3 | 1 | 10 | 308 | 23 | |||
83714 | 135818 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1071 Lombard St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6007217.26018 | 2120160.17933 | 37.8019630553145 | -122.419198970666 | (37.8019630553145, -122.419198970666) | 5 | 1 | 1 | 28858 | 32 | |||
89075 | 135831 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008642.51144 | 2119028.50949 | 37.7989359337052 | -122.414186800682 | (37.7989359337052, -122.414186800682) | 5 | 1 | 10 | 308 | 32 | |||
89350 | 142736 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 15 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6009218.8197 | 2121322.4003 | 37.805266741303 | -122.412354799662 | (37.805266741303, -122.412354799662) | 3 | 1 | 10 | 308 | 23 | |||
91477 | 135843 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1175 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 6007285.97876 | 2119831.24581 | 37.8010637566478 | -122.418937828239 | (37.8010637566478, -122.418937828239) | 5 | 1 | 1 | 28858 | 32 | |||
92199 | 250005 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 232 Filbert St | 3 | Side Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011493.8796 | 2120090.77159 | 37.802012393927 | -122.404394879735 | (37.802012393927, -122.404394879735) | 3 | 1 | 10 | 308 | 23 | |||
93450 | 135839 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1177 Greenwich St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6007217.01278 | 2119823.01799 | 37.8010372815012 | -122.419175896763 | (37.8010372815012, -122.419175896763) | 5 | 1 | 1 | 28858 | 32 | ||||
94778 | 135852 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 13 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6008609.879 | 2119160.01046 | 37.7992951697024 | -122.414309029333 | (37.7992951697024, -122.414309029333) | 5 | 1 | 10 | 308 | 32 | ||||
95678 | 249933 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 345 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011225.47356 | 2120026.31802 | 37.801820417444 | -122.405319155254 | (37.801820417444, -122.405319155254) | 3 | 1 | 10 | 308 | 23 | |||
97260 | 135820 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1955 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007700.92901 | 2119129.01998 | 37.7991589772563 | -122.417452123041 | (37.7991589772563, -122.417452123041) | 5 | 1 | 10 | 28858 | 32 | |||
97682 | 249969 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 213 Filbert St | 2 | Back Yard : Yard | Tree | Private 2 | 28 | Width 0ft | 6011730.79134 | 2120085.86253 | 37.8020121511077 | -122.403574702535 | (37.8020121511077, -122.403574702535) | 3 | 1 | 10 | 308 | 23 | |||
98213 | 143084 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 463 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010663.1497 | 2120298.4418 | 37.8025361473527 | -122.407284261185 | (37.8025361473527, -122.407284261185) | 3 | 1 | 10 | 308 | 23 | |||
99006 | 143215 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 215 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010264.7976 | 2121285.9953 | 37.805225422299 | -122.408732475128 | (37.805225422299, -122.408732475128) | 3 | 1 | 10 | 308 | 23 | |||
99928 | 135821 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1941 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007709.39539 | 2119079.95376 | 37.7990247300556 | -122.417419347243 | (37.7990247300556, -122.417419347243) | 5 | 1 | 10 | 28858 | 32 | |||
101994 | 142615 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 GREENWICH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009481.4553 | 2120134.1797 | 37.8020189178421 | -122.411361918128 | (37.8020189178421, -122.411361918128) | 3 | 1 | 10 | 308 | 23 | |||
102060 | 135829 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 6 | Front Yard : Yard | Tree | Private 2 | 2 | 6008653.20032 | 2119016.0444 | 37.7989023080442 | -122.414148931139 | (37.7989023080442, -122.414148931139) | 5 | 1 | 10 | 308 | 32 | ||||
102284 | 135828 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008658.00325 | 2119030.21476 | 37.7989414861063 | -122.414133314422 | (37.7989414861063, -122.414133314422) | 5 | 1 | 10 | 308 | 32 | |||
102731 | 135797 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1272 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008693.37353 | 2116663.42391 | 37.7924448483907 | -122.41384341164 | (37.7924448483907, -122.41384341164) | 5 | 1 | 10 | 28857 | 21 | |||
106099 | 50376 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1620 Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | 3 | 1 | 10 | 28860 | 6 | |||
106674 | 135838 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1177 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6007200.95123 | 2119822.58623 | 37.8010351914662 | -122.419231446093 | (37.8010351914662, -122.419231446093) | 5 | 1 | 1 | 28858 | 32 |
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) );