trees

430 rows where qSpecies_id = 99 sorted by Supervisor Districts

✎ View and edit SQL

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)
168595 10717 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 50X Hollis St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003939.0547033 2113373.9919105 37.7831447510095 -122.430058726681 (37.7831447510095, -122.430058726681) 7 9 11 29490 41
189616 137075 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 689 Hayes St 1 : Tree Private 2     24 Width 5ft   6004617.55273 2110839.21576 37.776223284701 -122.42753075415 (37.776223284701, -122.42753075415) 7 9 11 28852 10
192958 6278 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1475 Ellis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.430193118546 (37.7821822086902, -122.430193118546) 7 9 11 29490 41
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
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
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
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
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
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
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
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
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
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
155276 1551 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 530 Arguello Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     125 3X3   5995634.85993 2112642.48366 37.7806624148094 -122.458734717129 (37.7806624148094, -122.458734717129) 11 6 2 54 16
156611 253429 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 2198 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2       5x7   5992046 2112030 37.7787737730441 -122.471105555235 (37.7787737730441, -122.471105555235) 11 6 2 54 11
156814 123644 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 499 Arguello Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5995555.16132 2113176.03479 37.7821228227737 -122.459049075391 (37.7821228227737, -122.459049075391) 11 6 2 54 11
169822 1581 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 629 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     125 3X3   5995601.12395 2111917.66113 37.7786703056802 -122.458798934123 (37.7786703056802, -122.458798934123) 11 6 2 54 11
170220 1597 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 714 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   5995688.036 2111228.67679 37.7767835321697 -122.458448388127 (37.7767835321697, -122.458448388127) 11 6 2 54 16
178234 1510 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 369 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 3x3   5995536.86997 2113765.1567 37.7837393424086 -122.459155027191 (37.7837393424086, -122.459155027191) 11 6 2 54 11
181960 123470 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 778 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   5995383.59468 2110411.06724 37.7745210919414 -122.459442307531 (37.7745210919414, -122.459442307531) 11 6 2 54 11
191957 123481 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 600 Arguello Blvd 11 Sidewalk: Curb side : Yard Tree Private 2     34     5995659.66948 2112025.6512 37.7789701827075 -122.458604223385 (37.7789701827075, -122.458604223385) 11 6 2 54 16
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3881 11625 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 300X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   5991444.7104442 2094652.0546396 37.7310236980815 -122.471918736195 (37.7310236980815, -122.471918736195) 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
6823 11708 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 700X Junipero Serra Blvd 25 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991296.5308 2092759.13423 37.7258176365683 -122.472293077282 (37.7258176365683, -122.472293077282) 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
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
11055 212275 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 751 Junipero Serra Blvd 8 Sidewalk: Curb side : Yard Tree Private 2     23 Width 3ft   5991369.83991 2092286.4262 37.7245239402122 -122.47200521689 (37.7245239402122, -122.47200521689) 9 8 4 59 40
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
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
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
18185 11652 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 699X Junipero Serra Blvd 9 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991405.9818619 2093130.1790735 37.7268427672434 -122.471941747662 (37.7268427672434, -122.471941747662) 9 8 4 59 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
18681 215586 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 751 Junipero Serra Blvd 18 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   5991393.38259 2092629.96723 37.725468580903 -122.471948860848 (37.725468580903, -122.471948860848) 9 8 4 59 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
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
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
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
22831 11871 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 1499X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8     24 3   5991566.5284818 2087248.8358641 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818) 9 8 4 64 24
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
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
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
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
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
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
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
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
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
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
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
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
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
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
43276 215577 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 95 Kirkham St 5 Sidewalk: Curb side : Yard Tree Private 2     48 Width 3ft   5994760.78175 2105295.21675 37.7604384740771 -122.461225807922 (37.7604384740771, -122.461225807922) 15 5 4 56 12
44462 215584 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 751 Junipero Serra Blvd 15 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   5991387.10122 2092540.18841 37.7252217070935 -122.471964034223 (37.7252217070935, -122.471964034223) 9 8 4 59 40
45200 215576 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 95 Kirkham St 4 Sidewalk: Curb side : Yard Tree Private 2     39 Width 3ft   5994736.06961 2105294.2713 37.7604344559039 -122.461311206651 (37.7604344559039, -122.461311206651) 15 5 4 56 12
46257 1259 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 3821 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   5992830.40302 2087513.47902 37.7115029917542 -122.466609516636 (37.7115029917542, -122.466609516636) 9 8 4 64 24
47049 215580 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 751 Junipero Serra Blvd 6 Sidewalk: Curb side : Yard Tree Private 2     24 Width 3ft   5991366.74972 2092229.04743 37.7243662135233 -122.472011718965 (37.7243662135233, -122.472011718965) 9 8 4 59 40
49919 11696 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 15 Sidewalk: Curb side : Cutout Tree PUC 8     30 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 40
55585 11626 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 300X Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   5991444.7104442 2094652.0546396 37.7310236980815 -122.471918736195 (37.7310236980815, -122.471918736195) 9 8 4 64 40
55591 11677 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 700X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   5991320.9947906 2093088.5989831 37.7267236805691 -122.472232513363 (37.7267236805691, -122.472232513363) 9 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
57509 1260 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 3827 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   5992804.99866 2087505.24822 37.7114789258702 -122.466696722103 (37.7114789258702, -122.466696722103) 9 8 4 64 24
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
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
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
63130 11668 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 700X Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   5991320.9947906 2093088.5989831 37.7267236805691 -122.472232513363 (37.7267236805691, -122.472232513363) 9 8 4 64 40
64978 11676 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 700X Junipero Serra Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   5991320.9947906 2093088.5989831 37.7267236805691 -122.472232513363 (37.7267236805691, -122.472232513363) 9 8 4 64 40
65090 11694 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 11 Sidewalk: Curb side : Cutout Tree PUC 8     18 3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 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
66722 215590 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 501 Junipero Serra Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     26 Width 3ft   5991474.9385 2093941.2931 37.7290738739428 -122.471762454787 (37.7290738739428, -122.471762454787) 9 8 4 59 40
67605 11627 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 300X Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   5991444.7104442 2094652.0546396 37.7310236980815 -122.471918736195 (37.7310236980815, -122.471918736195) 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
68289 11690 Permitted Site 7 Ulmus pumila :: Siberian Elm 99 799X Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout Tree PUC 8     30 3x3   5991356.324435 2092039.0089713 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425) 9 8 4 59 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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);