trees
3,709 rows where qSpecies_id = 9 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61431 | 253549 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 17 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:46:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
61668 | 1425 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 65 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 5X5PL | 5995464.37219 | 2115634.54937 | 37.7888680229269 | -122.459541277611 | (37.7888680229269, -122.459541277611) | 11 | 6 | 1 | 54 | 11 | |||
62815 | 87731 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.28256 | 37.8051028305372 | -122.4252793245 | (37.8051028305372, -122.4252793245) | 5 | 1 | 1 | 28858 | 32 | ||
63041 | 90506 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 501X 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988092.00394 | 2112515.24001 | 37.7798766147251 | -122.484819413349 | (37.7798766147251, -122.484819413349) | 11 | 6 | 2 | 55 | 26 | ||
64287 | 17781 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1791 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005398.00422 | 2115462.48899 | 37.7889617651253 | -122.42516000274 | (37.7889617651253, -122.42516000274) | 13 | 9 | 1 | 28858 | 41 | |||
64426 | 17802 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1880 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004940.7125532 | 2115448.2610788 | 37.7888968551774 | -122.42674115801 | (37.7888968551774, -122.42674115801) | 13 | 9 | 1 | 28858 | 27 | |||
64535 | 17907 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2300X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002864.2006 | 2115163.1915 | 37.7879965064632 | -122.43390521359 | (37.7879965064632, -122.43390521359) | 13 | 9 | 1 | 29490 | 27 | |||
64592 | 17210 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221X Olive St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006417.7103 | 2113696.81595 | 37.7841712140925 | -122.421506501194 | (37.7841712140925, -122.421506501194) | 7 | 9 | 11 | 28858 | 41 | |||
64692 | 12449 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2000X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2000 12:00:00 AM | 3 | 3x3 | 6004305.4732621 | 2115359.9984935 | 37.7886185728388 | -122.428932704083 | (37.7886185728388, -122.428932704083) | 13 | 9 | 11 | 29490 | 27 | ||
65256 | 90508 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 501X 25th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988094.51222 | 2112442.07437 | 37.7796758685878 | -122.484805367316 | (37.7796758685878, -122.484805367316) | 11 | 6 | 2 | 55 | 26 | ||
65643 | 18046 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2822X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/02/1997 12:00:00 AM | 6 | 3X3 | 6000423.541375 | 2114820.8548021 | 37.7869177338154 | -122.442324848283 | (37.7869177338154, -122.442324848283) | 13 | 6 | 1 | 29490 | 27 | ||
65806 | 254049 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2100X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 11:30:00 AM | 3 | 3x3 | 5992153.7416 | 2112063.95125 | 37.7788732250553 | -122.470735311921 | (37.7788732250553, -122.470735311921) | 11 | 6 | 2 | 54 | 11 | ||
66379 | 117843 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620x 39th Ave | 4 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 5983810.12526 | 2111540.49138 | 37.7769499228703 | -122.499560036853 | (37.7769499228703, -122.499560036853) | 11 | 6 | 2 | 55 | 26 | |||
66485 | 15930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5763 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5997809.15318 | 2086804.38451 | 37.7098420383501 | -122.449350673092 | (37.7098420383501, -122.449350673092) | 9 | 7 | 6 | 28861 | 5 | ||
66898 | 9727 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 621 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005801.3288 | 2111846.4513 | 37.779055793051 | -122.423507369454 | (37.779055793051, -122.423507369454) | 7 | 9 | 11 | 28852 | 41 | |||
67638 | 107486 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 8 | Median : Cutout | Tree | DPW 1 | 9 | 6011455.57226 | 2119886.90358 | 37.8014504813279 | -122.404513083014 | (37.8014504813279, -122.404513083014) | 3 | 1 | 10 | 308 | 23 | ||||
68221 | 17884 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2210 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003260.8806 | 2115214.139 | 37.7881588981801 | -122.432536413144 | (37.7881588981801, -122.432536413144) | 13 | 9 | 1 | 29490 | 27 | |||
68584 | 233635 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 795x San Jose Ave | 4 | Median : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6005628.85467 | 2098582.9928 | 37.7426277202009 | -122.423160990607 | (37.7426277202009, -122.423160990607) | 2 | 7 | 7 | 28859 | 2 | |||
70258 | 87733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005465.59287 | 2121464.41753 | 37.8054453543938 | -122.425353437905 | (37.8054453543938, -122.425353437905) | 5 | 1 | 1 | 28858 | 32 | ||
70663 | 233643 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 688x San Jose Ave | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005840.60494 | 2099248.22306 | 37.7444662393403 | -122.422476076803 | (37.7444662393403, -122.422476076803) | 2 | 7 | 5 | 28859 | 2 | |||
70714 | 9169 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6037 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/1998 12:00:00 AM | 9 | 3X3 | 5988226.75232 | 2112484.22581 | 37.7797993055455 | -122.484350989435 | (37.7797993055455, -122.484350989435) | 11 | 6 | 2 | 55 | 26 | ||
70946 | 17775 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1762 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005528.75649 | 2115532.22936 | 37.789160640286 | -122.424712580148 | (37.789160640286, -122.424712580148) | 13 | 9 | 1 | 28858 | 41 | |||
72106 | 19014 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3122 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X3 | 5999831.14019 | 2115437.85116 | 37.7885780630821 | -122.444418772124 | (37.7885780630821, -122.444418772124) | 13 | 6 | 1 | 29490 | 27 | |||
72108 | 18611 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 618 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992335.2804 | 2088560.1418 | 37.7143482906927 | -122.468396874173 | (37.7143482906927, -122.468396874173) | 9 | 8 | 6 | 64 | 24 | |||
72135 | 17908 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2300X Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 6 | 3x3 | 6002850.47701 | 2115161.07336 | 37.7879899117942 | -122.433952543247 | (37.7879899117942, -122.433952543247) | 13 | 9 | 1 | 29490 | 27 | ||
72286 | 17805 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1880 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004940.7125532 | 2115448.2610788 | 37.7888968551774 | -122.42674115801 | (37.7888968551774, -122.42674115801) | 13 | 9 | 1 | 28858 | 27 | |||
72332 | 90494 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 277 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988033.50539 | 2114129.24257 | 37.7843048014593 | -122.485140238595 | (37.7843048014593, -122.485140238595) | 11 | 6 | 2 | 55 | 26 | ||
72526 | 18605 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 533 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992541.0363 | 2088494.6252 | 37.7141802803508 | -122.467680944889 | (37.7141802803508, -122.467680944889) | 9 | 8 | 6 | 64 | 24 | |||
72597 | 9898 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1800X Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004962.1152 | 2115451.6483 | 37.7889073656732 | -122.42666734904 | (37.7889073656732, -122.42666734904) | 13 | 9 | 1 | 28858 | 27 | |||
72661 | 11198 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 186 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 5995344.6608195 | 2099448.7962231 | 37.7444192662253 | -122.458783177848 | (37.7444192662253, -122.458783177848) | 1 | 8 | 4 | 59 | 40 | |||
72967 | 90528 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 723 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988146.92998 | 2111009.42437 | 37.7757452666017 | -122.48451892149 | (37.7757452666017, -122.48451892149) | 11 | 6 | 2 | 55 | 26 | ||
73257 | 7962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1920X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005581.7012 | 2116251.27372 | 37.7911379463616 | -122.424580566901 | (37.7911379463616, -122.424580566901) | 13 | 9 | 1 | 28858 | 27 | |||
73931 | 3554 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201X Cargo Way | 64 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | 10 | 3 | 8 | 58 | 1 | ||
74108 | 107482 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 4 | Median : Cutout | Tree | DPW 1 | 5 | 6011457.97806 | 2119852.64786 | 37.8013565579188 | -122.404502345126 | (37.8013565579188, -122.404502345126) | 3 | 1 | 10 | 308 | 23 | ||||
74424 | 22518 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6518 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6012926.62983 | 2089906.00338 | 37.7192116295963 | -122.397318879858 | (37.7192116295963, -122.397318879858) | 10 | 3 | 8 | 58 | 1 | |||
74704 | 19000 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3042 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000225.47517 | 2115493.68766 | 37.7887538670327 | -122.443058448614 | (37.7887538670327, -122.443058448614) | 13 | 6 | 1 | 29490 | 27 | |||
74994 | 87736 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 8 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.28256 | 37.8051028305372 | -122.4252793245 | (37.8051028305372, -122.4252793245) | 5 | 1 | 1 | 28858 | 32 | ||
75981 | 90529 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 751 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988150.81366 | 2110890.11557 | 37.7754179041572 | -122.48449673401 | (37.7754179041572, -122.48449673401) | 11 | 6 | 2 | 55 | 26 | ||
76007 | 107485 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 7 | Median : Cutout | Tree | DPW 1 | 5 | 6011457.45538 | 2119866.47345 | 37.8013944904094 | -122.404505127604 | (37.8013944904094, -122.404505127604) | 3 | 1 | 10 | 308 | 23 | ||||
76145 | 87732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005468.85489 | 2121438.02655 | 37.8053730758726 | -122.425340270033 | (37.8053730758726, -122.425340270033) | 5 | 1 | 1 | 28858 | 32 | ||
76353 | 29699 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1488X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 6005882.22155 | 2100316.32182 | 37.747401343192 | -122.422408052104 | (37.747401343192, -122.422408052104) | 2 | 7 | 5 | 28859 | 22 | |||
77263 | 1426 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 65 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5X5PL | 5995463.35217 | 2115623.53261 | 37.7888377152353 | -122.459544008497 | (37.7888377152353, -122.459544008497) | 11 | 6 | 1 | 54 | 11 | |||
77548 | 18908 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2604 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002262.24167 | 2115774.64436 | 37.7896412209083 | -122.436031651553 | (37.7896412209083, -122.436031651553) | 13 | 6 | 1 | 29490 | 27 | |||
78899 | 96090 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3122 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/2011 12:00:00 AM | 3 | 3x3 | 5999797.96737 | 2115433.02091 | 37.7885629076984 | -122.444533197372 | (37.7885629076984, -122.444533197372) | 13 | 6 | 1 | 29490 | 27 | ||
79009 | 4449 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1365 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6004544.31428 | 2100922.31022 | 37.748989683529 | -122.427077601077 | (37.748989683529, -122.427077601077) | 2 | 4 | 5 | 28862 | 22 | |||
79533 | 17208 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221X Olive St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006417.7103 | 2113696.81595 | 37.7841712140925 | -122.421506501194 | (37.7841712140925, -122.421506501194) | 7 | 9 | 11 | 28858 | 41 | |||
79629 | 18615 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 701 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992139.1908 | 2088496.6198 | 37.7141625464129 | -122.469070010847 | (37.7141625464129, -122.469070010847) | 9 | 8 | 6 | 64 | 24 | |||
79993 | 85362 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/17/2007 12:00:00 AM | Permit Number 49639 | 6000155.2862 | 2108898.36192 | 37.7706407896873 | -122.442827504693 | (37.7706407896873, -122.442827504693) | 15 | 5 | 11 | 29492 | 9 | |||
80725 | 2005 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X Bosworth St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002728.1222807 | 2095276.2570246 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | 2 | 7 | 5 | 63 | 7 | |||
80773 | 17882 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2206 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003364.8746233 | 2115229.308121 | 37.7882064454668 | -122.432177695569 | (37.7882064454668, -122.432177695569) | 13 | 9 | 1 | 29490 | 27 | |||
80787 | 9029 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5351 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5990343.7121 | 2112622.3264 | 37.7803015307063 | -122.47703766733 | (37.7803015307063, -122.47703766733) | 11 | 6 | 2 | 55 | 26 | |||
82031 | 18819 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1850 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005893.34484 | 2116280.69836 | 37.7912363340264 | -122.423504381436 | (37.7912363340264, -122.423504381436) | 13 | 9 | 1 | 28858 | 27 | |||
82141 | 17901 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2280 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003007.0385991 | 2115179.5889757 | 37.7880496344978 | -122.433412192311 | (37.7880496344978, -122.433412192311) | 13 | 9 | 1 | 29490 | 27 | |||
82518 | 17771 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1743 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 3x3 | 6005575.36336 | 2115490.23781 | 37.7890479741354 | -122.424548337833 | (37.7890479741354, -122.424548337833) | 13 | 9 | 1 | 28858 | 41 | ||
83818 | 1454 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 151X ARGUELLO BLVD | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X5 | 5995497 | 2115135 | 37.7874982714485 | -122.459392198652 | (37.7874982714485, -122.459392198652) | 11 | 6 | 1 | 54 | 11 | |||
85077 | 29233 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902 41st Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
85332 | 117845 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620x 39th Ave | 2 | Median : Cutout | Tree | DPW 1 | 23 | Width 6ft | 5983812.70856 | 2111515.33399 | 37.7768809995382 | -122.499549240882 | (37.7768809995382, -122.499549240882) | 11 | 6 | 2 | 55 | 26 | |||
85695 | 13056 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 567 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/06/2016 07:33:00 AM | 3 | 3X3 | 6009638.2249 | 2120505.3867 | 37.8030469515764 | -122.410845650802 | (37.8030469515764, -122.410845650802) | 3 | 1 | 10 | 308 | 23 | ||
86266 | 90481 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 280 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5988088.38725 | 2114137.09953 | 37.7843295712232 | -122.484950945586 | (37.7843295712232, -122.484950945586) | 11 | 6 | 2 | 55 | 26 | ||
86834 | 13315 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3179X Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999602.75273 | 2115359.85021 | 37.7883508592612 | -122.445203345153 | (37.7883508592612, -122.445203345153) | 13 | 6 | 1 | 29490 | 27 | |||
87141 | 19036 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3238 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 5999312.47543 | 2115365.10303 | 37.7883487089688 | -122.44620803177 | (37.7883487089688, -122.44620803177) | 13 | 6 | 1 | 29490 | 31 | |||
87305 | 253547 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 15 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:40:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
87805 | 90485 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988074.61817 | 2114548.83987 | 37.7854592910469 | -122.485028799885 | (37.7854592910469, -122.485028799885) | 11 | 6 | 2 | 55 | 26 | ||
88570 | 17772 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1750 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2008 12:00:00 AM | 12 | 3X3 | 6005552.3182127 | 2115533.2399329 | 37.7891647457647 | -122.424631131353 | (37.7891647457647, -122.424631131353) | 13 | 9 | 1 | 28858 | 41 | ||
89322 | 11169 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2700 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006924.13035 | 2121583.86925 | 37.8058556331999 | -122.420314446577 | (37.8058556331999, -122.420314446577) | 5 | 1 | 1 | 28858 | 32 | |||
90336 | 131895 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3274 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 4ft | 5999203 | 2115426 | 37.7885096634197 | -122.446591180632 | (37.7885096634197, -122.446591180632) | 13 | 6 | 1 | 29490 | 31 | |||
90524 | 194167 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300x De Haro St | 14 | Median : Yard | Tree | DPW 1 | 1 | 6012274.04427 | 2102163.00717 | 37.7528304388731 | -122.400435122478 | (37.7528304388731, -122.400435122478) | 10 | 3 | 8 | 28856 | 29 | ||||
91171 | 17800 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1855 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6005059.342 | 2115410.1523 | 37.788798924353 | -122.426328001709 | (37.788798924353, -122.426328001709) | 13 | 9 | 11 | 28858 | 27 | |||
91239 | 19042 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3257 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 5999209.87226 | 2115305.32061 | 37.7881787020404 | -122.44655871793 | (37.7881787020404, -122.44655871793) | 13 | 6 | 1 | 29490 | 31 | |||
91879 | 18822 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1865 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005869.22375 | 2116234.13797 | 37.791107129344 | -122.423584528107 | (37.791107129344, -122.423584528107) | 13 | 9 | 1 | 28858 | 27 | |||
93472 | 13320 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 16 Mabrey Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/09/1992 12:00:00 AM | 6 | 3X3 | 6016446.48412 | 2095922.18028 | 37.7359262061134 | -122.385571020705 | (37.7359262061134, -122.385571020705) | 10 | 3 | 8 | 58 | 1 | ||
94285 | 1418 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 15 Arguello Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 5X5PL | 5995436.85306 | 2115829.92253 | 37.7894028822964 | -122.459650645871 | (37.7894028822964, -122.459650645871) | 11 | 6 | 1 | 54 | 11 | |||
94336 | 138592 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2816 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2016 11:02:00 AM | 5 | Width 0ft | 6000405.4059 | 2114823.5619 | 37.7869241331552 | -122.442387787113 | (37.7869241331552, -122.442387787113) | 13 | 6 | 1 | 29490 | 27 | ||
94780 | 18827 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1911 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005492.83778 | 2116179.1366 | 37.7909348570073 | -122.424882897351 | (37.7909348570073, -122.424882897351) | 13 | 9 | 1 | 28858 | 27 | |||
94977 | 9899 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1820 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005214 | 2115481 | 37.7890021953473 | -122.425797951343 | (37.7890021953473, -122.425797951343) | 13 | 9 | 1 | 28858 | 27 | |||
95263 | 4438 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1307 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004526.51906 | 2101259.5658 | 37.7499147028052 | -122.427163156254 | (37.7499147028052, -122.427163156254) | 2 | 4 | 5 | 28862 | 22 | |||
95328 | 17786 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1805 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2011 12:00:00 AM | 3 | 3x3 | 6005293.1999119 | 2115446.7566648 | 37.7889126469921 | -122.425521491833 | (37.7889126469921, -122.425521491833) | 13 | 9 | 11 | 28858 | 27 | ||
95334 | 26723 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1881 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/15/1999 12:00:00 AM | 3 | 3x3 | 6004971.2268 | 2115402.5662 | 37.7887731136568 | -122.426632327607 | (37.7887731136568, -122.426632327607) | 13 | 9 | 11 | 28858 | 27 | ||
96437 | 6921 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 425 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2010 12:00:00 AM | 3 | 3X3 | 6005385.421 | 2110602.3829 | 37.7756164008395 | -122.424857632506 | (37.7756164008395, -122.424857632506) | 7 | 9 | 11 | 28852 | 10 | ||
98064 | 11184 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2765 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006851.5978528 | 2121751.8788051 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | 5 | 1 | 1 | 28858 | 32 | |||
99285 | 29238 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
99607 | 30018 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 710X San Jose Ave | 11 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.422880130575 | (37.7437931149581, -122.422880130575) | 2 | 7 | 5 | 28859 | 22 | ||
99708 | 16775 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1901 O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 6 | 3X3 | 5999052.6011233 | 2112722.5070334 | 37.7810779855184 | -122.446916917115 | (37.7810779855184, -122.446916917115) | 15 | 5 | 1 | 54 | 16 | ||
100457 | 1984 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 106 Bertha Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/1997 12:00:00 AM | 3 | 3X4 | 6017854.9793307 | 2094779.8205714 | 37.732867343787 | -122.380621861717 | (37.732867343787, -122.380621861717) | 10 | 3 | 8 | 58 | 1 | ||
101385 | 210682 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100x Idora Ave | 6 | Median : Yard | Tree | DPW 1 | 15 | Width 9ft | 5995339.29404 | 2099412.44102 | 37.7443191354124 | -122.4587991034 | (37.7443191354124, -122.4587991034) | 1 | 8 | 4 | 59 | 40 | |||
102289 | 117836 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660x 39th Ave | 3 | Median : Cutout | Tree | DPW 1 | 11 | Width 6ft | 5983819.78589 | 2111279.0355 | 37.7762326075425 | -122.499507291354 | (37.7762326075425, -122.499507291354) | 11 | 6 | 2 | 55 | 26 | |||
102623 | 29705 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1488X Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 6005872.46136 | 2100440.52382 | 37.747741822942 | -122.422450626014 | (37.747741822942, -122.422450626014) | 2 | 7 | 5 | 28859 | 22 | |||
102723 | 11161 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2638 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6006954.2638733 | 2121382.2190943 | 37.8053036512983 | -122.420195844212 | (37.8053036512983, -122.420195844212) | 5 | 1 | 1 | 28858 | 32 | |||
102822 | 4379 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2425X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6007005.3355 | 2120662.99967 | 37.8033317353302 | -122.419968034 | (37.8033317353302, -122.419968034) | 5 | 1 | 1 | 28858 | 32 | |||
102842 | 233648 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1534x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005895.98726 | 2100078.89273 | 37.7467501935748 | -122.422343584206 | (37.7467501935748, -122.422343584206) | 2 | 7 | 5 | 28859 | 22 | |||
105261 | 2004 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X Bosworth St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002728.1222807 | 2095276.2570246 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | 2 | 7 | 5 | 63 | 7 | |||
107094 | 9725 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 621 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005796.9989 | 2111889.3567 | 37.779173356417 | -122.42352539952 | (37.779173356417, -122.42352539952) | 7 | 9 | 11 | 28852 | 41 | |||
107160 | 4443 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1337 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/1999 12:00:00 AM | 8 | 3X3 | 6004533.29635 | 2101118.56529 | 37.7495279313912 | -122.427129678106 | (37.7495279313912, -122.427129678106) | 2 | 4 | 5 | 28862 | 22 | ||
107369 | 3707 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/07/1996 12:00:00 AM | 3 | 3X3 | 6016577.53961 | 2099225.88923 | 37.7450047713688 | -122.385348049088 | (37.7450047713688, -122.385348049088) | 10 | 3 | 8 | 58 | 1 | ||
107380 | 17994 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2650X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/1998 12:00:00 AM | 3 | 3X3 | 6001258.2893795 | 2114937.1034436 | 37.7872844637831 | -122.439445153971 | (37.7872844637831, -122.439445153971) | 13 | 6 | 1 | 29490 | 27 | ||
108283 | 139530 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2105 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/13/2015 01:25:00 PM | 9 | Width 0ft | 6001148.4033 | 2113139.6515 | 37.7823428677529 | -122.439696423108 | (37.7823428677529, -122.439696423108) | 15 | 5 | 11 | 29490 | 41 | ||
108476 | 90454 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 834 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988228.72153 | 2110274.49617 | 37.7737321214751 | -122.48418207844 | (37.7737321214751, -122.48418207844) | 11 | 6 | 2 | 55 | 26 | ||
108517 | 1424 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 65 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5X5PL | 5995463.97403 | 2115644.21361 | 37.788894535419 | -122.459543355401 | (37.788894535419, -122.459543355401) | 11 | 6 | 1 | 54 | 11 | |||
108612 | 233647 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1534x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6005899.49267 | 2100009.81347 | 37.7465607153996 | -122.422326555528 | (37.7465607153996, -122.422326555528) | 2 | 7 | 5 | 28859 | 22 | |||
109403 | 17209 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221X Olive St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006417.7103 | 2113696.81595 | 37.7841712140925 | -122.421506501194 | (37.7841712140925, -122.421506501194) | 7 | 9 | 11 | 28858 | 41 |
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) );