trees
3,247 rows where qSpecies_id = 22 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
796 | 36869 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
8250 | 19840 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY25 | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
11197 | 19797 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY21 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
12826 | 19801 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY21 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
14048 | 19740 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY15 | -50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 1OST | |||||||||||||
14814 | 50011 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | Permit Number 46742 | |||||||||||||
15898 | 36871 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
16336 | 36872 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
16572 | 19741 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY15 | -14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 1OST | |||||||||||||
17433 | 36873 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
89341 | 249650 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2401 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | Width 10ft | 5999216.24829 | 2117285.03492 | 37.7936148393952 | -122.446679155136 | (37.7936148393952, -122.446679155136) | 11 | 1 | 57 | 30 | ||||
288 | 125298 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010056.95509 | 2118170.07703 | 37.7966582351325 | -122.409231726859 | (37.7966582351325, -122.409231726859) | 3 | 1 | 10 | 308 | 4 | |||
881 | 254388 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
1506 | 70618 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1557 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6007346.38924 | 2116443.24691 | 37.7917645589423 | -122.418488407316 | (37.7917645589423, -122.418488407316) | 5 | 1 | 10 | 28858 | 21 | |||
1952 | 129457 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010137.05679 | 2118184.23209 | 37.7967015887668 | -122.408955554965 | (37.7967015887668, -122.408955554965) | 3 | 1 | 10 | 308 | 4 | |||
5352 | 143065 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Child St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010630.6807 | 2120383.8561 | 37.8027688567606 | -122.4074026458 | (37.8027688567606, -122.4074026458) | 3 | 1 | 10 | 308 | 23 | |||
6175 | 143071 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 558 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010223.267 | 2120278.2921 | 37.8024561925927 | -122.408805059144 | (37.8024561925927, -122.408805059144) | 3 | 1 | 10 | 308 | 23 | |||
6545 | 254389 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
6769 | 125297 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010069.63851 | 2118171.76968 | 37.7966635933042 | -122.409187958682 | (37.7966635933042, -122.409187958682) | 3 | 1 | 10 | 308 | 4 | |||
7064 | 129030 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012231.96171 | 2117118.21401 | 37.793891683102 | -122.401631701054 | (37.793891683102, -122.401631701054) | 4 | 1 | 10 | 28860 | 6 | |||
10304 | 71422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 658 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009722.2927 | 2120212.6608 | 37.8022479122752 | -122.410534048105 | (37.8022479122752, -122.410534048105) | 3 | 1 | 10 | 308 | 23 | |||
11856 | 107887 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
12180 | 91455 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
13295 | 72207 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 528 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010331.0847 | 2120296.9733 | 37.8025135249949 | -122.40843327331 | (37.8025135249949, -122.40843327331) | 3 | 1 | 10 | 308 | 23 | |||
13947 | 109612 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
16265 | 83806 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401 Jones St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 4x4 | 6008439.24535 | 2117330.37578 | 37.794261859346 | -122.414769927392 | (37.794261859346, -122.414769927392) | 5 | 1 | 10 | 28858 | 21 | ||
16333 | 128995 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1414 Jones St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6008424.44271 | 2117443.95005 | 37.7945728745903 | -122.41482918821 | (37.7945728745903, -122.41482918821) | 5 | 1 | 10 | 28858 | 21 | |||
17457 | 73445 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 900 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6007755.78016 | 2114801.18136 | 37.7872788880559 | -122.416955517392 | (37.7872788880559, -122.416955517392) | 13 | 1 | 10 | 28858 | 21 | |||
18062 | 264811 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1420 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2020 12:00:00 AM | 3 | 3x3 | 6008504 | 2117376 | 37.7943907703496 | -122.414549098287 | (37.7943907703496, -122.414549098287) | 5 | 1 | 10 | 28857 | 21 | ||
20059 | 143064 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 568 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010191.242 | 2120275.0896 | 37.8024456055 | -122.408915655908 | (37.8024456055, -122.408915655908) | 3 | 1 | 10 | 308 | 23 | |||
21015 | 129025 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012112.87485 | 2117105.88276 | 37.7938511785367 | -122.402042888167 | (37.7938511785367, -122.402042888167) | 4 | 1 | 10 | 28860 | 6 | |||
22650 | 53051 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1024 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51546 | 6009165.99693 | 2118045.48743 | 37.7962661873755 | -122.412305843439 | (37.7962661873755, -122.412305843439) | 3 | 1 | 10 | 308 | 21 | |
24018 | 53050 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1024 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767676 | 6009180.15933 | 2118047.86674 | 37.7962735150778 | -122.412257006676 | (37.7962735150778, -122.412257006676) | 3 | 1 | 10 | 308 | 21 |
26295 | 128993 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1357 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008263.70438 | 2116899.85827 | 37.793069899702 | -122.415346829015 | (37.793069899702, -122.415346829015) | 5 | 1 | 10 | 28858 | 21 | |||
27240 | 68167 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1131 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1993 12:00:00 AM | 12 | Permit Number 31936 | 6011528.02794 | 2119216.24888 | 37.7996130755308 | -122.404215124131 | (37.7996130755308, -122.404215124131) | 3 | 1 | 10 | 308 | 23 | ||
28464 | 64369 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 522 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 5 | Permit Number 25208 | 6010359.9072 | 2120301.2434 | 37.8025268636696 | -122.408333834018 | (37.8025268636696, -122.408333834018) | 3 | 1 | 10 | 308 | 23 | |
29589 | 129017 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010033.78329 | 2117473.19929 | 37.7947434804789 | -122.409262704913 | (37.7947434804789, -122.409262704913) | 3 | 1 | 10 | 28857 | 4 | |||
29718 | 129019 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010068.23962 | 2117476.51245 | 37.7947545079644 | -122.409143714711 | (37.7947545079644, -122.409143714711) | 3 | 1 | 10 | 28857 | 4 | |||
29859 | 128994 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1414 Jones St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6008423.06087 | 2117463.28601 | 37.7946258887275 | -122.414835338698 | (37.7946258887275, -122.414835338698) | 5 | 1 | 10 | 28858 | 21 | |||
30897 | 64364 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 562 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | Permit Number 25203 | 6010163.25374355 | 2120275.04561468 | 37.8024439169341 | -122.409012506441 | (37.8024439169341, -122.409012506441) | 3 | 1 | 10 | 308 | 23 | ||
32284 | 143495 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 800 KEARNY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 1 | Width 0ft | Permit Number 52103 | 6011293.9321 | 2117775.1194 | 37.7956429995479 | -122.404923663455 | (37.7956429995479, -122.404923663455) | 3 | 1 | 10 | 28857 | 4 | |
33987 | 64366 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 540 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 8 | Permit Number 25205 | 6010278.2434 | 2120287.8996 | 37.802485651571 | -122.408615490868 | (37.802485651571, -122.408615490868) | 3 | 1 | 10 | 308 | 23 | |
34825 | 129006 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Fallon Pl | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008915.40705 | 2118578.41421 | 37.7977154080083 | -122.413210643283 | (37.7977154080083, -122.413210643283) | 3 | 1 | 10 | 308 | 21 | ||||
35002 | 98799 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | ||
35371 | 91453 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680 WASHINGTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
35542 | 129040 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013297.17121 | 2117703.63203 | 37.7955584847826 | -122.397987035675 | (37.7955584847826, -122.397987035675) | 3 | 1 | 10 | 28860 | 6 | |||
35704 | 91458 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 808 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011295 | 2117692 | 37.7954148333998 | -122.404914113244 | (37.7954148333998, -122.404914113244) | 3 | 1 | 10 | 28857 | 4 | ||
35819 | 23691 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 400X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/25/2014 02:27:00 PM | 3 | 3X3 | 6012568.7473634 | 2117857.4681317 | 37.7959402861802 | -122.400518335953 | (37.7959402861802, -122.400518335953) | 3 | 1 | 10 | 28860 | 4 | ||
37837 | 110158 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1061 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 775265 | 6008518.81141 | 2118257.36351 | 37.7968116091339 | -122.414560246865 | (37.7968116091339, -122.414560246865) | 5 | 1 | 10 | 308 | 21 | ||
38991 | 107888 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
39318 | 129048 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 349 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012262.33565 | 2118106.53288 | 37.796607065509 | -122.401596099595 | (37.796607065509, -122.401596099595) | 3 | 1 | 10 | 28860 | 4 | |||
40108 | 129029 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012209.59826 | 2117116.91261 | 37.7938868618381 | -122.401708989687 | (37.7938868618381, -122.401708989687) | 4 | 1 | 10 | 28860 | 6 | |||
40335 | 129007 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2550 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007463.35439 | 2121202.39829 | 37.8048385808931 | -122.418421308908 | (37.8048385808931, -122.418421308908) | 5 | 1 | 1 | 308 | 32 | |||
41174 | 129013 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 150 Francisco St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6010602.08919 | 2121361.05101 | 37.8054503923804 | -122.407570525278 | (37.8054503923804, -122.407570525278) | 3 | 1 | 10 | 308 | 23 | ||||
41338 | 109613 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
42849 | 129009 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1137 Montgomery St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 3ft | 6011525.13377 | 2119231.56027 | 37.7996549551749 | -122.404226217291 | (37.7996549551749, -122.404226217291) | 3 | 1 | 10 | 308 | 23 | |||
44175 | 129037 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013253.49225 | 2117761.73014 | 37.7957155756652 | -122.398142251463 | (37.7957155756652, -122.398142251463) | 3 | 1 | 10 | 28860 | 6 | |||
46385 | 48357 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 271 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 4 | Permit Number 46907 | 6009989.2786 | 2121248.5013 | 37.8051070376269 | -122.40968329882 | (37.8051070376269, -122.40968329882) | 3 | 1 | 10 | 308 | 23 | |
49416 | 64371 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 470 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 12 | Permit Number 25210 | 6010591.4795 | 2120329.1807 | 37.8026165373925 | -122.407534445483 | (37.8026165373925, -122.407534445483) | 3 | 1 | 10 | 308 | 23 | |
52384 | 129034 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013241.89259 | 2117832.60042 | 37.7959095225567 | -122.398187363256 | (37.7959095225567, -122.398187363256) | 3 | 1 | 10 | 28860 | 6 | |||
52715 | 64363 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 568 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/09/2007 12:00:00 AM | 8 | Permit No. 49276 | 6010205.6533 | 2120275.0896 | 37.8024464127339 | -122.40886578546 | (37.8024464127339, -122.40886578546) | 3 | 1 | 10 | 308 | 23 | |
54293 | 172446 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 964 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | Width 2ft | 6009459.97745 | 2118085.18417 | 37.7963916769881 | -122.411291411782 | (37.7963916769881, -122.411291411782) | 3 | 1 | 10 | 308 | 4 | ||
55409 | 19210 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 395X Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/1994 12:00:00 AM | 3 | 3X3 | 6012205.7972639 | 2118092.2355744 | 37.7965646535307 | -122.401790730678 | (37.7965646535307, -122.401790730678) | 3 | 1 | 10 | 28860 | 4 | ||
56993 | 129045 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013279.7836 | 2117837.77288 | 37.7959258353613 | -122.398056615315 | (37.7959258353613, -122.398056615315) | 3 | 1 | 10 | 28860 | 6 | |||
57233 | 129041 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013290.87946 | 2117742.04768 | 37.7956636146407 | -122.398011502625 | (37.7956636146407, -122.398011502625) | 3 | 1 | 10 | 28860 | 6 | |||
58103 | 129049 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 345 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012447.02159 | 2118133.2731 | 37.796690791499 | -122.400958920936 | (37.796690791499, -122.400958920936) | 3 | 1 | 10 | 28860 | 4 | |||
61463 | 128999 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1717 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6008297.95397 | 2118364.12478 | 37.7970923387857 | -122.415332028868 | (37.7970923387857, -122.415332028868) | 5 | 1 | 10 | 28858 | 21 | |||
65864 | 143494 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 800 KEARNY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 1 | Width 0ft | Permit Number 52103 | 6011299.0592 | 2117739.2293 | 37.7955447405749 | -122.40490339454 | (37.7955447405749, -122.40490339454) | 3 | 1 | 10 | 28857 | 4 | |
66587 | 112802 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 865 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009439.76342 | 2118739.20101 | 37.798186312791 | -122.411407584406 | (37.798186312791, -122.411407584406) | 3 | 1 | 10 | 308 | 4 | |||
67790 | 129020 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010113.76388 | 2117481.29123 | 37.7947701795629 | -122.408986531214 | (37.7947701795629, -122.408986531214) | 3 | 1 | 10 | 28857 | 4 | |||
69113 | 88410 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1135 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51385 | 6009840.54095 | 2117687.0727 | 37.7953198964454 | -122.409946457661 | (37.7953198964454, -122.409946457661) | 3 | 1 | 10 | 28857 | 4 | |
69431 | 109609 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | |||
70152 | 57739 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1430 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1992 12:00:00 AM | 1 | Permit Number 31420 | 6009340.15372 | 2118176.38357 | 37.7966353671694 | -122.411712476165 | (37.7966353671694, -122.411712476165) | 3 | 1 | 10 | 308 | 4 | ||
70480 | 129016 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1500 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6011815.54331 | 2120971.51121 | 37.8044486600418 | -122.403343759329 | (37.8044486600418, -122.403343759329) | 3 | 1 | 10 | 28860 | 6 | |||
70905 | 129039 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013261.47543 | 2117697.75471 | 37.795540358945 | -122.398110137583 | (37.795540358945, -122.398110137583) | 3 | 1 | 10 | 28860 | 6 | |||
71715 | 128988 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1215 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009812.45895 | 2117905.58189 | 37.7959182954451 | -122.41005906 | (37.7959182954451, -122.41005906) | 3 | 1 | 10 | 308 | 4 | |||
72073 | 4694 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 850X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x8 | 6008940.69941 | 2120350.97779 | 37.802583847399 | -122.4132485365 | (37.802583847399, -122.4132485365) | 3 | 1 | 10 | 308 | 23 | |||
72689 | 129022 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010179.58419 | 2117492.42024 | 37.7948044239469 | -122.408759568426 | (37.7948044239469, -122.408759568426) | 3 | 1 | 10 | 28857 | 4 | |||
73399 | 129032 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012277.41277 | 2117127.53422 | 37.7939198102919 | -122.401475090399 | (37.7939198102919, -122.401475090399) | 4 | 1 | 10 | 28860 | 6 | |||
73582 | 129023 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 400 Montgomery St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6011906.72239 | 2116826.46817 | 37.7930724645857 | -122.40273653976 | (37.7930724645857, -122.40273653976) | 4 | 1 | 10 | 28854 | 6 | |||
75258 | 64372 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 530 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | Permit Number 25211 | 6010298.20676285 | 2120293.66367922 | 37.802502596356 | -122.408546814252 | (37.802502596356, -122.408546814252) | 3 | 1 | 10 | 308 | 23 | ||
76166 | 128938 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 707 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007811.09301 | 2114834.49148 | 37.7873734607509 | -122.41676650689 | (37.7873734607509, -122.41676650689) | 13 | 1 | 10 | 28858 | 21 | |||
78186 | 98801 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010237.16405 | 2117207.30409 | 37.79402478906 | -122.408540211182 | (37.79402478906, -122.408540211182) | 3 | 1 | 10 | 28857 | 4 | |
79505 | 112131 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
81892 | 128992 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1373 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008190.05233 | 2116889.25384 | 37.7930366427715 | -122.415600918963 | (37.7930366427715, -122.415600918963) | 5 | 1 | 10 | 28858 | 21 | |||
82770 | 68012 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1137 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1993 12:00:00 AM | 8 | Permit Number 31742 | 6011522.79537 | 2119247.92417 | 37.7996997558097 | -122.404235461403 | (37.7996997558097, -122.404235461403) | 3 | 1 | 10 | 308 | 23 | ||
83058 | 172447 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | Width 2ft | 6009352.06363 | 2118102.09709 | 37.7964320628364 | -122.411666013574 | (37.7964320628364, -122.411666013574) | 3 | 1 | 10 | 308 | 4 | ||
86873 | 129026 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012134.03965 | 2117107.22482 | 37.7938560447645 | -122.401969749919 | (37.7938560447645, -122.401969749919) | 4 | 1 | 10 | 28860 | 6 | |||
88306 | 109615 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
88483 | 109611 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
89417 | 129053 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 400X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/25/2014 02:27:00 PM | 6 | Width 4ft | 6012415.44443 | 2117838.53104 | 37.7958797388015 | -122.401047465462 | (37.7958797388015, -122.401047465462) | 3 | 1 | 10 | 28860 | 4 | ||
91518 | 109618 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | ||||
93209 | 129051 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 480 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011751.23747 | 2118071.45452 | 37.7964822162381 | -122.403362154035 | (37.7964822162381, -122.403362154035) | 3 | 1 | 10 | 28860 | 4 | |||
93672 | 128989 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1211 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009815.83375 | 2117884.20117 | 37.7958597783613 | -122.410045872345 | (37.7958597783613, -122.410045872345) | 3 | 1 | 10 | 308 | 4 | |||
94722 | 109622 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | ||||
94894 | 129050 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 480 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011790.74157 | 2118076.54295 | 37.7964983941394 | -122.403225818635 | (37.7964983941394, -122.403225818635) | 3 | 1 | 10 | 28860 | 4 | |||
95513 | 98800 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010265.98354 | 2117209.83013 | 37.7940333389111 | -122.408440670611 | (37.7940333389111, -122.408440670611) | 3 | 1 | 10 | 28857 | 4 | |
96369 | 128991 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1045 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008570.82974 | 2118264.35585 | 37.7968337306409 | -122.414380745793 | (37.7968337306409, -122.414380745793) | 5 | 1 | 10 | 308 | 21 | |||
96387 | 129059 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 662 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011327.66618 | 2117687.2461 | 37.7954036062342 | -122.404800747351 | (37.7954036062342, -122.404800747351) | 3 | 1 | 10 | 28857 | 4 | |
96609 | 23690 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 400X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2016 12:00:00 AM | 6 | 3X3 | 6012568.7473634 | 2117857.4681317 | 37.7959402861802 | -122.400518335953 | (37.7959402861802, -122.400518335953) | 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) );