trees
430 rows where qSpecies_id = 99 sorted by Location
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 | |||||||||||||
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 | |||
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 | |||
68192 | 19105 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3155X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 5995592.56281 | 2086919.93217 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | 9 | 8 | 6 | 28861 | 25 | |||
98027 | 19106 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3155X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5995592.56281 | 2086919.93217 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | 9 | 8 | 6 | 28861 | 25 | |||
183223 | 19107 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3155X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5995592.56281 | 2086919.93217 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | 9 | 8 | 6 | 28861 | 25 | |||
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 | |||
119872 | 11873 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
179933 | 11874 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
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 | ||
49035 | 1182 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3003 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) | 9 | 7 | 6 | 28861 | 25 | |||
135925 | 1181 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3003 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) | 9 | 7 | 6 | 28861 | 25 | |||
9808 | 262587 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 203 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 5994963 | 2087365 | 37.7112181411096 | -122.459228007495 | (37.7112181411096, -122.459228007495) | 9 | 8 | 6 | 28861 | 24 | ||||
140798 | 19100 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 281 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 5994272.63935 | 2087395.39368 | 37.7112618807995 | -122.46161625041 | (37.7112618807995, -122.46161625041) | 9 | 8 | 6 | 28861 | 24 | |||
165369 | 19093 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 257 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5994426.29409 | 2087392.81881 | 37.7112636542582 | -122.461084998394 | (37.7112636542582, -122.461084998394) | 9 | 8 | 6 | 28861 | 24 | |||
179277 | 215591 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 233 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994635.36944 | 2087388.76073 | 37.7112645410012 | -122.460362092762 | (37.7112645410012, -122.460362092762) | 9 | 8 | 6 | 28861 | 24 | |||
45289 | 19085 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 231 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994662.28634 | 2087388.84238 | 37.7112663135508 | -122.460269067765 | (37.7112663135508, -122.460269067765) | 9 | 8 | 6 | 28861 | 24 | |||
23482 | 19082 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 227 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994691.47902 | 2087389.19966 | 37.7112689737437 | -122.460168197108 | (37.7112689737437, -122.460168197108) | 9 | 8 | 6 | 28861 | 24 | |||
173609 | 19078 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 215 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3X3 | 5994825.04396 | 2087387.37086 | 37.7112716339463 | -122.459706433929 | (37.7112716339463, -122.459706433929) | 9 | 8 | 6 | 28861 | 24 | |||
165263 | 19071 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 203 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5994967.06362 | 2087386.65714 | 37.7112778401642 | -122.459215529972 | (37.7112778401642, -122.459215529972) | 9 | 8 | 6 | 28861 | 24 | |||
152604 | 19063 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 175 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995252.88797 | 2087382.67456 | 37.7112833332178 | -122.458227367525 | (37.7112833332178, -122.458227367525) | 9 | 8 | 6 | 28861 | 24 | |||
32172 | 215592 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 177 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995226.8577 | 2087383.90223 | 37.7112852083174 | -122.458317422904 | (37.7112852083174, -122.458317422904) | 9 | 8 | 6 | 28861 | 24 | |||
35965 | 19053 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 141 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5995501.70307 | 2087378.49279 | 37.7112861454175 | -122.457367103015 | (37.7112861454175, -122.457367103015) | 9 | 8 | 6 | 28861 | 24 | |||
60286 | 19057 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 155 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995437.65535 | 2087381.53973 | 37.7112908326789 | -122.457588686968 | (37.7112908326789, -122.457588686968) | 9 | 8 | 6 | 28861 | 24 | |||
5701 | 215593 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 103 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5995757.42889 | 2087376.90008 | 37.7112964570463 | -122.456483140498 | (37.7112964570463, -122.456483140498) | 9 | 8 | 6 | 28861 | 24 | |||
3714 | 19086 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 235 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994700.7848896 | 2087405.1340273 | 37.7113132610353 | -122.460137187577 | (37.7113132610353, -122.460137187577) | 9 | 8 | 6 | 28861 | 24 | |||
182658 | 19065 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 179 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5995218.7218404 | 2087397.9242615 | 37.7113232420063 | -122.458346556584 | (37.7113232420063, -122.458346556584) | 9 | 8 | 6 | 28861 | 24 | |||
85776 | 19045 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 111 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995778.7610227 | 2087391.1107423 | 37.7113367008986 | -122.456410438628 | (37.7113367008986, -122.456410438628) | 9 | 8 | 6 | 28861 | 24 | |||
32871 | 26823 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5994408.88806 | 2087459.5005113 | 37.7114457448338 | -122.461149987895 | (37.7114457448338, -122.461149987895) | 9 | 8 | 6 | 28861 | 24 | |||
93616 | 19090 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X4 | 5994507.8215972 | 2087458.0224559 | 37.7114473793836 | -122.460807943318 | (37.7114473793836, -122.460807943318) | 9 | 8 | 6 | 28861 | 24 | |||
184791 | 1218 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3575X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 5993629.70146 | 2087487.19649 | 37.711476919919 | -122.463845046869 | (37.711476919919, -122.463845046869) | 9 | 8 | 4 | 64 | 24 | |||
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 | |||
9727 | 25337 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2000 12:00:00 AM | 15 | 3X3 | 5994336.66394 | 2087473.55865 | 37.7114801885417 | -122.461400629858 | (37.7114801885417, -122.461400629858) | 9 | 8 | 6 | 28861 | 24 | ||
73537 | 19097 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 276 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2X2 | 5994245.51556 | 2087475.81103 | 37.711481126537 | -122.461715823343 | (37.711481126537, -122.461715823343) | 9 | 8 | 6 | 28861 | 24 | |||
115808 | 19088 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 238 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 5994602.31297 | 2087471.0641 | 37.7114886250695 | -122.460482303322 | (37.7114886250695, -122.460482303322) | 9 | 8 | 6 | 28861 | 24 | |||
84065 | 19069 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 200 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994992.35128 | 2087465.62621 | 37.711496124512 | -122.459133844577 | (37.711496124512, -122.459133844577) | 9 | 8 | 6 | 28861 | 24 | |||
68937 | 19072 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 204 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 5994955.69063 | 2087466.73543 | 37.7114970625193 | -122.459260632792 | (37.7114970625193, -122.459260632792) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
131642 | 1257 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3801 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 1X3 | 5992919.7951 | 2087516.70947 | 37.7115170200575 | -122.466300791391 | (37.7115170200575, -122.466300791391) | 9 | 8 | 4 | 64 | 24 | |||
1332 | 215594 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5994385 | 2087488 | 37.7115226229707 | -122.461234615187 | (37.7115226229707, -122.461234615187) | 9 | 8 | 6 | 28861 | 24 | |||
92916 | 1258 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3815 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5992861.70969 | 2087523.33873 | 37.7115318707666 | -122.466502029665 | (37.7115318707666, -122.466502029665) | 9 | 8 | 4 | 64 | 24 | |||
173034 | 1248 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3731 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 5993002.94201 | 2087547.889 | 37.7116074287673 | -122.466015680425 | (37.7116074287673, -122.466015680425) | 9 | 8 | 4 | 64 | 24 | |||
144590 | 1250 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3743 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X6 | 5993011.32335 | 2087550.57925 | 37.7116152990749 | -122.465986907877 | (37.7116152990749, -122.465986907877) | 9 | 8 | 4 | 64 | 24 | |||
68463 | 11849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1401X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3 | 5991539.129622 | 2088082.4465587 | 37.7129906371476 | -122.471113878415 | (37.7129906371476, -122.471113878415) | 9 | 8 | 6 | 64 | 24 | |||
166456 | 175374 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80x Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5991412.70367 | 2088734.17301 | 37.7147728061926 | -122.471598306927 | (37.7147728061926, -122.471598306927) | 9 | 8 | 6 | 64 | 24 | |||
178273 | 175047 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 5991389.20246 | 2088805.53688 | 37.7149673943122 | -122.47168473357 | (37.7149673943122, -122.47168473357) | 9 | 8 | 6 | 64 | 24 | |||
85602 | 175377 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991371.46907 | 2088876.77956 | 37.7151619833268 | -122.471751215951 | (37.7151619833268, -122.471751215951) | 9 | 8 | 6 | 64 | 24 | |||
42710 | 175378 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5991360.88178 | 2088922.01369 | 37.715285572641 | -122.471791104494 | (37.715285572641, -122.471791104494) | 9 | 8 | 6 | 64 | 24 | |||
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 | |||
57726 | 177713 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 3ft | 5991322.37032 | 2089056.90035 | 37.7156537101333 | -122.471934040933 | (37.7156537101333, -122.471934040933) | 9 | 8 | 6 | 64 | 24 | |||
825 | 175382 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80x Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 2 | Width 3ft | 5991305.51807 | 2089124.29272 | 37.7158377779634 | -122.471997198511 | (37.7158377779634, -122.471997198511) | 9 | 8 | 6 | 64 | 24 | |||
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 | |||
35213 | 1085 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2156 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5999963.70084 | 2089791.48987 | 37.7181669663093 | -122.442118458302 | (37.7181669663093, -122.442118458302) | 9 | 7 | 6 | 28861 | 25 | |||
174705 | 180593 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2136 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6000017.35738 | 2089840.46995 | 37.7183045122206 | -122.441936504777 | (37.7183045122206, -122.441936504777) | 9 | 7 | 6 | 28861 | 25 | |||
6804 | 1081 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2144 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 5999999.92726 | 2089842.39347 | 37.718308800511 | -122.441996891163 | (37.718308800511, -122.441996891163) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
61972 | 19303 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2087X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6000281.49897 | 2089976.15715 | 37.7186921269443 | -122.441033210291 | (37.7186921269443, -122.441033210291) | 9 | 7 | 6 | 28861 | 25 | |||
165558 | 1066 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2075X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000333.40297 | 2090026.65578 | 37.7188337409507 | -122.440857420165 | (37.7188337409507, -122.440857420165) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||||
26642 | 1061 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2061X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6000441.22371 | 2090128.46046 | 37.7191194136535 | -122.440492025318 | (37.7191194136535, -122.440492025318) | 9 | 7 | 6 | 28861 | 25 | |||
147868 | 1060 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2059X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6000457.16463 | 2090146.24433 | 37.7191691518296 | -122.440438198589 | (37.7191691518296, -122.440438198589) | 9 | 7 | 6 | 28861 | 25 | |||
138849 | 1058 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2055X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6000480.4143 | 2090166.82631 | 37.719226989106 | -122.440359308841 | (37.719226989106, -122.440359308841) | 9 | 7 | 6 | 28861 | 25 | |||
167729 | 1056 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2049X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6000499.53685 | 2090188.32691 | 37.7192871136702 | -122.440294750677 | (37.7192871136702, -122.440294750677) | 9 | 7 | 6 | 28861 | 25 | |||
32835 | 1054 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2045X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000521.13381 | 2090206.39855 | 37.7193379639287 | -122.440221393554 | (37.7193379639287, -122.440221393554) | 9 | 7 | 6 | 28861 | 25 | |||
161940 | 1052 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2039X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6000548.43841 | 2090229.36669 | 37.719402583767 | -122.44012865812 | (37.719402583767, -122.44012865812) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
187564 | 1051 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2035X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6000572.81835 | 2090254.90744 | 37.7194741008396 | -122.440046216346 | (37.7194741008396, -122.440046216346) | 9 | 7 | 6 | 28861 | 25 | |||
12178 | 1048 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2029X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6000595.57615 | 2090275.75201 | 37.719532630863 | -122.439969044998 | (37.719532630863, -122.439969044998) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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) );