trees
430 rows where qSpecies_id = 99 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
147602 | 939 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1325 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6002500.20649 | 2093846.32088 | 37.7294448514873 | -122.433640487323 | (37.7294448514873, -122.433640487323) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
144238 | 11689 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 2 | 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 | |||
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 | |||
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 | |||
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 | |||
141266 | 11695 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 12 | 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 | |||
141137 | 11752 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 35 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991283.50431 | 2092598.49549 | 37.7253758086322 | -122.472326403438 | (37.7253758086322, -122.472326403438) | 9 | 8 | 4 | 64 | 40 | ||
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 | |||
140491 | 1027 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1965X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 31 | 3X3 | 6000825.64245 | 2090608.45865 | 37.7204592623287 | -122.439197625247 | (37.7204592623287, -122.439197625247) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
139940 | 180580 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1282 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6002752.91911 | 2094123.24132 | 37.7302195481937 | -122.432786610727 | (37.7302195481937, -122.432786610727) | 9 | 7 | 5 | 28861 | 25 | |||
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 | |||
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 | |||
139373 | 215588 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 551 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991446.82162 | 2093469.8712 | 37.7277778402634 | -122.471825312909 | (37.7277778402634, -122.471825312909) | 9 | 8 | 4 | 59 | 40 | |||
139251 | 182465 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2400 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5986689.3022 | 2104396.9525 | 37.7575042689843 | -122.489074914666 | (37.7575042689843, -122.489074914666) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
138539 | 7474 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
137783 | 26171 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/01/2000 12:00:00 AM | 30 | 3x3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | ||
137645 | 215575 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 95 Kirkham St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 41 | Width 3ft | 5994715.1652 | 2105292.66043 | 37.76042882975 | -122.461383388048 | (37.76042882975, -122.461383388048) | 15 | 5 | 4 | 56 | 12 | |||
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 | |||
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 | |||
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 | |||
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 | |||
136001 | 180590 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1159 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6003628.44812 | 2094335.41976 | 37.7308517598817 | -122.429774919684 | (37.7308517598817, -122.429774919684) | 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 | |||
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 | |||
135732 | 4849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1469X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X6 | 6002249.52444 | 2093516.68285 | 37.7285255132222 | -122.434483558574 | (37.7285255132222, -122.434483558574) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
135020 | 979 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6001800.3284 | 2092768.49495 | 37.7264456502383 | -122.435982936161 | (37.7264456502383, -122.435982936161) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||
134673 | 7481 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
134263 | 11686 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 8 | 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 | |||
132451 | 99911 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 400 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005460.7 | 2101331.3 | 37.7501644526018 | -122.423937810125 | (37.7501644526018, -122.423937810125) | 2 | 4 | 5 | 28859 | 19 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
129130 | 7479 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
128474 | 974 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1599 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X5 | 6001933.92809 | 2093061.63022 | 37.7272581220521 | -122.435542049851 | (37.7272581220521, -122.435542049851) | 9 | 7 | 6 | 28861 | 25 | |||
127765 | 215585 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5991388.97305 | 2092569.49487 | 37.7253022836674 | -122.471959698575 | (37.7253022836674, -122.471959698575) | 9 | 8 | 4 | 59 | 40 | |||
127111 | 256855 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1777 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001446 | 2091921 | 37.7240984859228 | -122.437147179411 | (37.7240984859228, -122.437147179411) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | |||
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 | |||||
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 | |||
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 | |||
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 | |||
122123 | 199849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 6014322.4694 | 2092498.1446 | 37.7264067479006 | -122.392675189528 | (37.7264067479006, -122.392675189528) | 10 | 3 | 8 | 58 | 1 | |||
121575 | 215579 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 851 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991331.01602 | 2091664.09591 | 37.7228129287478 | -122.472094084291 | (37.7228129287478, -122.472094084291) | 9 | 8 | 4 | 59 | 40 | |||
121303 | 4850 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1499X ALEMANY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x6 | 6002180 | 2093376 | 37.7281352832027 | -122.43471385212 | (37.7281352832027, -122.43471385212) | 9 | 7 | 6 | 28861 | 25 | |||
120650 | 11619 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
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 | |||
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 | |||
119413 | 11722 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 899X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
119308 | 180582 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1110 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 6003793.49913 | 2094480.4258 | 37.7312592588934 | -122.429214647441 | (37.7312592588934, -122.429214647441) | 9 | 7 | 5 | 28861 | 25 | |||
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 | |||
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 | |||
116561 | 215595 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 400 Junipero Serra Blvd | 11 | : | Tree | Private 2 | 6 | Width 0ft | 5991368.98283 | 2094166.96047 | 37.7296873689589 | -122.47214519097 | (37.7296873689589, -122.47214519097) | 9 | 8 | 4 | 64 | 40 | |||
116110 | 215578 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 851 Junipero Serra Blvd | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5991318.68956 | 2091495.76578 | 37.7223500225082 | -122.472124430111 | (37.7223500225082, -122.472124430111) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | ||||
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 | |||
114230 | 11633 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 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 | |||
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 | |||
113992 | 51906 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 157 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.425598379966 | (37.7428856098168, -122.425598379966) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
107794 | 180585 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 177 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001325.27813 | 2093179.51545 | 37.7275472199251 | -122.43765458429 | (37.7275472199251, -122.43765458429) | 9 | 7 | 6 | 28861 | 25 | |||
107664 | 1035 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1989X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X6 | 6000752.12664 | 2090469.86783 | 37.7200745396752 | -122.439441815719 | (37.7200745396752, -122.439441815719) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
102794 | 215587 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 29 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 3ft | 5991411.41096 | 2092949.8935 | 37.7263480620905 | -122.47190984556 | (37.7263480620905, -122.47190984556) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | |||
101438 | 108311 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 439x ARLINGTON ST | 1 | Back Yard : Yard | Tree | Private 2 | 6003949.9 | 2096014.9 | 37.7354814316621 | -122.42878329169 | (37.7354814316621, -122.42878329169) | 2 | 7 | 5 | 63 | 7 | |||||
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 | |||
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 | |||
99292 | 11656 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 699X Junipero Serra Blvd | 16 | 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 | |||
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 | |||
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 | |||
98146 | 915 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1237 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003037.51053 | 2094134.66319 | 37.7302670467787 | -122.431803556408 | (37.7302670467787, -122.431803556408) | 9 | 7 | 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 | |||
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 |
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) );