trees
430 rows where qSpecies_id = 99 sorted by Supervisor 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 | |||||||||||||
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 | ||||
4371 | 45657 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1330 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2001 12:00:00 AM | 18 | Permit Number 44353 | 6006599 | 2119096 | 37.7990062508654 | -122.421262834262 | (37.7990062508654, -122.421262834262) | 13 | 9 | 1 | 28858 | 32 | ||
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 | |||||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
136804 | 106867 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1974 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003576.11959 | 2118663.726 | 37.7976484534674 | -122.431692125901 | (37.7976484534674, -122.431692125901) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
152819 | 124688 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 460 Arguello Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5995612.53793 | 2113341.5687 | 37.7825806328494 | -122.458862568059 | (37.7825806328494, -122.458862568059) | 11 | 6 | 1 | 54 | 31 | |||
153831 | 124641 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 60 Arguello Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5995529.17868 | 2115583.09769 | 37.7887304767053 | -122.459313330112 | (37.7887304767053, -122.459313330112) | 11 | 6 | 1 | 54 | 31 | |||
157104 | 1434 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X5 | 5995535.03638 | 2115411.50396 | 37.7882596635004 | -122.459280632339 | (37.7882596635004, -122.459280632339) | 11 | 6 | 1 | 54 | 31 | |||
159736 | 124642 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995529.95307 | 2115590.13506 | 37.7887498439417 | -122.459311160683 | (37.7887498439417, -122.459311160683) | 11 | 6 | 1 | 54 | 31 | |||
161310 | 137073 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3598 Clay St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 5997662.02457 | 2115459.05462 | 37.7885122812527 | -122.451925075987 | (37.7885122812527, -122.451925075987) | 11 | 6 | 1 | 54 | 31 | |||
161460 | 137077 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2955 Steiner St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | Width 5ft | 6001974.03932 | 2118352.39854 | 37.796702688621 | -122.437213445266 | (37.796702688621, -122.437213445266) | 13 | 9 | 1 | 57 | 17 | |||
164727 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 1636 Bush St | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665 | 2115204 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | 13 | 9 | 1 | 28858 | 41 | |||
164973 | 1430 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 5 | 5995476.6114 | 2115563.93405 | 37.7886748361207 | -122.459493815623 | (37.7886748361207, -122.459493815623) | 11 | 6 | 1 | 54 | 11 | |||
168411 | 1542 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5995618.1476548 | 2113146.4510222 | 37.7820452142622 | -122.458829030078 | (37.7820452142622, -122.458829030078) | 11 | 6 | 1 | 54 | 31 | |||
170778 | 1526 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 440 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3x3 | 5995608.48873 | 2113422.41383 | 37.7828023792183 | -122.458882431606 | (37.7828023792183, -122.458882431606) | 11 | 6 | 1 | 54 | 31 | |||
176937 | 137070 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5997942.37701 | 2116329.50618 | 37.7909183634316 | -122.451017898383 | (37.7909183634316, -122.451017898383) | 11 | 6 | 1 | 54 | 31 | |||
176981 | 1420 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3x3 | 5995529.5957 | 2115606.06371 | 37.7887935591586 | -122.459313551095 | (37.7887935591586, -122.459313551095) | 11 | 6 | 1 | 54 | 31 | |||
183694 | 2933 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1834 California St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/1997 12:00:00 AM | 7 | 3X3 | 6005503.04257 | 2115905.51621 | 37.7901841403418 | -122.424828114668 | (37.7901841403418, -122.424828114668) | 13 | 9 | 1 | 28858 | 27 | ||
185164 | 1474 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 234 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x5 | 5995562.8915 | 2114652.71711 | 37.7861778408698 | -122.459129293157 | (37.7861778408698, -122.459129293157) | 11 | 6 | 1 | 54 | 31 | |||
186153 | 105882 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 250 Locust St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 5997612.13513 | 2115509.12693 | 37.7886469088657 | -122.45210129905 | (37.7886469088657, -122.45210129905) | 11 | 6 | 1 | 54 | 31 | ||||
188888 | 1435 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 101X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 5 | 5995475.98082 | 2115376.20265 | 37.7881593402184 | -122.459482395726 | (37.7881593402184, -122.459482395726) | 11 | 6 | 1 | 54 | 11 | |||
190088 | 1432 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 5 | 5995472.27833 | 2115471.9588 | 37.7884220478225 | -122.45950214341 | (37.7884220478225, -122.45950214341) | 11 | 6 | 1 | 54 | 11 | |||
8385 | 83273 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6008750.42598 | 2118601.99703 | 37.7977708970553 | -122.413783193943 | (37.7977708970553, -122.413783193943) | 5 | 1 | 10 | 308 | 21 | |||
27130 | 137079 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008755.55812 | 2118570.22529 | 37.7976839479247 | -122.413763186745 | (37.7976839479247, -122.413763186745) | 5 | 1 | 10 | 308 | 21 | |||
56066 | 137081 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1627 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008775.75798 | 2118410.46159 | 37.7972464106437 | -122.413681983361 | (37.7972464106437, -122.413681983361) | 5 | 1 | 10 | 308 | 21 | |||
73351 | 142972 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2010 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6009915.1882 | 2121025.8734 | 37.8044916046862 | -122.409923973004 | (37.8044916046862, -122.409923973004) | 3 | 1 | 10 | 308 | 23 | |||
74287 | 137080 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008758.62885 | 2118554.07509 | 37.7976397759128 | -122.41375141819 | (37.7976397759128, -122.41375141819) | 5 | 1 | 10 | 308 | 21 | |||
76840 | 117189 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008262.17379 | 2117224.41185 | 37.7939609578909 | -122.415375111785 | (37.7939609578909, -122.415375111785) | 5 | 1 | 10 | 28858 | 21 | |||
112007 | 39229 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 15 | 3x3 | Permit Number 40871 | 6008226.63206 | 2117220.68496 | 37.793948727108 | -122.415497826087 | (37.793948727108, -122.415497826087) | 5 | 1 | 10 | 28858 | 21 | |
117175 | 142975 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2000 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6009927.4614 | 2120951.259 | 37.8042874199173 | -122.409876230033 | (37.8042874199173, -122.409876230033) | 3 | 1 | 10 | 308 | 23 | |||
123836 | 102615 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 392 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6009946.866 | 2120935.8276 | 37.8042461365953 | -122.409807988636 | (37.8042461365953, -122.409807988636) | 3 | 1 | 10 | 308 | 23 | |||
146878 | 16359 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1306x Montgomery St | 3 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011459.70542 | 2119848.6083 | 37.8013455628052 | -122.404496083149 | (37.8013455628052, -122.404496083149) | 3 | 1 | 10 | 308 | 23 | |||
159593 | 107483 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1306x Montgomery St | 6 | Median : Cutout | Tree | DPW 1 | 17 | 6011458.52251 | 2119859.64432 | 37.8013757989196 | -122.404500953851 | (37.8013757989196, -122.404500953851) | 3 | 1 | 10 | 308 | 23 | ||||
160279 | 142976 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 392 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6009963.6556 | 2120937.6931 | 37.8042521996842 | -122.409750018417 | (37.8042521996842, -122.409750018417) | 3 | 1 | 10 | 308 | 23 | |||
174305 | 137082 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1627 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008777.37552 | 2118389.76877 | 37.7971896841052 | -122.413674921875 | (37.7971896841052, -122.413674921875) | 5 | 1 | 10 | 308 | 21 | |||
191892 | 137078 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008753.16727 | 2118586.36158 | 37.7977281199218 | -122.413772601749 | (37.7977281199218, -122.413772601749) | 5 | 1 | 10 | 308 | 21 | |||
32925 | 10723 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
37400 | 10722 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 9 | 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 | |||
41457 | 10719 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 6 | 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 | |||
46485 | 6279 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003832.24761 | 2113162.85488 | 37.7825589718872 | -122.430413166544 | (37.7825589718872, -122.430413166544) | 7 | 9 | 11 | 29490 | 41 | |||
50531 | 242796 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 140 Belgrave Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 2ft | 5997883.86583 | 2104916.82278 | 37.7595787374877 | -122.450397275322 | (37.7595787374877, -122.450397275322) | 15 | 5 | 11 | 29492 | 12 | |||
53699 | 10721 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 8 | 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 | |||
68307 | 6271 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004021.46971 | 2113238.82139 | 37.7827782737541 | -122.429763959937 | (37.7827782737541, -122.429763959937) | 7 | 9 | 11 | 29490 | 41 | |||
68509 | 6281 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 4 | 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 | |||
68771 | 6272 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003992.00537 | 2113234.021 | 37.782763424573 | -122.429865551596 | (37.782763424573, -122.429865551596) | 7 | 9 | 11 | 29490 | 41 | |||
76530 | 10718 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 5 | 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 | |||
76992 | 6280 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 3 | 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 | |||
89806 | 6273 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003962.57834 | 2113230.61655 | 37.78275241032 | -122.429967113747 | (37.78275241032, -122.429967113747) | 7 | 9 | 11 | 29490 | 41 | |||
94192 | 10715 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 2 | 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 | |||
96176 | 10720 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 7 | 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 | |||
98627 | 6282 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 5 | 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 | |||
102768 | 142234 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6004609.2702 | 2110836.2012 | 37.7762145389853 | -122.427559190874 | (37.7762145389853, -122.427559190874) | 7 | 9 | 11 | 28852 | 10 | |||
104079 | 10714 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 1 | 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 | |||
107344 | 6284 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 7 | 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 | |||
118533 | 6276 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1421X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003957.21776 | 2113179.66455 | 37.7826122052638 | -122.429982023346 | (37.7826122052638, -122.429982023346) | 7 | 9 | 11 | 29490 | 41 | |||
123890 | 253385 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1100 Golden Gate Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004275 | 2112509 | 37.7807887188922 | -122.428834805692 | (37.7807887188922, -122.428834805692) | 7 | 9 | 11 | 29490 | 41 | |||||
131369 | 6275 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1421X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003957.21776 | 2113179.66455 | 37.7826122052638 | -122.429982023346 | (37.7826122052638, -122.429982023346) | 7 | 9 | 11 | 29490 | 41 | |||
135722 | 10716 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 3 | 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 | |||
137453 | 6274 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003886.01337 | 2113219.41254 | 37.7827173105424 | -122.430231196525 | (37.7827173105424, -122.430231196525) | 7 | 9 | 11 | 29490 | 41 | |||
142481 | 26486 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 8 | 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 | |||
149879 | 5927 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/2016 12:00:00 AM | 12 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | ||
154835 | 137076 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 Hayes St | 4 | : | Tree | Private 2 | 19 | Width 4ft | 6004731.62731 | 2110853.90859 | 37.7762700791404 | -122.427137185641 | (37.7762700791404, -122.427137185641) | 7 | 9 | 11 | 28852 | 10 | |||
162496 | 142237 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004726.9033 | 2110859.9695 | 37.7762864537737 | -122.427153959111 | (37.7762864537737, -122.427153959111) | 7 | 9 | 11 | 28852 | 10 |
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) );