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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
106695 | 100983 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
108691 | 135850 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2456 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6007513.5376 | 2120862.81684 | 37.8039090011686 | -122.418223553398 | (37.8039090011686, -122.418223553398) | 5 | 1 | 1 | 308 | 32 | |||
110944 | 113956 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1441 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2016 12:00:00 AM | 3 | 3x3 | 6009720.54591 | 2118583.26701 | 37.7977739007953 | -122.410424973449 | (37.7977739007953, -122.410424973449) | 3 | 1 | 10 | 308 | 4 | ||
111901 | 143251 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 661 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009160.7844 | 2120435.4058 | 37.8028280191875 | -122.412492900836 | (37.8028280191875, -122.412492900836) | 3 | 1 | 10 | 308 | 23 | |||
114107 | 58353 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1225 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1978 12:00:00 AM | 10 | Permit Number 17380 | 6008953.55358 | 2117165.29017 | 37.793837458489 | -122.412978678424 | (37.793837458489, -122.412978678424) | 5 | 1 | 10 | 28857 | 21 | ||
114398 | 135825 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 941 Vallejo St | 3 | Front Yard : Yard | Tree | Private 2 | 11 | 6008892.44244 | 2118672.21795 | 37.7979716806151 | -122.413296744356 | (37.7979716806151, -122.413296744356) | 3 | 1 | 10 | 308 | 21 | ||||
115679 | 98564 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301X Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
115748 | 135860 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 408 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012109.41094 | 2118121.35033 | 37.796639216288 | -122.402126298508 | (37.796639216288, -122.402126298508) | 3 | 1 | 10 | 28860 | 4 | |||
116460 | 249982 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 224 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011639.74764 | 2120113.25639 | 37.8020822820333 | -122.403891687471 | (37.8020822820333, -122.403891687471) | 3 | 1 | 10 | 308 | 23 | |||
118467 | 249937 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 339 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011248.56733 | 2120031.66705 | 37.8018363956996 | -122.405239616532 | (37.8018363956996, -122.405239616532) | 3 | 1 | 10 | 308 | 23 | |||
118915 | 249847 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 289 Greenwich St | 4 | Side Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011426.79495 | 2120392.20909 | 37.8028363185975 | -122.40464825831 | (37.8028363185975, -122.40464825831) | 3 | 1 | 10 | 308 | 23 | |||
120457 | 66601 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1111 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | 9 | Permit Number 29794 | 6008473.92013 | 2115892.33746 | 37.7903153068679 | -122.414548140207 | (37.7903153068679, -122.414548140207) | 5 | 1 | 10 | 28858 | 21 | |
121260 | 66599 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 909 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | 7 | Permit Number 29792 | 6008202.5884 | 2115154.13116 | 37.7882731254512 | -122.415434647804 | (37.7882731254512, -122.415434647804) | 13 | 1 | 10 | 28858 | 21 | |
121686 | 135827 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | 6008668.93858 | 2119018.75606 | 37.7989106375677 | -122.414094663337 | (37.7989106375677, -122.414094663337) | 5 | 1 | 10 | 308 | 32 | ||||
121772 | 65968 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 990 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1990 12:00:00 AM | 4 | Permit Number 28992 | 6007125.46509 | 2120550.16631 | 37.8030286907859 | -122.419544310327 | (37.8030286907859, -122.419544310327) | 5 | 1 | 1 | 28858 | 32 | ||
122784 | 142628 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1922 MASON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009103.5255 | 2119888.7677 | 37.8013238735379 | -122.41265238046 | (37.8013238735379, -122.41265238046) | 3 | 1 | 10 | 308 | 4 | |||
125056 | 249810 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 258 Chestnut St | 9 | Back Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010696.08755 | 2121019.21593 | 37.8045170588744 | -122.407221117962 | (37.8045170588744, -122.407221117962) | 3 | 1 | 10 | 308 | 23 | |||
127595 | 135824 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1013 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 6008637.906 | 2118634.49639 | 37.7978538127598 | -122.414174846001 | (37.7978538127598, -122.414174846001) | 5 | 1 | 10 | 308 | 21 | ||||
128106 | 135848 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2434 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6007523.24086 | 2120777.27009 | 37.8036746576187 | -122.418183905875 | (37.8036746576187, -122.418183905875) | 5 | 1 | 1 | 308 | 32 | |||
128774 | 135774 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 909 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008228.42791 | 2115155.74363 | 37.788279005205 | -122.415345361306 | (37.788279005205, -122.415345361306) | 13 | 1 | 10 | 28858 | 21 | |||
128965 | 135853 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 12 Filbert St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 26 | 6012286.0131 | 2120198.43277 | 37.8023522396158 | -122.401661277048 | (37.8023522396158, -122.401661277048) | 3 | 1 | 10 | 28860 | 6 | ||||
130873 | 143252 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 661 LOMBARD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009254.6269 | 2120447.319 | 37.8028659958274 | -122.412168998949 | (37.8028659958274, -122.412168998949) | 3 | 1 | 10 | 308 | 23 | |||
132915 | 100984 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
133883 | 104476 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 350X Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2013 12:00:00 AM | 3 | 3x3 | Permit Number 767241 | 6012304.0596 | 2118478.64735 | 37.7976311307414 | -122.401477889986 | (37.7976311307414, -122.401477889986) | 3 | 1 | 10 | 28860 | 6 | |
133989 | 135823 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1015 Vallejo St | 3 | Front Yard : Yard | Tree | Private 2 | 15 | 6008630.16296 | 2118635.32656 | 37.7978556572789 | -122.414201697946 | (37.7978556572789, -122.414201697946) | 5 | 1 | 10 | 308 | 21 | ||||
134500 | 142542 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | Width 0ft | 6009433.8643 | 2121170.962 | 37.8048629945672 | -122.411599901453 | (37.8048629945672, -122.411599901453) | 3 | 1 | 10 | 308 | 23 | |||
136431 | 135803 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1613 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008351.40157 | 2117990.56163 | 37.7960696306569 | -122.415120630606 | (37.7960696306569, -122.415120630606) | 5 | 1 | 10 | 28858 | 21 | |||
136640 | 249970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 213 Filbert St | 1 | Back Yard : Yard | Tree | Private 2 | 31 | Width 0ft | 6011737.03783 | 2120086.51138 | 37.8020142816062 | -122.403553132272 | (37.8020142816062, -122.403553132272) | 3 | 1 | 10 | 308 | 23 | |||
137709 | 135855 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 220 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011218.6149 | 2120762.89652 | 37.8038424981016 | -122.405394792746 | (37.8038424981016, -122.405394792746) | 3 | 1 | 10 | 28860 | 23 | |||
139024 | 135796 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1111 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008501.86888 | 2115894.99967 | 37.7903241867696 | -122.414451627648 | (37.7903241867696, -122.414451627648) | 5 | 1 | 10 | 28858 | 21 | |||
140281 | 118368 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 55 Vandewater St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 6009048.7736 | 2121299.2122 | 37.8051935288948 | -122.412941627226 | (37.8051935288948, -122.412941627226) | 3 | 1 | 10 | 308 | 23 | |||
141885 | 135798 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 17 Phoenix Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6008602.03293 | 2117913.01159 | 37.795870778879 | -122.41424790421 | (37.795870778879, -122.41424790421) | 5 | 1 | 10 | 308 | 21 | |||
143700 | 50379 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1620 Montgomery St | 3 | 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 | |||
145225 | 98567 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301X Francisco St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
145599 | 142657 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 392 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009464.6135 | 2121214.7045 | 37.8049848253291 | -122.411496582459 | (37.8049848253291, -122.411496582459) | 3 | 1 | 10 | 308 | 23 | |||
146104 | 142610 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2424 JONES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008008.0914 | 2120777.2854 | 37.8037019783089 | -122.416506051836 | (37.8037019783089, -122.416506051836) | 5 | 1 | 10 | 308 | 32 | |||
147517 | 135837 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2333 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007565.4054 | 2120114.29452 | 37.8018566673237 | -122.417990966211 | (37.8018566673237, -122.417990966211) | 5 | 1 | 1 | 28858 | 32 | |||
149171 | 142656 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 382 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009478.0111 | 2121215.2198 | 37.8049869916815 | -122.411450254798 | (37.8049869916815, -122.411450254798) | 3 | 1 | 10 | 308 | 23 | |||
149373 | 142536 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2100 POWELL ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009440.4553 | 2120971.6371 | 37.8043160678486 | -122.411563000977 | (37.8043160678486, -122.411563000977) | 3 | 1 | 10 | 308 | 23 | |||
153778 | 142519 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | Width 0ft | 6009452.9889 | 2121171.5596 | 37.8048657081731 | -122.411533760714 | (37.8048657081731, -122.411533760714) | 3 | 1 | 10 | 308 | 23 | |||
154208 | 118370 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 55 Vandewater St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 2x2 | 6009076.084 | 2121302.8193 | 37.8052049660579 | -122.412847371079 | (37.8052049660579, -122.412847371079) | 3 | 1 | 10 | 308 | 23 | |||
155622 | 135810 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1170 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6007401.72431 | 2118852.7144 | 37.7983834720705 | -122.418467873091 | (37.7983834720705, -122.418467873091) | 5 | 1 | 10 | 28858 | 32 | |||
157426 | 135800 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 16 Phoenix Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6008612.60281 | 2117902.3687 | 37.7958421498461 | -122.414210576953 | (37.7958421498461, -122.414210576953) | 5 | 1 | 10 | 308 | 21 | |||
157859 | 142744 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 410 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009308.9956 | 2121195.6387 | 37.804923745513 | -122.41203376959 | (37.804923745513, -122.41203376959) | 3 | 1 | 10 | 308 | 23 | |||
158476 | 249945 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 325 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 24 | Width 0ft | 6011292.48387 | 2120026.50548 | 37.8018246784261 | -122.405087280374 | (37.8018246784261, -122.405087280374) | 3 | 1 | 10 | 308 | 23 | |||
159114 | 98563 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301X Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
159127 | 41772 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1045 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | 7 | Permit Number 42187 | 6009458.38804 | 2116963.23117 | 37.793310979166 | -122.411217616996 | (37.793310979166, -122.411217616996) | 3 | 1 | 10 | 28857 | 21 | |
159332 | 115708 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 778 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2016 12:00:00 AM | 3 | 3x3 | 6009816.75461 | 2118837.78852 | 37.798478147295 | -122.410110041641 | (37.798478147295, -122.410110041641) | 3 | 1 | 10 | 308 | 4 | ||
160910 | 121689 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 800 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6008443.30153 | 2120385.20754 | 37.8026498963393 | -122.414972211914 | (37.8026498963393, -122.414972211914) | 5 | 1 | 10 | 308 | 32 | ||||
161356 | 62715 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1941 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | 6 | Permit Number 23057 | 6007704.91578 | 2119106.60942 | 37.7990976677838 | -122.417436738332 | (37.7990976677838, -122.417436738332) | 5 | 1 | 10 | 28858 | 32 | |
161794 | 57394 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1355 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/1989 12:00:00 AM | 4 | 3x3 | Permit Number 28227 | 6007983.42237 | 2117121.90556 | 37.7936638299648 | -122.416332358263 | (37.7936638299648, -122.416332358263) | 5 | 1 | 10 | 28858 | 32 | |
161855 | 249834 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 333 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011234.1519 | 2120371.94769 | 37.8027699171526 | -122.405313477854 | (37.8027699171526, -122.405313477854) | 3 | 1 | 10 | 308 | 23 | |||
163020 | 249875 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 230 Greenwich St | 11 | Back Yard : Yard | Tree | Private 2 | 19 | Width 0ft | 6011656.00691 | 2120465.55697 | 37.8030505218387 | -122.403860227375 | (37.8030505218387, -122.403860227375) | 3 | 1 | 10 | 28860 | 6 | |||
165608 | 143436 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 725 STOCKTON ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 0ft | 6010474.6222 | 2116698.0575 | 37.792639816621 | -122.407682654324 | (37.792639816621, -122.407682654324) | 3 | 1 | 10 | 28857 | 4 | |||
166313 | 62714 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1932 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | 3 | Permit Number 23056 | 6007759.09173 | 2119080.02811 | 37.7990277302022 | -122.417247386069 | (37.7990277302022, -122.417247386069) | 5 | 1 | 10 | 308 | 32 | |
166724 | 249931 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 345 Filbert St | 5 | : | Tree | Private 2 | 5 | Width 0ft | 6011214.74621 | 2120016.06231 | 37.8017916580081 | -122.405355554416 | (37.8017916580081, -122.405355554416) | 3 | 1 | 10 | 308 | 23 | |||
166848 | 135802 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1225 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008954.74559 | 2117144.45574 | 37.7937803191599 | -122.412973080159 | (37.7937803191599, -122.412973080159) | 5 | 1 | 10 | 28857 | 21 | |||
167577 | 42839 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1167 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | 5 | Permit Number 42770 | 6007346.6476 | 2119488.5768 | 37.8001262898408 | -122.418703572815 | (37.8001262898408, -122.418703572815) | 5 | 1 | 1 | 28858 | 32 | |
168118 | 135845 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2430 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6007529.20491 | 2120735.02221 | 37.8035589913248 | -122.418160269894 | (37.8035589913248, -122.418160269894) | 5 | 1 | 1 | 308 | 32 | |||
170034 | 135799 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 17 Phoenix Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6008603.37941 | 2117901.29377 | 37.7958386802699 | -122.414242415654 | (37.7958386802699, -122.414242415654) | 5 | 1 | 10 | 308 | 21 | |||
173560 | 104477 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 350X Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2013 12:00:00 AM | 3 | 3x3 | Permit Number 767241 | 6012286.11088 | 2118476.93783 | 37.7976254353175 | -122.401539877573 | (37.7976254353175, -122.401539877573) | 3 | 1 | 10 | 28860 | 6 | |
176240 | 68912 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Florence St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 8 | Permit Number 32890 | 6008496.87073 | 2118345.67653 | 37.7970528621676 | -122.41464241973 | (37.7970528621676, -122.41464241973) | 5 | 1 | 10 | 308 | 21 | |
177484 | 98565 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301X Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
177502 | 249974 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 28 Napier Ln | 1 | Front Yard : Yard | Tree | Private 2 | 18 | Width 0ft | 6011652.50252 | 2120258.92401 | 37.8024829623787 | -122.403857805517 | (37.8024829623787, -122.403857805517) | 3 | 1 | 10 | 308 | 23 | |||
178781 | 52370 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 975 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 5 | Permit Number 48502 | 6007928.79422 | 2115121.18963 | 37.7881672833478 | -122.416379598764 | (37.7881672833478, -122.416379598764) | 13 | 1 | 10 | 28858 | 21 | |
180446 | 41773 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1045 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | 5 | Permit Number 42187 | 6009460.67023 | 2116947.19217 | 37.7932670679698 | -122.411208586919 | (37.7932670679698, -122.411208586919) | 3 | 1 | 10 | 28857 | 21 | |
183913 | 135844 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1155 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6007360.5897 | 2119841.38777 | 37.8010958048794 | -122.418680361323 | (37.8010958048794, -122.418680361323) | 5 | 1 | 1 | 28858 | 32 | |||
185098 | 249891 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 230 Greenwich St | 27 | Back Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011455.07282 | 2120426.06234 | 37.8029308517393 | -122.404552786308 | (37.8029308517393, -122.404552786308) | 3 | 1 | 10 | 308 | 6 | |||
185232 | 135826 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | 6008677.52116 | 2119019.14222 | 37.7989121799184 | -122.414064992014 | (37.7989121799184, -122.414064992014) | 5 | 1 | 10 | 308 | 32 | ||||
187485 | 34467 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1200 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38202 | 6008365.37271822 | 2117943.65111896 | 37.7959416111191 | -122.415068965438 | (37.7959416111191, -122.415068965438) | 5 | 1 | 10 | 28858 | 21 | ||
187680 | 135817 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1083 Lombard St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6007203.65947 | 2120166.57987 | 37.8019798636266 | -122.419246489941 | (37.8019798636266, -122.419246489941) | 5 | 1 | 1 | 28858 | 32 | |||
188195 | 135841 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1177 Greenwich St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6007250.45092 | 2119825.88461 | 37.801047035553 | -122.41906038964 | (37.801047035553, -122.41906038964) | 5 | 1 | 1 | 28858 | 32 | ||||
188493 | 50380 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1620 Montgomery St | 4 | 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 | |||
189324 | 249882 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 230 Greenwich St | 18 | Back Yard : Yard | Tree | Private 2 | 27 | Width 0ft | 6011509.07243 | 2120419.37331 | 37.8029155030083 | -122.404365447615 | (37.8029155030083, -122.404365447615) | 3 | 1 | 10 | 308 | 23 | |||
191008 | 142543 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | Width 0ft | 6009503.7886 | 2121178.1337 | 37.8048866083098 | -122.411358426924 | (37.8048866083098, -122.411358426924) | 3 | 1 | 10 | 308 | 23 | |||
191546 | 64562 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1419 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | Permit Number 25454 | 6009728.96259143 | 2118520.44874424 | 37.797601889078 | -122.410391411409 | (37.797601889078, -122.410391411409) | 3 | 1 | 10 | 308 | 4 | ||
191936 | 100987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
192586 | 135830 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Green St | 8 | Front Yard : Yard | Tree | Private 2 | 2 | 6008645.65329 | 2119014.61059 | 37.7988979472514 | -122.414174944941 | (37.7988979472514, -122.414174944941) | 5 | 1 | 10 | 308 | 32 | ||||
12301 | 81771 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 118 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50018 | 6009093.57763 | 2112998.11082 | 37.7824032504549 | -122.41219952199 | (37.7824032504549, -122.41219952199) | 14 | 10 | 9 | 28852 | 36 | |
33634 | 65438 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 155 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1989 12:00:00 AM | Permit Number 28312 | 6009256.14047234 | 2113222.54142077 | 37.7830286035896 | -122.411652986137 | (37.7830286035896, -122.411652986137) | 14 | 10 | 9 | 28852 | 36 | ||
109120 | 81929 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 118 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 6 | 3x3 | Permit Number 50018 | 6009095.92555 | 2112986.00249 | 37.7823701356165 | -122.412190543152 | (37.7823701356165, -122.412190543152) | 14 | 10 | 9 | 28852 | 36 | |
120211 | 65439 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 165 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | 6 | Permit Number 28313 | 6009223.95051 | 2113218.56201 | 37.7830158713234 | -122.411764069357 | (37.7830158713234, -122.411764069357) | 14 | 10 | 9 | 28852 | 36 | |
152 | 235666 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 4 | : | Tree | Private 2 | 3 | Width 2ft | 6006462.25734 | 2109005.38337 | 37.7712921868165 | -122.421019169707 | (37.7712921868165, -122.421019169707) | 8 | 2 | 9 | 28853 | 19 | |||
211 | 196303 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 249 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011469.59111 | 2111688.37468 | 37.7789400547713 | -122.403887319468 | (37.7789400547713, -122.403887319468) | 14 | 2 | 9 | 28856 | 34 | |||
1775 | 196240 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 477 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010588.30864 | 2112340.27099 | 37.7806807348789 | -122.406982002622 | (37.7806807348789, -122.406982002622) | 14 | 2 | 9 | 28853 | 34 | |||
2505 | 196318 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 323 11th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008553.79261 | 2109149.29537 | 37.7718050135221 | -122.413794615322 | (37.7718050135221, -122.413794615322) | 8 | 2 | 9 | 28853 | 34 | |||
2662 | 51421 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 655 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2004 12:00:00 AM | 3 | Permit Number 47745 | 6013248.9695 | 2110513.26704 | 37.7758127253049 | -122.397649253932 | (37.7758127253049, -122.397649253932) | 6 | 2 | 9 | 28856 | 34 | |
3685 | 42239 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 526 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 5 | Permit Number 42488 | 6010182.46318 | 2111990.4424 | 37.7796974691974 | -122.408361341411 | (37.7796974691974, -122.408361341411) | 14 | 2 | 9 | 28853 | 34 | |
5125 | 38779 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 534 04th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | Permit Number 40639 | 6013303.96708897 | 2111684.86517271 | 37.7790327294989 | -122.397541189965 | (37.7790327294989, -122.397541189965) | 6 | 2 | 9 | 28856 | 34 | ||
5585 | 100886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013501.81999 | 2111894.49362 | 37.7796193360911 | -122.396871432992 | (37.7796193360911, -122.396871432992) | 6 | 2 | 9 | 28856 | 34 | |||
5877 | 51423 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 655 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2004 12:00:00 AM | 2 | 3x3 | Permit Number 52282 | 6013263.01553 | 2110499.58328 | 37.7757759349387 | -122.397599704863 | (37.7757759349387, -122.397599704863) | 6 | 2 | 9 | 28856 | 34 | |
6844 | 235670 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 69 Elgin Park | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6005833.06667 | 2108709.07327 | 37.7704431026896 | -122.423174504696 | (37.7704431026896, -122.423174504696) | 8 | 2 | 5 | 28853 | 19 | |||
6903 | 38781 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 534 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | 7 | Permit Number 40639 | 6013329.04635 | 2111645.89395 | 37.7789271198304 | -122.397451696238 | (37.7789271198304, -122.397451696238) | 6 | 2 | 9 | 28856 | 34 | |
8287 | 196310 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 928 Clara St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6011726.41935 | 2111671.91567 | 37.7789092071182 | -122.402997684908 | (37.7789092071182, -122.402997684908) | 14 | 2 | 9 | 28856 | 34 | |||
9114 | 72295 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 142 Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6013238.89024 | 2111406.12615 | 37.7782637520155 | -122.397746762019 | (37.7782637520155, -122.397746762019) | 6 | 2 | 9 | 28856 | 34 | |||
10532 | 79204 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 175 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010493.03003 | 2110416.65916 | 37.7753936142481 | -122.407175982785 | (37.7753936142481, -122.407175982785) | 8 | 2 | 9 | 28853 | 34 | |||
10828 | 196319 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 83 Lafayette St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6007736.57644 | 2109492.64153 | 37.7727018336483 | -122.416645755806 | (37.7727018336483, -122.416645755806) | 8 | 2 | 9 | 28853 | 19 | |||
11344 | 196242 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 463 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6010684.26644 | 2112432.48387 | 37.7809392989608 | -122.406656537094 | (37.7809392989608, -122.406656537094) | 14 | 2 | 9 | 28853 | 34 | |||
11418 | 84345 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 925 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010983.26021 | 2109758.62597 | 37.773614230057 | -122.405433799926 | (37.773614230057, -122.405433799926) | 14 | 2 | 9 | 28853 | 34 | |||
13125 | 196236 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 457 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010494.60827 | 2112515.413 | 37.7811563899075 | -122.407318509161 | (37.7811563899075, -122.407318509161) | 14 | 2 | 9 | 28853 | 34 |
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) );