trees
430 rows where qSpecies_id = 99 sorted by Fire Prevention 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4126 | 115471 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 10X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | ||||||||||||||
16067 | 19787 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100 STAIRWAY19 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 50ST | |||||||||||||
16487 | 19779 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100 STAIRWAY19 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
3741 | 228 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2974 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/1992 12:00:00 AM | 70 | 3X4 | 5990613.87863 | 2095369.93557 | 37.7329467072262 | -122.474843412516 | (37.7329467072262, -122.474843412516) | 1 | 8 | 4 | 64 | 40 | ||
5950 | 185691 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984865.9917 | 2100533.4848 | 37.746789659782 | -122.49509567655 | (37.746789659782, -122.49509567655) | 1 | 8 | 3 | 29491 | 35 | |||
11607 | 11613 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
14370 | 185713 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984850.6272 | 2100403.3767 | 37.7464315188861 | -122.495139211963 | (37.7464315188861, -122.495139211963) | 1 | 8 | 3 | 29491 | 35 | |||
21352 | 106884 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 180X SAN MARCOS AVE | 6 | Median : Cutout | Tree | Private 2 | DPW | 4 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | |||
22196 | 185716 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984901.6243 | 2100400.4346 | 37.7464264261744 | -122.494962655496 | (37.7464264261744, -122.494962655496) | 1 | 8 | 3 | 29491 | 35 | |||
26511 | 11792 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1200X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | |||
33148 | 106883 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 180X SAN MARCOS AVE | 4 | Median : Cutout | Tree | Private 2 | DPW | 4 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | |||
33957 | 185719 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984913.7198 | 2100361.206 | 37.7463194231796 | -122.494917939299 | (37.7463194231796, -122.494917939299) | 1 | 8 | 3 | 29491 | 35 | |||
36993 | 11614 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
55859 | 11620 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
57689 | 117255 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
58154 | 121665 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 100 Montalvo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5993653 | 2099666 | 37.7449182738718 | -122.464648312953 | (37.7449182738718, -122.464648312953) | 1 | 8 | 4 | 29491 | 40 | ||||
60170 | 181893 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2370 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 5987361.9916 | 2099162.5217 | 37.7431711693476 | -122.486364226347 | (37.7431711693476, -122.486364226347) | 1 | 8 | 3 | 29491 | 35 | |||
60921 | 239 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3010X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 90 | 2 | 5990623.3177 | 2095139.449 | 37.7323143965058 | -122.474793962374 | (37.7323143965058, -122.474793962374) | 1 | 8 | 4 | 64 | 40 | |||
81017 | 117256 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
82136 | 215651 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2105 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5993642.48221 | 2101265.67926 | 37.7493099806718 | -122.464800828005 | (37.7493099806718, -122.464800828005) | 1 | 8 | 4 | 29491 | 40 | |||
83226 | 182457 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1500 31st Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 0ft | 5986548.9803 | 2104732.6813 | 37.7584178970063 | -122.489584885211 | (37.7584178970063, -122.489584885211) | 1 | 8 | 3 | 56 | 35 | |||
85876 | 11616 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2x2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
88692 | 106880 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 180X SAN MARCOS AVE | 3 | Median : Cutout | Tree | Private 2 | DPW | 5 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | |||
91388 | 105784 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 04/18/2014 12:00:00 AM | Permit Number 772914 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||
92766 | 114034 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 198x FONT BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3x3 | 5990818 | 2089012 | 37.7155012267577 | -122.473674083302 | (37.7155012267577, -122.473674083302) | 1 | 8 | 4 | 64 | 14 | |||
101449 | 185963 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2001 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984881.7314 | 2101336.1941 | 37.7489946017929 | -122.495100432866 | (37.7489946017929, -122.495100432866) | 1 | 8 | 3 | 29491 | 35 | |||
106085 | 185690 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984904.8934 | 2100540.6767 | 37.7468116841536 | -122.494961690438 | (37.7468116841536, -122.494961690438) | 1 | 8 | 3 | 29491 | 35 | |||
120650 | 11619 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
139251 | 182465 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2400 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5986689.3022 | 2104396.9525 | 37.7575042689843 | -122.489074914666 | (37.7575042689843, -122.489074914666) | 1 | 8 | 3 | 56 | 35 | |||
151976 | 11615 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2x2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
158218 | 227 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2968 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 2X3 | 5990630.67566 | 2095430.16477 | 37.7331130547028 | -122.474789735965 | (37.7331130547028, -122.474789735965) | 1 | 8 | 4 | 64 | 40 | |||
165571 | 182456 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1500 31st Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 0ft | 5986548.9803 | 2104699.0505 | 37.7583255560621 | -122.489582412162 | (37.7583255560621, -122.489582412162) | 1 | 8 | 3 | 56 | 35 | |||
170304 | 182454 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1500 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 0ft | 5986553.619 | 2104615.5531 | 37.7580965659316 | -122.489560229786 | (37.7580965659316, -122.489560229786) | 1 | 8 | 3 | 56 | 35 | |||
172849 | 185728 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 0ft | 5984906.201 | 2100307.5936 | 37.7461717779802 | -122.494939985658 | (37.7461717779802, -122.494939985658) | 1 | 8 | 3 | 29491 | 35 | |||
5897 | 199851 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014366.3226 | 2092462.8184 | 37.7263121847089 | -122.392521119846 | (37.7263121847089, -122.392521119846) | 10 | 3 | 8 | 58 | 1 | |||
30014 | 199844 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 0ft | 6014142.1837 | 2092625.4409 | 37.7267462633936 | -122.393307337928 | (37.7267462633936, -122.393307337928) | 10 | 3 | 8 | 58 | 1 | |||
38772 | 58907 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 354 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1980 12:00:00 AM | 29 | Permit Number 18182 | 6012260.63611 | 2086890.34143 | 37.7108941228427 | -122.399409385456 | (37.7108941228427, -122.399409385456) | 10 | 3 | 8 | 309 | 1 | ||
48438 | 26629 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1099X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/02/2017 12:00:00 AM | 6 | 3x3 | 6011248.5682 | 2094191.84655 | 37.7308861005042 | -122.403420689108 | (37.7308861005042, -122.403420689108) | 10 | 3 | 8 | 58 | 1 | ||
56459 | 1867 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2555 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010748.9210869 | 2086419.1045134 | 37.7095158271004 | -122.404601102054 | (37.7095158271004, -122.404601102054) | 10 | 3 | 8 | 309 | 1 | |||
122123 | 199849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 6014322.4694 | 2092498.1446 | 37.7264067479006 | -122.392675189528 | (37.7264067479006, -122.392675189528) | 10 | 3 | 8 | 58 | 1 | |||
150449 | 116138 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 6014404.0852 | 2092434.1919 | 37.7262356791342 | -122.392388573996 | (37.7262356791342, -122.392388573996) | 10 | 3 | 8 | 58 | 1 | ||||
153823 | 199846 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014210.3999 | 2092579.1513 | 37.7266229511494 | -122.393068277245 | (37.7266229511494, -122.393068277245) | 10 | 3 | 8 | 58 | 1 | |||
154944 | 199847 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014254.2532 | 2092550.5249 | 37.7265467847844 | -122.392914674805 | (37.7265467847844, -122.392914674805) | 10 | 3 | 8 | 58 | 1 | |||
155029 | 180579 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2500 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6010790.74354 | 2086511.28723 | 37.7097712796836 | -122.404463040238 | (37.7097712796836, -122.404463040238) | 10 | 3 | 8 | 309 | 1 | |||
1712 | 105883 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 250 Locust St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5997608.20664 | 2115530.35123 | 37.7887049601136 | -122.452116422945 | (37.7887049601136, -122.452116422945) | 11 | 6 | 1 | 54 | 31 | ||||
19727 | 1431 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5 | 5995471.94905 | 2115498.24125 | 37.7884941933869 | -122.459505186902 | (37.7884941933869, -122.459505186902) | 11 | 6 | 1 | 54 | 11 | |||
20560 | 82168 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 60 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5995525.66671462 | 2115618.09435692 | 37.7888263661678 | -122.45932801632 | (37.7888263661678, -122.45932801632) | 11 | 6 | 1 | 54 | 31 | |||||
26096 | 123479 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 5995657.67406 | 2112077.16899 | 37.7791115222078 | -122.458614856747 | (37.7791115222078, -122.458614856747) | 11 | 6 | 2 | 54 | 16 | ||||
27899 | 1421 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x12 | 5995527.21204 | 2115624.1968 | 37.7888432106719 | -122.459323111848 | (37.7888432106719, -122.459323111848) | 11 | 6 | 1 | 54 | 31 | |||
30217 | 1529 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 451 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X4 | 5995566.01052 | 2113204.19125 | 37.7822007565611 | -122.45901358165 | (37.7822007565611, -122.45901358165) | 11 | 6 | 2 | 54 | 11 | |||
31067 | 123486 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5995665.69022 | 2111872.76649 | 37.7785507478592 | -122.458572325088 | (37.7785507478592, -122.458572325088) | 11 | 6 | 2 | 54 | 16 | ||||
34810 | 137072 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3598 Clay St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 4ft | 5997679.8137 | 2115460.24424 | 37.7885165665196 | -122.451863614513 | (37.7885165665196, -122.451863614513) | 11 | 6 | 1 | 54 | 31 | |||
35862 | 1540 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
41289 | 124637 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 124 Arguello Blvd | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 31 | Width 5ft | 5995537.16304 | 2115311.02189 | 37.7879838891542 | -122.459265995172 | (37.7879838891542, -122.459265995172) | 11 | 6 | 1 | 54 | 31 | ||||
43102 | 137067 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997931.48984 | 2116393.73013 | 37.791094081978 | -122.45106020067 | (37.791094081978, -122.45106020067) | 11 | 6 | 1 | 54 | 31 | |||
44810 | 123491 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5995674.45752 | 2111730.9534 | 37.7781618705542 | -122.458531727532 | (37.7781618705542, -122.458531727532) | 11 | 6 | 2 | 54 | 16 | ||||
46026 | 1477 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 245 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995501.26357 | 2114653.66128 | 37.7861768902412 | -122.459342576538 | (37.7861768902412, -122.459342576538) | 11 | 6 | 1 | 54 | 11 | |||
47411 | 1433 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5X5 | 5995535.85964 | 2115388.72149 | 37.7881971563264 | -122.459276133553 | (37.7881971563264, -122.459276133553) | 11 | 6 | 1 | 54 | 31 | |||
48000 | 105881 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 250 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5997617.52659 | 2115483.20836 | 37.7885760521994 | -122.452080774722 | (37.7885760521994, -122.452080774722) | 11 | 6 | 1 | 54 | 31 | ||||
48960 | 1645 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 881 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 6X6 | 5995652.78213 | 2110475.54294 | 37.7747135991516 | -122.458515810277 | (37.7747135991516, -122.458515810277) | 11 | 6 | 2 | 54 | 11 | |||
50866 | 1622 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 781 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X4 | 5995639.65253 | 2110927.44628 | 37.7759536520848 | -122.458593948432 | (37.7759536520848, -122.458593948432) | 11 | 6 | 2 | 54 | 11 | |||
53519 | 123480 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | 5995658.30802 | 2112054.06112 | 37.7790481105637 | -122.458610990374 | (37.7790481105637, -122.458610990374) | 11 | 6 | 2 | 54 | 16 | ||||
55643 | 123482 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | 5995660.39644 | 2111993.63742 | 37.7788823231397 | -122.458599390427 | (37.7788823231397, -122.458599390427) | 11 | 6 | 2 | 54 | 16 | ||||
59579 | 123469 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 772 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 5995383.36925 | 2110442.32995 | 37.7746069181393 | -122.459445351917 | (37.7746069181393, -122.459445351917) | 11 | 6 | 2 | 54 | 11 | |||
60777 | 1617 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 764 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 135 | 3X3 | 5995701.56639 | 2110898.08045 | 37.7758765794073 | -122.458377647589 | (37.7758765794073, -122.458377647589) | 11 | 6 | 2 | 54 | 16 | |||
61047 | 1534 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
61561 | 1440 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 126 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5X5 | 5995572.08179 | 2115303.34583 | 37.7879648202564 | -122.459144627311 | (37.7879648202564, -122.459144627311) | 11 | 6 | 1 | 54 | 31 | |||
64618 | 1441 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 138 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 5X5 | 5995537.91826 | 2115271.42403 | 37.7878752075455 | -122.459260513654 | (37.7878752075455, -122.459260513654) | 11 | 6 | 1 | 54 | 31 | |||
66794 | 1428 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5 | 5995465.63795 | 2115574.86439 | 37.78870421691 | -122.459532573841 | (37.78870421691, -122.459532573841) | 11 | 6 | 1 | 54 | 11 | |||
71394 | 123487 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 5995668.73883 | 2111844.87781 | 37.7784743481439 | -122.458559759476 | (37.7784743481439, -122.458559759476) | 11 | 6 | 2 | 54 | 16 | ||||
75188 | 1437 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 101X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | 5 | 5995475.83232 | 2115319.03247 | 37.7880023578197 | -122.459478767425 | (37.7880023578197, -122.459478767425) | 11 | 6 | 1 | 54 | 11 | |||
80156 | 39243 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3934 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1998 12:00:00 AM | Permit Number 40874 | 5995936.27284071 | 2115227.33652665 | 37.7877770492494 | -122.457879097389 | (37.7877770492494, -122.457879097389) | 11 | 6 | 1 | 54 | 31 | |||
84318 | 124687 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 460 Arguello Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5995608.47806 | 2113376.19737 | 37.7826754805595 | -122.45887912132 | (37.7826754805595, -122.45887912132) | 11 | 6 | 1 | 54 | 31 | |||
89777 | 1533 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
89935 | 123488 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5995672.61976 | 2111816.69318 | 37.7783971836602 | -122.458544293173 | (37.7783971836602, -122.458544293173) | 11 | 6 | 2 | 54 | 16 | ||||
90221 | 1429 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5 | 5995465.54596 | 2115556.47361 | 37.7886537155162 | -122.45953155962 | (37.7886537155162, -122.45953155962) | 11 | 6 | 1 | 54 | 11 | |||
92226 | 137068 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997936.78651 | 2116362.08959 | 37.7910075087313 | -122.45103959183 | (37.7910075087313, -122.45103959183) | 11 | 6 | 1 | 54 | 31 | |||
93403 | 1620 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 777 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995637.36215 | 2110958.16718 | 37.7760378719372 | -122.458604095826 | (37.7760378719372, -122.458604095826) | 11 | 6 | 2 | 54 | 11 | |||
94324 | 1471 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 223 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 100 | 3X3 | 5995498.41446 | 2114753.58122 | 37.7864510796736 | -122.459359672388 | (37.7864510796736, -122.459359672388) | 11 | 6 | 1 | 54 | 11 | |||
95397 | 123958 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 295 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993672.37881 | 2113557.39213 | 37.7830615134244 | -122.465590312648 | (37.7830615134244, -122.465590312648) | 11 | 6 | 2 | 54 | 11 | |||
98869 | 1470 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 215 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5995496.39039 | 2114788.79173 | 37.7865476418723 | -122.45936922598 | (37.7865476418723, -122.45936922598) | 11 | 6 | 1 | 54 | 11 | |||
100808 | 1541 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
107113 | 137069 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997939.35301 | 2116349.86097 | 37.7909740791344 | -122.451029829681 | (37.7909740791344, -122.451029829681) | 11 | 6 | 1 | 54 | 31 | |||
107856 | 124694 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 460 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5995618.45318 | 2113098.44712 | 37.78191342592 | -122.458824496585 | (37.78191342592, -122.458824496585) | 11 | 6 | 1 | 54 | 31 | |||
111676 | 137071 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997945.51163 | 2116314.45646 | 37.7908772203684 | -122.451005967078 | (37.7908772203684, -122.451005967078) | 11 | 6 | 1 | 54 | 31 | |||
113204 | 137074 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3598 Clay St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 4ft | 5997641.85824 | 2115456.61364 | 37.7885044238892 | -122.45199467184 | (37.7885044238892, -122.45199467184) | 11 | 6 | 1 | 54 | 31 | |||
114049 | 1642 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 860 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 5995719.79795 | 2110383.37965 | 37.7744643941763 | -122.458277318373 | (37.7744643941763, -122.458277318373) | 11 | 6 | 2 | 54 | 16 | |||
115270 | 123484 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | 5995663.25844 | 2111930.13675 | 37.7787081316253 | -122.458584891633 | (37.7787081316253, -122.458584891633) | 11 | 6 | 2 | 54 | 16 | ||||
126133 | 124686 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 460 Arguello Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5995607.11329 | 2113402.43136 | 37.7827474336358 | -122.458885742796 | (37.7827474336358, -122.458885742796) | 11 | 6 | 1 | 54 | 31 | |||
129740 | 1468 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 200 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5995558.6934 | 2114767.33782 | 37.7864923171366 | -122.459152120252 | (37.7864923171366, -122.459152120252) | 11 | 6 | 1 | 54 | 31 | |||
132043 | 1514 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 390 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 55 | 4X6 | 5995592.131 | 2113860.45299 | 37.7840041772291 | -122.458970748307 | (37.7840041772291, -122.458970748307) | 11 | 6 | 1 | 54 | 31 | |||
132177 | 1423 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x5 | 5995562.14611 | 2115577.70158 | 37.7887175558035 | -122.459198877421 | (37.7887175558035, -122.459198877421) | 11 | 6 | 1 | 54 | 31 | |||
134973 | 104704 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3590X Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2014 12:00:00 AM | 3x3 | Permit Number 771748 | 5997841.875 | 2115466.23587 | 37.7885422986565 | -122.451303342479 | (37.7885422986565, -122.451303342479) | 11 | 6 | 1 | 54 | 31 | ||
136998 | 6416 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 400X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 6x5 | 5995602.32868 | 2113744.52068 | 37.7836864443545 | -122.458927071616 | (37.7836864443545, -122.458927071616) | 11 | 6 | 1 | 54 | 31 | |||
139838 | 1438 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 101X Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 5 | 5995477.38208 | 2115292.89339 | 37.7879306760788 | -122.459471511755 | (37.7879306760788, -122.459471511755) | 11 | 6 | 1 | 54 | 11 | |||
142118 | 124672 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 390 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 34 | Width 4ft | 5995591.07711 | 2113866.14003 | 37.7840197317356 | -122.458974806266 | (37.7840197317356, -122.458974806266) | 11 | 6 | 1 | 54 | 31 | |||
143170 | 1543 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5995618.1476548 | 2113146.4510222 | 37.7820452142622 | -122.458829030078 | (37.7820452142622, -122.458829030078) | 11 | 6 | 1 | 54 | 31 | |||
146234 | 1525 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 439 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5X7 | 5995548.96018 | 2113291.48375 | 37.7824394582911 | -122.459078890487 | (37.7824394582911, -122.459078890487) | 11 | 6 | 2 | 54 | 11 | |||
149942 | 123483 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | 5995662.44998 | 2111958.25695 | 37.7787852957742 | -122.458589724568 | (37.7787852957742, -122.458589724568) | 11 | 6 | 2 | 54 | 16 | ||||
152803 | 1531 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 499 Arguello Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5995560.27463 | 2113085.81754 | 37.7818754042369 | -122.459024851411 | (37.7818754042369, -122.459024851411) | 11 | 6 | 2 | 54 | 11 |
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) );