trees
430 rows where qSpecies_id = 99 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5037 | 215607 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 47 | : | Tree | Private 2 | 2 | Width 0ft | 5991157.54734 | 2090681.21679 | 37.7201041455671 | -122.472622096933 | (37.7201041455671, -122.472622096933) | 9 | 8 | 4 | 64 | 40 | |||
9603 | 215597 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 44 | : | Tree | Private 2 | 15 | Width 0ft | 5991275.01695 | 2092498.39745 | 37.7251004730822 | -122.472348449425 | (37.7251004730822, -122.472348449425) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
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 | |||
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 | |||
21569 | 215609 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 49 | : | Tree | Private 2 | 6 | Width 0ft | 5991151.21969 | 2090669.88886 | 37.7200726755881 | -122.472643143781 | (37.7200726755881, -122.472643143781) | 9 | 8 | 4 | 64 | 40 | |||
25798 | 215644 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 87 | : | Tree | Private 2 | 4 | Width 0ft | 5991153.98366 | 2090558.88602 | 37.7197680491356 | -122.472625500878 | (37.7197680491356, -122.472625500878) | 9 | 8 | 4 | 64 | 40 | |||
26371 | 215624 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 66 | : | Tree | Private 2 | 4 | Width 0ft | 5991139.11135 | 2090614.21248 | 37.7199191010706 | -122.472680940482 | (37.7199191010706, -122.472680940482) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
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 | |||
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 | |||
37019 | 215613 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 54 | : | Tree | Private 2 | 6 | Width 0ft | 5991146.23554 | 2090648.32868 | 37.7200131881383 | -122.472658800987 | (37.7200131881383, -122.472658800987) | 9 | 8 | 4 | 64 | 40 | |||
38604 | 215638 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 81 | : | Tree | Private 2 | 17 | Width 0ft | 5991161.28352 | 2090567.01377 | 37.7197907884826 | -122.472600860358 | (37.7197907884826, -122.472600860358) | 9 | 8 | 4 | 64 | 40 | |||
38637 | 215605 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 39 | : | Tree | Private 2 | 6 | Width 0ft | 5991158.3667 | 2090738.6198 | 37.7202618075092 | -122.472623447724 | (37.7202618075092, -122.472623447724) | 9 | 8 | 4 | 64 | 40 | |||
42318 | 215622 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 64 | : | Tree | Private 2 | 3 | Width 0ft | 5991146.64961 | 2090624.80021 | 37.7199486087273 | -122.472655655135 | (37.7199486087273, -122.472655655135) | 9 | 8 | 4 | 64 | 40 | |||
68257 | 215598 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 48 | : | Tree | Private 2 | 13 | Width 0ft | 5991274.41833 | 2092469.99796 | 37.7250224604947 | -122.472348449422 | (37.7250224604947, -122.472348449422) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
153753 | 215601 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 155 | : | Tree | Private 2 | 15 | Width 0ft | 5991211.33426 | 2091424.54649 | 37.7221482587196 | -122.472490339055 | (37.7221482587196, -122.472490339055) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
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 | |||
171565 | 215603 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 168 | : | Tree | Private 2 | 16 | Width 0ft | 5991175.95809 | 2091313.63329 | 37.7218416708418 | -122.472604542184 | (37.7218416708418, -122.472604542184) | 9 | 8 | 4 | 64 | 40 | |||
177921 | 215602 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 166 | : | Tree | Private 2 | 4 | Width 0ft | 5991204.30373 | 2091328.48837 | 37.7218840999401 | -122.472507642021 | (37.7218840999401, -122.472507642021) | 9 | 8 | 4 | 64 | 40 | |||
178189 | 215608 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 48 | : | Tree | Private 2 | 2 | Width 0ft | 5991156.01629 | 2090675.51857 | 37.7200884110352 | -122.472626973968 | (37.7200884110352, -122.472626973968) | 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 | |||
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 | |||
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 | |||
189616 | 137075 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 689 Hayes St | 1 | : | Tree | Private 2 | 24 | Width 5ft | 6004617.55273 | 2110839.21576 | 37.776223284701 | -122.42753075415 | (37.776223284701, -122.42753075415) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
193895 | 215604 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 38 | : | Tree | Private 2 | 3 | Width 0ft | 5991153.81619 | 2090748.1801 | 37.7202877943298 | -122.472639873854 | (37.7202877943298, -122.472639873854) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||||
51308 | 242791 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1001 San Jose Ave | 14 | Front Yard : Yard | Tree | Private 2 | 5 | 6005175.70924 | 2096892.88162 | 37.7379614744454 | -122.424607638258 | (37.7379614744454, -122.424607638258) | 2 | 7 | 5 | 28859 | 2 | ||||
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 | |||||
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 | |||
193226 | 242792 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1200 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 37 | 6003987.76148 | 2095934.32271 | 37.7352623274905 | -122.428646648224 | (37.7352623274905, -122.428646648224) | 2 | 7 | 5 | 28861 | 7 | ||||
6823 | 11708 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991296.5308 | 2092759.13423 | 37.7258176365683 | -122.472293077282 | (37.7258176365683, -122.472293077282) | 9 | 8 | 4 | 64 | 40 | ||
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 | |||
33148 | 106883 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 180X SAN MARCOS AVE | 4 | Median : Cutout | Tree | Private 2 | DPW | 4 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | |||
80969 | 11747 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 30 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991286.94649 | 2092660.64259 | 37.7255466483325 | -122.4723190326 | (37.7255466483325, -122.4723190326) | 9 | 8 | 4 | 64 | 40 | ||
88692 | 106880 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 180X SAN MARCOS AVE | 3 | Median : Cutout | Tree | Private 2 | DPW | 5 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 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 | ||
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 | ||||
58765 | 242794 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2x Coso Ave | 4 | Median : Yard | Tree | DPW 1 | 30 | 6007112.52178 | 2099889.35747 | 37.746298321115 | -122.418123483128 | (37.746298321115, -122.418123483128) | 2 | 7 | 7 | 28859 | 2 | ||||
70794 | 242793 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2x Coso Ave | 1 | Median : Yard | Tree | DPW 1 | 30 | Width 9ft | 6007083.58829 | 2099965.0449 | 37.746504513177 | -122.418228897148 | (37.746504513177, -122.418228897148) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
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 | ||||
1798 | 242795 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1671 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009731.24755 | 2099988.43526 | 37.7467174150944 | -122.409075193563 | (37.7467174150944, -122.409075193563) | 2 | 7 | 7 | 28859 | 2 | |||
2820 | 899 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1161 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X5 | 6003541.15178 | 2094307.19105 | 37.7307693064514 | -122.43007470418 | (37.7307693064514, -122.43007470418) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
3741 | 228 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2974 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/1992 12:00:00 AM | 70 | 3X4 | 5990613.87863 | 2095369.93557 | 37.7329467072262 | -122.474843412516 | (37.7329467072262, -122.474843412516) | 1 | 8 | 4 | 64 | 40 | ||
3881 | 11625 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 300X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5991444.7104442 | 2094652.0546396 | 37.7310236980815 | -122.471918736195 | (37.7310236980815, -122.471918736195) | 9 | 8 | 4 | 64 | 40 | |||
4126 | 115471 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 10X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | ||||||||||||||
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 | ||
5204 | 7475 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 3 | 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 | |||
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 | |||
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 | |||
6012 | 16704 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1677X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 29 | 5x6 | 6001608.07304 | 2092347.28192 | 37.7252781710498 | -122.43661741688 | (37.7252781710498, -122.43661741688) | 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 | |||
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 | |||
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 | ||
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 | ||||
10113 | 11713 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
10682 | 978 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001786.79947 | 2092741.59351 | 37.7263710164051 | -122.436027780876 | (37.7263710164051, -122.436027780876) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
12102 | 180591 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1830 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6001183.24158 | 2091479.89441 | 37.7228723703333 | -122.438023911598 | (37.7228723703333, -122.438023911598) | 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 | ||||
12392 | 97505 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 20X 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672 | 2110712 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | 8 | 2 | 9 | 28853 | 34 | |
12848 | 11711 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
14050 | 180592 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1830 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 4ft | 6001143.73267 | 2091406.40414 | 37.72266833577 | -122.438155223402 | (37.72266833577, -122.438155223402) | 9 | 7 | 6 | 28861 | 25 |
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) );