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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
136 | 11131 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2400X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007074.9072505 | 2120528.613771 | 37.802966665104 | -122.419717737051 | (37.802966665104, -122.419717737051) | 5 | 1 | 1 | 28858 | 32 | |||
304 | 132028 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 33x Battery St | 1 | Median : Yard | Tree | DPW 1 | 27 | 6012842.61776 | 2116100.99756 | 37.7911327033699 | -122.399447311639 | (37.7911327033699, -122.399447311639) | 4 | 1 | 10 | 28854 | 6 | ||||
975 | 4380 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2421X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007006.0129161 | 2120659.6131485 | 37.8033224749672 | -122.419965449311 | (37.8033224749672, -122.419965449311) | 5 | 1 | 1 | 28858 | 32 | |||
1088 | 20259 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2015 07:41:00 AM | 3 | 3X3 | 6009947.7744 | 2120592.07204 | 37.8033023200197 | -122.40978056566 | (37.8033023200197, -122.40978056566) | 3 | 1 | 10 | 308 | 23 | ||
1842 | 11178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.8062914977061 | -122.420560679149 | (37.8062914977061, -122.420560679149) | 5 | 1 | 1 | 28858 | 32 | |||
1896 | 17856 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2121 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2000 12:00:00 AM | 10 | 3X3 | 6003596.6138 | 2115206.3541 | 37.7881565558045 | -122.431374278321 | (37.7881565558045, -122.431374278321) | 13 | 9 | 11 | 29490 | 27 | ||
2096 | 3697 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016390.48971 | 2099364.75407 | 37.7453757156112 | -122.3860045182 | (37.7453757156112, -122.3860045182) | 10 | 3 | 8 | 58 | 1 | |||
2291 | 29222 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 5 | 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 | |||
2707 | 19008 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3080X Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000062.56676 | 2115470.42095 | 37.7886806928938 | -122.443620414474 | (37.7886806928938, -122.443620414474) | 13 | 6 | 1 | 29490 | 27 | |||
3058 | 11168 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6006944.2763295 | 2121452.6056321 | 37.8054963520093 | -122.420235406119 | (37.8054963520093, -122.420235406119) | 5 | 1 | 1 | 28858 | 32 | |||
3750 | 90460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 786 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988216.47669 | 2110650.29112 | 37.7747632366882 | -122.484252000581 | (37.7747632366882, -122.484252000581) | 11 | 6 | 2 | 55 | 26 | |||
4117 | 17881 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2205 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003346.6048 | 2115178.7939 | 37.7880667103656 | -122.432237297056 | (37.7880667103656, -122.432237297056) | 13 | 9 | 11 | 29490 | 27 | |||
4304 | 17630 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 150 Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10M | |||||||||||||
7307 | 17780 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1791 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005376.6767315 | 2115458.3552628 | 37.7889492101001 | -122.425233498798 | (37.7889492101001, -122.425233498798) | 13 | 9 | 1 | 28858 | 41 | |||
7457 | 2165 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 119X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/1997 12:00:00 AM | 12 | 3X27 | 5993658.6263 | 2088481.9826 | 37.7142100327703 | -122.463817234952 | (37.7142100327703, -122.463817234952) | 9 | 8 | 6 | 64 | 24 | ||
10555 | 18999 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3039 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6000252.38525 | 2115449.79519 | 37.7886348840283 | -122.442962190565 | (37.7886348840283, -122.442962190565) | 13 | 6 | 1 | 29490 | 27 | |||
10896 | 13070 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 630 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/05/2019 12:00:00 AM | 22 | 3x3 | 6009332.6794 | 2120506.3975 | 37.8030325899081 | -122.4119030734 | (37.8030325899081, -122.4119030734) | 3 | 1 | 10 | 308 | 23 | ||
10929 | 233639 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 738x San Jose Ave | 1 | Median : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6005705.79778 | 2098817.87018 | 37.7432769821506 | -122.422911632871 | (37.7432769821506, -122.422911632871) | 2 | 7 | 7 | 28859 | 2 | |||
11761 | 10268 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215X Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 6005053.18335 | 2109512.97249 | 37.7726063733294 | -122.425929359246 | (37.7726063733294, -122.425929359246) | 7 | 9 | 5 | 28852 | 10 | ||||
12888 | 260885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 639 32nd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985963.68769 | 2111543.65127 | 37.7770847226637 | -122.49211054124 | (37.7770847226637, -122.49211054124) | 11 | 6 | 2 | 55 | 26 | |||
14067 | 17211 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221X Olive St | 7 | 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 | |||
15423 | 85309 | - 12 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/26/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.7706407896873 | -122.442827504693 | (37.7706407896873, -122.442827504693) | 15 | 5 | 11 | 29492 | 9 |
15594 | 19769 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
17282 | 18916 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2621 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 6x5 | 6002236.03231 | 2115724.70658 | 37.7895026155894 | -122.4361187581 | (37.7895026155894, -122.4361187581) | 13 | 6 | 1 | 29490 | 27 | |||
17854 | 821 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1409 45th Ave | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 04/02/2015 05:34:00 PM | 3 | 3X3 | 5982132.645 | 2105492.3927 | 37.7602450246853 | -122.504914569939 | (37.7602450246853, -122.504914569939) | 1 | 8 | 3 | 56 | 35 | ||
17923 | 19768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
18384 | 233645 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1594x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005912.55723 | 2099806.72525 | 37.7460038183146 | -122.422266952984 | (37.7460038183146, -122.422266952984) | 2 | 7 | 5 | 28859 | 22 | |||
18560 | 19875 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY33 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
19260 | 13019 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 426 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 01:54:00 PM | 3 | 4X4 | 6010271 | 2120661 | 37.8035096874313 | -122.408666892744 | (37.8035096874313, -122.408666892744) | 3 | 1 | 10 | 308 | 23 | ||
22301 | 17791 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1830 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005168.1437793 | 2115479.8612246 | 37.7889964771069 | -122.425956526841 | (37.7889964771069, -122.425956526841) | 13 | 9 | 1 | 28858 | 27 | |||
23411 | 90534 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 787 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988159.9976 | 2110642.6837 | 37.774739060163 | -122.484446812828 | (37.774739060163, -122.484446812828) | 11 | 6 | 2 | 55 | 26 | ||
23491 | 17204 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Olive St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006498.35844 | 2113758.48472 | 37.7843450883742 | -122.421231867498 | (37.7843450883742, -122.421231867498) | 7 | 9 | 11 | 28858 | 41 | |||
23929 | 17971 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2515 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001715.6676 | 2114951.5677 | 37.7873501979521 | -122.437863761621 | (37.7873501979521, -122.437863761621) | 13 | 6 | 11 | 29490 | 27 | |||
24290 | 17903 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2291 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002984.8186377 | 2115126.0213176 | 37.787901290694 | -122.4334852398 | (37.787901290694, -122.4334852398) | 13 | 9 | 11 | 29490 | 27 | |||
26249 | 4426 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1151 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004471.6609206 | 2102195.0524139 | 37.7524802287033 | -122.427419493034 | (37.7524802287033, -122.427419493034) | 2 | 4 | 5 | 28862 | 22 | |||
28110 | 19037 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3235 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999309.28069 | 2115314.23141 | 37.7882088463949 | -122.446215424205 | (37.7882088463949, -122.446215424205) | 13 | 6 | 1 | 29490 | 31 | |||
28485 | 2006 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X Bosworth St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002728.1222807 | 2095276.2570246 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | 2 | 7 | 5 | 63 | 7 | |||
28766 | 17972 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2515 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001748.1253 | 2114954.2725 | 37.7873594702652 | -122.437751658759 | (37.7873594702652, -122.437751658759) | 13 | 6 | 11 | 29490 | 27 | |||
29280 | 233640 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 738x San Jose Ave | 2 | Median : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6005718.0637 | 2098849.84637 | 37.7433654736312 | -122.422871492542 | (37.7433654736312, -122.422871492542) | 2 | 7 | 7 | 28859 | 2 | |||
29341 | 107488 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 13 | Median : Cutout | Tree | DPW 1 | 6 | 6011453.59321 | 2119920.31769 | 37.8015421177278 | -122.404522284896 | (37.8015421177278, -122.404522284896) | 3 | 1 | 10 | 308 | 23 | ||||
29413 | 90507 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 501X 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988092.93528 | 2112495.34178 | 37.7798220340381 | -122.484814731334 | (37.7798220340381, -122.484814731334) | 11 | 6 | 2 | 55 | 26 | ||
30111 | 17958 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2500 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 6 | 3x3 | 6001912.0842 | 2115029.0126 | 37.7875740088989 | -122.437189749529 | (37.7875740088989, -122.437189749529) | 13 | 6 | 1 | 29490 | 27 | ||
30830 | 253551 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 19 | Back Yard : Yard | Tree | DPW 1 | 09/22/2017 04:40:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
31362 | 17212 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 231 Olive St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6006210.05924 | 2113680.59084 | 37.7841149534825 | -122.42222374774 | (37.7841149534825, -122.42222374774) | 7 | 9 | 11 | 28858 | 41 | |||
32112 | 29983 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1622X Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005924.09258 | 2099580.54718 | 37.7453834354083 | -122.42221099896 | (37.7453834354083, -122.42221099896) | 2 | 7 | 5 | 28859 | 2 | ||
32116 | 3557 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 2 | 3X3 | 6018758.22153 | 2097553.75967 | 37.7405338394733 | -122.377691534151 | (37.7405338394733, -122.377691534151) | 10 | 3 | 8 | 58 | 1 | ||
32179 | 87737 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 9 | 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 | ||
32484 | 13316 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3221X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999405.93635 | 2115329.62799 | 37.7882566408208 | -122.445882120937 | (37.7882566408208, -122.445882120937) | 13 | 6 | 1 | 29490 | 31 | |||
32861 | 11174 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2721 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006871.9159428 | 2121607.3582758 | 37.8059171856884 | -122.420496811264 | (37.8059171856884, -122.420496811264) | 5 | 1 | 1 | 28858 | 32 | |||
33259 | 7944 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1715X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005719.3289 | 2115506.1033 | 37.7890996659994 | -122.424051363883 | (37.7890996659994, -122.424051363883) | 13 | 9 | 1 | 28858 | 41 | |||
33269 | 8686 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2925 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2011 12:00:00 AM | 3 | 3x3 | 5998077.56074 | 2113059.77812 | 37.781948291597 | -122.450314371978 | (37.781948291597, -122.450314371978) | 15 | 6 | 2 | 54 | 16 | ||
33315 | 132044 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 444 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2002 12:00:00 AM | 7 | Width 4ft | 6012372.27446 | 2117831.7295 | 37.795858655114 | -122.401196364438 | (37.795858655114, -122.401196364438) | 3 | 1 | 10 | 28860 | 4 | ||
34733 | 90482 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 250X 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988084.85783 | 2114257.67071 | 37.784660419831 | -122.484972004771 | (37.784660419831, -122.484972004771) | 11 | 6 | 2 | 55 | 26 | ||
34785 | 22523 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6600 03rd St | 3 | Median : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012847.5284056 | 2089784.7633559 | 37.7188743244909 | -122.397583806576 | (37.7188743244909, -122.397583806576) | 10 | 3 | 8 | 58 | 1 | |||
34833 | 11155 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2615 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6006917.28019 | 2121296.80497 | 37.805067041968 | -122.420317765078 | (37.805067041968, -122.420317765078) | 5 | 1 | 1 | 28858 | 32 | |||
35127 | 115231 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 326 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Permit Number 775467 | 5986882.9 | 2113733.3 | 37.7831505651894 | -122.489091757795 | (37.7831505651894, -122.489091757795) | 11 | 6 | 2 | 55 | 26 | ||
35511 | 820 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1407 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2015 05:29:00 PM | 3 | 3X3 | 5982131.0395 | 2105513.2639 | 37.760302236597 | -122.504921669151 | (37.760302236597, -122.504921669151) | 1 | 8 | 3 | 56 | 35 | ||
35849 | 17969 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2517 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001910.2004467 | 2114976.8035786 | 37.7874305492324 | -122.437192527339 | (37.7874305492324, -122.437192527339) | 13 | 6 | 11 | 29490 | 27 | |||
36419 | 89415 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2100X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 11:25:00 AM | 3 | 3x3 | 5992153.7416 | 2112063.95125 | 37.7788732250553 | -122.470735311921 | (37.7788732250553, -122.470735311921) | 11 | 6 | 2 | 54 | 11 | ||
36989 | 9731 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 641 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 4x4 | 6005777.9079 | 2111995.4394 | 37.7794635560295 | -122.423598987459 | (37.7794635560295, -122.423598987459) | 7 | 9 | 11 | 28852 | 41 | |||
37560 | 1759 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2606X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006953 | 2121208 | 37.8048252188779 | -122.42018784574 | (37.8048252188779, -122.42018784574) | 5 | 1 | 1 | 28858 | 32 | |||
37851 | 7706 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2500X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007008.1963938 | 2121001.9906569 | 37.8042626795816 | -122.41998220419 | (37.8042626795816, -122.41998220419) | 5 | 1 | 1 | 28858 | 32 | |||
38678 | 90451 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 846 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988230.45181 | 2110199.51736 | 37.773526351285 | -122.484170593478 | (37.773526351285, -122.484170593478) | 11 | 6 | 2 | 55 | 26 | ||
38691 | 9732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 645 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/14/2011 12:00:00 AM | 3 | 4x4 | 6005775.5462 | 2112013.5463 | 37.7795131398465 | -122.423608445305 | (37.7795131398465, -122.423608445305) | 7 | 9 | 11 | 28852 | 41 | ||
38723 | 17885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2214 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003222.3202 | 2115211.247 | 37.7881487707297 | -122.432669618765 | (37.7881487707297, -122.432669618765) | 13 | 9 | 1 | 29490 | 27 | |||
39137 | 11183 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2765 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/1997 12:00:00 AM | 12 | 3X3 | 6006851.5978528 | 2121751.8788051 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | 5 | 1 | 1 | 28858 | 32 | ||
39623 | 29702 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1488X Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 6005878.4786 | 2100373.84581 | 37.747559079795 | -122.422425081661 | (37.747559079795, -122.422425081661) | 2 | 7 | 5 | 28859 | 22 | |||
41734 | 90530 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 755 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988153.04699 | 2110819.01092 | 37.7752228007136 | -122.484483791995 | (37.7752228007136, -122.484483791995) | 11 | 6 | 2 | 55 | 26 | ||
42546 | 90492 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 251 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988029.12909 | 2114293.50114 | 37.7847555538454 | -122.485167435068 | (37.7847555538454, -122.485167435068) | 11 | 6 | 2 | 55 | 26 | ||
42974 | 30019 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 710X San Jose Ave | 10 | 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 | ||
43139 | 15961 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5873 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2015 12:00:00 AM | 3 | 3X3 | 5997080.5771 | 2086512.68949 | 37.7089994077614 | -122.451847724407 | (37.7089994077614, -122.451847724407) | 9 | 7 | 6 | 28861 | 5 | ||
44397 | 17206 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221X Olive St | 2 | 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 | |||
46156 | 11134 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2454 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007041.13953 | 2120754.1462 | 37.8035840176492 | -122.419850604133 | (37.8035840176492, -122.419850604133) | 5 | 1 | 1 | 28858 | 32 | |||
46570 | 18893 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2515 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/22/1998 12:00:00 AM | 5 | 3X3 | 6002606.59443 | 2115769.77975 | 37.7896474207301 | -122.434839879589 | (37.7896474207301, -122.434839879589) | 13 | 9 | 1 | 29490 | 27 | ||
47040 | 90452 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 842 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5988230.28796 | 2110223.10552 | 37.7735911082647 | -122.48417289045 | (37.7735911082647, -122.48417289045) | 11 | 6 | 2 | 55 | 26 | ||
47919 | 18816 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1805X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006086.69341 | 2116261.34321 | 37.7911941008575 | -122.422834023652 | (37.7911941008575, -122.422834023652) | 13 | 9 | 1 | 28858 | 27 | |||
48372 | 9726 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 621 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005799.3606 | 2111864.1645 | 37.7791043180853 | -122.423515437911 | (37.7791043180853, -122.423515437911) | 7 | 9 | 11 | 28852 | 41 | |||
48597 | 13314 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3179X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999566.13783 | 2115354.51206 | 37.7883341120707 | -122.445329642351 | (37.7883341120707, -122.445329642351) | 13 | 6 | 1 | 29490 | 27 | |||
48642 | 18831 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2001 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005118.68211 | 2116122.72446 | 37.79075882281 | -122.426173443361 | (37.79075882281, -122.426173443361) | 13 | 9 | 1 | 28858 | 27 | |||
49716 | 15707 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4298 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2012 12:00:00 AM | 3 | 3x3 | 6003201.3472 | 2093656.06091 | 37.7289621988267 | -122.431203002635 | (37.7289621988267, -122.431203002635) | 9 | 7 | 6 | 28861 | 25 | ||
50093 | 12726 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1545 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1997 12:00:00 AM | 8 | 3X3 | 5990597.92823 | 2114719.13629 | 37.7860735319683 | -122.476311431561 | (37.7860735319683, -122.476311431561) | 11 | 6 | 2 | 54 | 26 | ||
50845 | 233642 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 688x San Jose Ave | 4 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005819.20445 | 2099183.8335 | 37.7442882329252 | -122.422545500883 | (37.7442882329252, -122.422545500883) | 2 | 7 | 5 | 28859 | 2 | |||
50895 | 17761 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1700 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005743.27618 | 2115564.26286 | 37.789260709663 | -122.42397264672 | (37.789260709663, -122.42397264672) | 13 | 9 | 1 | 28858 | 41 | |||
51618 | 1962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 36 Bertha Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017618.4307655 | 2095033.1830576 | 37.7335499703731 | -122.381457291596 | (37.7335499703731, -122.381457291596) | 10 | 3 | 8 | 58 | 1 | ||
52067 | 1453 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 151X ARGUELLO BLVD | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X5 | 5995497 | 2115135 | 37.7874982714485 | -122.459392198652 | (37.7874982714485, -122.459392198652) | 11 | 6 | 1 | 54 | 11 | |||
54945 | 11135 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2454 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007038.94291 | 2120769.93446 | 37.8036272444521 | -122.419859326652 | (37.8036272444521, -122.419859326652) | 5 | 1 | 1 | 28858 | 32 | |||
55442 | 17213 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 231 Olive St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6006226.51389 | 2113682.47873 | 37.7841210652808 | -122.422166954647 | (37.7841210652808, -122.422166954647) | 7 | 9 | 11 | 28858 | 41 | |||
55635 | 233644 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1594x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6005913.28607 | 2099739.4537 | 37.7458191470481 | -122.422259654081 | (37.7458191470481, -122.422259654081) | 2 | 7 | 5 | 28859 | 22 | |||
55741 | 104461 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1601X Kansas St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011834.44242 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | 10 | 3 | 8 | 58 | 1 | |||
55894 | 253546 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 14 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:50:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
55905 | 17902 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2291 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002984.8186377 | 2115126.0213176 | 37.787901290694 | -122.4334852398 | (37.787901290694, -122.4334852398) | 13 | 9 | 11 | 29490 | 27 | |||
56235 | 253550 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 18 | Back Yard : Yard | Tree | DPW 1 | 09/27/2017 11:43:00 AM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
56422 | 6236 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1250 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 12 | 3X3 | 6004877.1927 | 2113359.8717 | 37.78315906739 | -122.426812141195 | (37.78315906739, -122.426812141195) | 7 | 9 | 11 | 28858 | 41 | ||
56733 | 9128 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5840 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5988869.9475 | 2112669.6418 | 37.7803458369415 | -122.482139508426 | (37.7803458369415, -122.482139508426) | 11 | 6 | 2 | 55 | 26 | |||
56800 | 15929 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5763 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5997783.78018 | 2086793.93661 | 37.7098118993789 | -122.44943761417 | (37.7098118993789, -122.44943761417) | 9 | 7 | 6 | 28861 | 5 | ||
57847 | 18814 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1921 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005353.87348 | 2116157.54466 | 37.7908677208195 | -122.425362171235 | (37.7908677208195, -122.425362171235) | 13 | 9 | 1 | 28858 | 27 | |||
58459 | 18998 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3009 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/01/2011 12:00:00 AM | 3 | 3x3 | 6000320.39642 | 2115456.92187 | 37.7886583293724 | -122.442727394678 | (37.7886583293724, -122.442727394678) | 13 | 6 | 1 | 29490 | 27 | ||
58983 | 253548 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1000 Cayuga Ave | 16 | Back Yard : Yard | Tree | DPW 1 | 09/22/2017 04:31:00 PM | 3 | 3x3 | 6000652.97917 | 2091201.14277 | 37.7220768117153 | -122.439836937152 | (37.7220768117153, -122.439836937152) | 9 | 7 | 6 | 28861 | 25 | ||
59839 | 12445 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2001X Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 9 | 3X3 | 6004358.0388014 | 2115316.8218262 | 37.788502995764 | -122.428747755973 | (37.788502995764, -122.428747755973) | 13 | 9 | 11 | 29490 | 27 | ||
60326 | 13084 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 11:03:00 AM | 3 | 3X3 | 6009204.3394 | 2120486.8898 | 37.8029718256171 | -122.412345818777 | (37.8029718256171, -122.412345818777) | 3 | 1 | 10 | 308 | 23 |
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) );