trees
430 rows where qSpecies_id = 99 sorted by XCoord
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 | |||||||||||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||||
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 | |||||
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 | |||
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 | |||
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 | |||
36233 | 398 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 2 | 5990471.16794 | 2090846.61881 | 37.7205185437854 | -122.475006721555 | (37.7205185437854, -122.475006721555) | 9 | 8 | 4 | 64 | 40 | |||
69680 | 397 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990474.69146 | 2090771.67661 | 37.720312975301 | -122.474989074306 | (37.720312975301, -122.474989074306) | 9 | 8 | 4 | 64 | 40 | |||
136153 | 400 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 2 | 5990476.72602 | 2090904.23897 | 37.7206770765591 | -122.474991713144 | (37.7206770765591, -122.474991713144) | 9 | 8 | 4 | 64 | 40 | |||
75663 | 401 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2 | 5990481.9086 | 2090947.80374 | 37.7207969949539 | -122.474976977183 | (37.7207969949539, -122.474976977183) | 9 | 8 | 4 | 64 | 40 | |||
66200 | 395 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 2 | 5990486.24663 | 2090696.51982 | 37.7201072830556 | -122.474943649084 | (37.7201072830556, -122.474943649084) | 9 | 8 | 4 | 64 | 40 | |||
139750 | 394 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990492.73788 | 2090676.25296 | 37.7200520114659 | -122.474919732673 | (37.7200520114659, -122.474919732673) | 9 | 8 | 4 | 64 | 40 | |||
140418 | 393 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 2 | 5990507.18031 | 2090652.75966 | 37.7199883416446 | -122.474868096697 | (37.7199883416446, -122.474868096697) | 9 | 8 | 4 | 64 | 40 | |||
21545 | 392 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 2 | 5990516.36157 | 2090620.36486 | 37.7198999256056 | -122.474833997279 | (37.7198999256056, -122.474833997279) | 9 | 8 | 4 | 64 | 40 | |||
71766 | 391 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 34 | 2 | 5990530.65648 | 2090591.3498 | 37.7198210858115 | -122.474782468587 | (37.7198210858115, -122.474782468587) | 9 | 8 | 4 | 64 | 40 | |||
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 | ||
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 | |||
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 | |||
96850 | 87591 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3840 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 5990782.62319 | 2090250.31161 | 37.7188992769151 | -122.473886649335 | (37.7188992769151, -122.473886649335) | 9 | 8 | 4 | 64 | 40 | ||||
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 | |||
384 | 415 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3862 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 2X6 | 5990878.96388 | 2090116.60552 | 37.7185377326944 | -122.473543893183 | (37.7185377326944, -122.473543893183) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
31061 | 215630 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 73 | : | Tree | Private 2 | 9 | Width 0ft | 5991138.04395 | 2090591.75646 | 37.7198573805858 | -122.47268299364 | (37.7198573805858, -122.47268299364) | 9 | 8 | 4 | 64 | 40 | |||
129053 | 215615 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 57 | : | Tree | Private 2 | 14 | Width 0ft | 5991138.24471 | 2090632.0819 | 37.719968115927 | -122.472685238326 | (37.719968115927, -122.472685238326) | 9 | 8 | 4 | 64 | 40 | |||
109913 | 215620 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 62 | : | Tree | Private 2 | 3 | Width 0ft | 5991138.86268 | 2090625.26013 | 37.7199494208 | -122.472682605115 | (37.7199494208, -122.472682605115) | 9 | 8 | 4 | 64 | 40 | |||
131302 | 215645 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 88 | : | Tree | Private 2 | 15 | Width 0ft | 5991139.08964 | 2090556.83392 | 37.7197615524271 | -122.472676834191 | (37.7197615524271, -122.472676834191) | 9 | 8 | 4 | 64 | 40 | |||
26371 | 215624 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 66 | : | Tree | Private 2 | 4 | Width 0ft | 5991139.11135 | 2090614.21248 | 37.7199191010706 | -122.472680940482 | (37.7199191010706, -122.472680940482) | 9 | 8 | 4 | 64 | 40 | |||
152689 | 215628 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 71 | : | Tree | Private 2 | 11 | Width 0ft | 5991139.39343 | 2090599.41814 | 37.7198784957874 | -122.472678887333 | (37.7198784957874, -122.472678887333) | 9 | 8 | 4 | 64 | 40 | |||
78845 | 215641 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 84 | : | Tree | Private 2 | 24 | Width 0ft | 5991139.80827 | 2090562.73433 | 37.719777795098 | -122.472674780143 | (37.719777795098, -122.472674780143) | 9 | 8 | 4 | 64 | 40 | |||
21007 | 215640 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 83 | : | Tree | Private 2 | 5 | Width 0ft | 5991139.98278 | 2090571.01197 | 37.7198005335596 | -122.472674780143 | (37.7198005335596, -122.472674780143) | 9 | 8 | 4 | 64 | 40 | |||
68561 | 215635 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 78 | : | Tree | Private 2 | 3 | Width 0ft | 5991140.25702 | 2090584.02001 | 37.7198362663069 | -122.47267478013 | (37.7198362663069, -122.47267478013) | 9 | 8 | 4 | 64 | 40 | |||
15030 | 215614 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 55 | : | Tree | Private 2 | 5 | Width 0ft | 5991140.92054 | 2090646.29638 | 37.7200073002795 | -122.472677024844 | (37.7200073002795, -122.472677024844) | 9 | 8 | 4 | 64 | 40 | |||
119802 | 215647 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 90 | : | Tree | Private 2 | 5 | Width 0ft | 5991141.92136 | 2090550.26747 | 37.7197436864904 | -122.472666567521 | (37.7197436864904, -122.472666567521) | 9 | 8 | 4 | 64 | 40 | |||
82986 | 215646 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 89 | : | Tree | Private 2 | 21 | Width 0ft | 5991144.95252 | 2090553.16119 | 37.7197518073936 | -122.47265630085 | (37.7197518073936, -122.47265630085) | 9 | 8 | 4 | 64 | 40 | |||
187041 | 215631 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 74 | : | Tree | Private 2 | 4 | Width 0ft | 5991145.11917 | 2090589.24121 | 37.7198508838856 | -122.472658354026 | (37.7198508838856, -122.472658354026) | 9 | 8 | 4 | 64 | 40 | |||
80496 | 215623 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 65 | : | Tree | Private 2 | 7 | Width 0ft | 5991145.2526 | 2090614.88415 | 37.7199213008035 | -122.472659761464 | (37.7199213008035, -122.472659761464) | 9 | 8 | 4 | 64 | 40 | |||
109389 | 215616 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 58 | : | Tree | Private 2 | 18 | Width 0ft | 5991145.54579 | 2090633.22173 | 37.7199716682503 | -122.472660084316 | (37.7199716682503, -122.472660084316) | 9 | 8 | 4 | 64 | 40 | |||
114188 | 215629 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 72 | : | Tree | Private 2 | 6 | Width 0ft | 5991145.86247 | 2090596.32414 | 37.7198703748925 | -122.47265630087 | (37.7198703748925, -122.47265630087) | 9 | 8 | 4 | 64 | 40 | |||
86503 | 215650 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 101 | : | Tree | Private 2 | 14 | Width 0ft | 5991145.97307 | 2090449.2056 | 37.7194664300225 | -122.472645197812 | (37.7194664300225, -122.472645197812) | 9 | 8 | 4 | 64 | 40 | |||
37019 | 215613 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 54 | : | Tree | Private 2 | 6 | Width 0ft | 5991146.23554 | 2090648.32868 | 37.7200131881383 | -122.472658800987 | (37.7200131881383, -122.472658800987) | 9 | 8 | 4 | 64 | 40 | |||
79311 | 215642 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 85 | : | Tree | Private 2 | 3 | Width 0ft | 5991146.32719 | 2090562.00537 | 37.7197761709066 | -122.47265219364 | (37.7197761709066, -122.47265219364) | 9 | 8 | 4 | 64 | 40 | |||
42318 | 215622 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 64 | : | Tree | Private 2 | 3 | Width 0ft | 5991146.64961 | 2090624.80021 | 37.7199486087273 | -122.472655655135 | (37.7199486087273, -122.472655655135) | 9 | 8 | 4 | 64 | 40 | |||
69926 | 215610 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 50 | : | Tree | Private 2 | 6 | Width 0ft | 5991146.77446 | 2090663.32778 | 37.7200544031655 | -122.472658031161 | (37.7200544031655, -122.472658031161) | 9 | 8 | 4 | 64 | 40 | |||
99459 | 215636 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 79 | : | Tree | Private 2 | 4 | Width 0ft | 5991147.9135 | 2090580.90098 | 37.7198281454204 | -122.472648087333 | (37.7198281454204, -122.472648087333) | 9 | 8 | 4 | 64 | 40 | |||
71995 | 215621 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 63 | : | Tree | Private 2 | 3 | Width 0ft | 5991148.36748 | 2090618.2199 | 37.7199306402575 | -122.47264923759 | (37.7199306402575, -122.47264923759) | 9 | 8 | 4 | 64 | 40 | |||
135806 | 215648 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 92 | : | Tree | Private 2 | 3 | Width 0ft | 5991148.46508 | 2090549.78954 | 37.7197427529995 | -122.472643913597 | (37.7197427529995, -122.472643913597) | 9 | 8 | 4 | 64 | 40 | |||
102888 | 215633 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 76 | : | Tree | Private 2 | 4 | Width 0ft | 5991148.61939 | 2090586.20981 | 37.7198427630201 | -122.472646034205 | (37.7198427630201, -122.472646034205) | 9 | 8 | 4 | 64 | 40 | |||
114365 | 215625 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 67 | : | Tree | Private 2 | 7 | Width 0ft | 5991149.77404 | 2090612.80464 | 37.7199158527073 | -122.472643981029 | (37.7199158527073, -122.472643981029) | 9 | 8 | 4 | 64 | 40 | |||
183862 | 215643 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 86 | : | Tree | Private 2 | 7 | Width 0ft | 5991150.43358 | 2090559.55238 | 37.7197696732999 | -122.472637820687 | (37.7197696732999, -122.472637820687) | 9 | 8 | 4 | 64 | 40 | |||
74728 | 215639 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 82 | : | Tree | Private 2 | 8 | Width 0ft | 5991150.62056 | 2090568.42161 | 37.7197940368438 | -122.472637820681 | (37.7197940368438, -122.472637820681) | 9 | 8 | 4 | 64 | 40 | |||
180812 | 215634 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 77 | : | Tree | Private 2 | 4 | Width 0ft | 5991150.93218 | 2090583.20344 | 37.7198346421452 | -122.472637820701 | (37.7198346421452, -122.472637820701) | 9 | 8 | 4 | 64 | 40 | |||
21569 | 215609 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 49 | : | Tree | Private 2 | 6 | Width 0ft | 5991151.21969 | 2090669.88886 | 37.7200726755881 | -122.472643143781 | (37.7200726755881, -122.472643143781) | 9 | 8 | 4 | 64 | 40 | |||
106003 | 215649 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 93 | : | Tree | Private 2 | 4 | Width 0ft | 5991151.37081 | 2090546.73366 | 37.7197345305043 | -122.472633646933 | (37.7197345305043, -122.472633646933) | 9 | 8 | 4 | 64 | 40 | |||
106318 | 215617 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 59 | : | Tree | Private 2 | 6 | Width 0ft | 5991151.60467 | 2090631.80024 | 37.71996811591 | -122.472639037473 | (37.71996811591, -122.472639037473) | 9 | 8 | 4 | 64 | 40 | |||
29564 | 215637 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 80 | : | Tree | Private 2 | 4 | Width 0ft | 5991151.99496 | 2090577.2658 | 37.7198184003677 | -122.472633714397 | (37.7198184003677, -122.472633714397) | 9 | 8 | 4 | 64 | 40 | |||
154974 | 215632 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 75 | : | Tree | Private 2 | 7 | Width 0ft | 5991152.25672 | 2090589.68226 | 37.7198525080596 | -122.472633714394 | (37.7198525080596, -122.472633714394) | 9 | 8 | 4 | 64 | 40 | |||
193502 | 215611 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 51 | : | Tree | Private 2 | 3 | Width 0ft | 5991153.406 | 2090660.89558 | 37.7200481088127 | -122.472634931171 | (37.7200481088127, -122.472634931171) | 9 | 8 | 4 | 64 | 40 | |||
193895 | 215604 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 38 | : | Tree | Private 2 | 3 | Width 0ft | 5991153.81619 | 2090748.1801 | 37.7202877943298 | -122.472639873854 | (37.7202877943298, -122.472639873854) | 9 | 8 | 4 | 64 | 40 | |||
25798 | 215644 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 87 | : | Tree | Private 2 | 4 | Width 0ft | 5991153.98366 | 2090558.88602 | 37.7197680491356 | -122.472625500878 | (37.7197680491356, -122.472625500878) | 9 | 8 | 4 | 64 | 40 | |||
33545 | 215612 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 53 | : | Tree | Private 2 | 1 | Width 0ft | 5991154.50456 | 2090649.59615 | 37.720017146953 | -122.472630310457 | (37.720017146953, -122.472630310457) | 9 | 8 | 4 | 64 | 40 | |||
178189 | 215608 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 48 | : | Tree | Private 2 | 2 | Width 0ft | 5991156.01629 | 2090675.51857 | 37.7200884110352 | -122.472626973968 | (37.7200884110352, -122.472626973968) | 9 | 8 | 4 | 64 | 40 | |||
69394 | 215626 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 68 | : | Tree | Private 2 | 3 | Width 0ft | 5991156.30566 | 2090612.66695 | 37.7199158527268 | -122.472621393671 | (37.7199158527268, -122.472621393671) | 9 | 8 | 4 | 64 | 40 | |||
18478 | 215618 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 60 | : | Tree | Private 2 | 8 | Width 0ft | 5991156.49559 | 2090631.32735 | 37.7199671005808 | -122.472622096952 | (37.7199671005808, -122.472622096952) | 9 | 8 | 4 | 64 | 40 | |||
123028 | 215619 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 61 | : | Tree | Private 2 | 10 | Width 0ft | 5991156.50194 | 2090623.66821 | 37.7199460708374 | -122.472621516875 | (37.7199460708374, -122.472621516875) | 9 | 8 | 4 | 64 | 40 | |||
5037 | 215607 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 47 | : | Tree | Private 2 | 2 | Width 0ft | 5991157.54734 | 2090681.21679 | 37.7201041455671 | -122.472622096933 | (37.7201041455671, -122.472622096933) | 9 | 8 | 4 | 64 | 40 | |||
38637 | 215605 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 39 | : | Tree | Private 2 | 6 | Width 0ft | 5991158.3667 | 2090738.6198 | 37.7202618075092 | -122.472623447724 | (37.7202618075092, -122.472623447724) | 9 | 8 | 4 | 64 | 40 | |||
38604 | 215638 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 81 | : | Tree | Private 2 | 17 | Width 0ft | 5991161.28352 | 2090567.01377 | 37.7197907884826 | -122.472600860358 | (37.7197907884826, -122.472600860358) | 9 | 8 | 4 | 64 | 40 | |||
146390 | 215627 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 69 | : | Tree | Private 2 | 13 | Width 0ft | 5991161.91923 | 2090597.16869 | 37.7198736232612 | -122.472600860338 | (37.7198736232612, -122.472600860338) | 9 | 8 | 4 | 64 | 40 | |||
122634 | 215606 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 40 | : | Tree | Private 2 | 11 | Width 0ft | 5991163.46661 | 2090729.52448 | 37.7202371292081 | -122.472605156414 | (37.7202371292081, -122.472605156414) | 9 | 8 | 4 | 64 | 40 | |||
171565 | 215603 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 168 | : | Tree | Private 2 | 16 | Width 0ft | 5991175.95809 | 2091313.63329 | 37.7218416708418 | -122.472604542184 | (37.7218416708418, -122.472604542184) | 9 | 8 | 4 | 64 | 40 | |||
177921 | 215602 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 166 | : | Tree | Private 2 | 4 | Width 0ft | 5991204.30373 | 2091328.48837 | 37.7218840999401 | -122.472507642021 | (37.7218840999401, -122.472507642021) | 9 | 8 | 4 | 64 | 40 | |||
153753 | 215601 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 155 | : | Tree | Private 2 | 15 | Width 0ft | 5991211.33426 | 2091424.54649 | 37.7221482587196 | -122.472490339055 | (37.7221482587196, -122.472490339055) | 9 | 8 | 4 | 64 | 40 | |||
148629 | 11741 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5991216.9689233 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | 9 | 8 | 4 | 64 | 40 | |||
159991 | 11737 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2x2 | 5991216.9689233 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | 9 | 8 | 4 | 64 | 40 | |||
30210 | 29915 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
77624 | 29916 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
86090 | 29917 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | |||
183540 | 29914 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
10113 | 11713 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
12848 | 11711 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
61390 | 26778 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
80212 | 26772 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
164981 | 11712 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
182532 | 26779 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
144774 | 215600 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 67 | : | Tree | Private 2 | 13 | Width 0ft | 5991265.70114 | 2092317.65324 | 37.7246036552159 | -122.472367482699 | (37.7246036552159, -122.472367482699) | 9 | 8 | 4 | 64 | 40 | |||
152584 | 215599 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 52 | : | Tree | Private 2 | 14 | Width 0ft | 5991273.40065 | 2092440.71249 | 37.7249419909714 | -122.47234983349 | (37.7249419909714, -122.47234983349) | 9 | 8 | 4 | 64 | 40 | |||
68257 | 215598 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 48 | : | Tree | Private 2 | 13 | Width 0ft | 5991274.41833 | 2092469.99796 | 37.7250224604947 | -122.472348449422 | (37.7250224604947, -122.472348449422) | 9 | 8 | 4 | 64 | 40 | |||
9603 | 215597 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 44 | : | Tree | Private 2 | 15 | Width 0ft | 5991275.01695 | 2092498.39745 | 37.7251004730822 | -122.472348449425 | (37.7251004730822, -122.472348449425) | 9 | 8 | 4 | 64 | 40 |
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) );