trees
430 rows where qSpecies_id = 99 sorted by SiteOrder 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 5897 | 199851 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014366.3226 | 2092462.8184 | 37.7263121847089 | -122.392521119846 | (37.7263121847089, -122.392521119846) | 10 | 3 | 8 | 58 | 1 | |||
| 16067 | 19787 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100 STAIRWAY19 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 50ST | |||||||||||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 91152 | 11692 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 167355 | 215581 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5991373.01779 | 2092318.20321 | 37.7246113758903 | -122.471996546509 | (37.7246113758903, -122.471996546509) | 9 | 8 | 4 | 59 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 69680 | 397 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990474.69146 | 2090771.67661 | 37.720312975301 | -122.474989074306 | (37.720312975301, -122.474989074306) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 166529 | 11718 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 899X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 80212 | 26772 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
| 86090 | 29917 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 89577 | 215596 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 500 Junipero Serra Blvd | 52 | : | Tree | Private 2 | 13 | Width 0ft | 5991321.6635 | 2093392.10663 | 37.7275570755768 | -122.472252316385 | (37.7275570755768, -122.472252316385) | 9 | 8 | 4 | 64 | 40 | |||
| 152584 | 215599 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 52 | : | Tree | Private 2 | 14 | Width 0ft | 5991273.40065 | 2092440.71249 | 37.7249419909714 | -122.47234983349 | (37.7249419909714, -122.47234983349) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | |||
| 193502 | 215611 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 51 | : | Tree | Private 2 | 3 | Width 0ft | 5991153.406 | 2090660.89558 | 37.7200481088127 | -122.472634931171 | (37.7200481088127, -122.472634931171) | 9 | 8 | 4 | 64 | 40 | |||
| 69926 | 215610 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 50 | : | Tree | Private 2 | 6 | Width 0ft | 5991146.77446 | 2090663.32778 | 37.7200544031655 | -122.472658031161 | (37.7200544031655, -122.472658031161) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 70264 | 7477 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 5 | 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 | |||
| 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 | ||||
| 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 | |||
| 77624 | 29916 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
| 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 | |||
| 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 |
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) );