trees
395 rows where qSpecies_id = 35 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
65461 | 185709 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2101 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984908.4893 | 2100423.9717 | 37.7464914545154 | -122.494940652646 | (37.7464914545154, -122.494940652646) | 1 | 8 | 3 | 29491 | 35 | |||
75002 | 185676 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2101 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984839.349 | 2100771.308 | 37.7474410976212 | -122.495205338122 | (37.7474410976212, -122.495205338122) | 1 | 8 | 3 | 29491 | 35 | |||
130934 | 185700 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2101 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984899.9898 | 2100515.832 | 37.7467431803198 | -122.494976814737 | (37.7467431803198, -122.494976814737) | 1 | 8 | 3 | 29491 | 35 | |||
23996 | 8576 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 48 | 6 | 6001010.5429 | 2113459.32 | 37.7832127479531 | -122.440196288881 | (37.7832127479531, -122.440196288881) | 15 | 5 | 11 | 29490 | 41 | |||
43150 | 8574 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 6 | 6001134.4053 | 2113480.979 | 37.7832792690603 | -122.439769329053 | (37.7832792690603, -122.439769329053) | 15 | 5 | 11 | 29490 | 41 | |||
65234 | 8577 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 36 | 6 | 6000958.4259 | 2113453.9053 | 37.7831949132778 | -122.440376203878 | (37.7831949132778, -122.440376203878) | 15 | 5 | 11 | 29490 | 41 | |||
66433 | 8563 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | |||
71757 | 8562 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | |||
101800 | 8581 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6000715.1007 | 2113420.9091 | 37.7830904567466 | -122.441215640748 | (37.7830904567466, -122.441215640748) | 15 | 5 | 1 | 29490 | 41 | |||
107231 | 8560 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | ||
113256 | 8561 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | ||
116060 | 8575 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 48 | 6 | 6001093.7947 | 2113474.2106 | 37.7832583731226 | -122.439909339764 | (37.7832583731226, -122.439909339764) | 15 | 5 | 11 | 29490 | 41 | |||
141624 | 8586 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 13 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6000400.7068 | 2113377.2527 | 37.7829526738098 | -122.442300177437 | (37.7829526738098, -122.442300177437) | 15 | 5 | 1 | 29490 | 41 | |||
170733 | 8578 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6000905.6321 | 2113444.4294 | 37.7831658887746 | -122.440558168856 | (37.7831658887746, -122.440558168856) | 15 | 5 | 11 | 29490 | 41 | |||
186033 | 8582 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6000649.7853 | 2113412.1102 | 37.7830625764785 | -122.441440973241 | (37.7830625764785, -122.441440973241) | 15 | 5 | 1 | 29490 | 41 | |||
7563 | 187388 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Sunset Blvd | 74 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985049.5619 | 2100144.9354 | 37.7457335539505 | -122.49443228067 | (37.7457335539505, -122.49443228067) | 1 | 8 | 3 | 29491 | 35 | |||
47104 | 187385 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Sunset Blvd | 71 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985037.3743 | 2100116.159 | 37.7456538284953 | -122.494472302074 | (37.7456538284953, -122.494472302074) | 1 | 8 | 3 | 29491 | 35 | |||
30409 | 185563 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2201 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984887.6667 | 2099768.5458 | 37.7446906142612 | -122.494964334306 | (37.7446906142612, -122.494964334306) | 1 | 8 | 3 | 29491 | 35 | |||
56939 | 185562 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2201 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984881.299 | 2099768.8111 | 37.7446909699364 | -122.494986371806 | (37.7446909699364, -122.494986371806) | 1 | 8 | 3 | 29491 | 35 | |||
68405 | 185535 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2201 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984921.0973 | 2100070.748 | 37.7455223363848 | -122.494871016971 | (37.7455223363848, -122.494871016971) | 1 | 8 | 3 | 29491 | 35 | |||
121416 | 185539 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2201 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984878.3804 | 2100042.8891 | 37.7454433428019 | -122.495016669314 | (37.7454433428019, -122.495016669314) | 1 | 8 | 3 | 29491 | 35 | |||
153599 | 185439 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2300 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985094.1378 | 2099479.3093 | 37.74390853381 | -122.494229093058 | (37.74390853381, -122.494229093058) | 1 | 8 | 3 | 29491 | 35 | |||
127400 | 187193 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2301 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984945.2043 | 2099085.395 | 37.7428182353231 | -122.494715027467 | (37.7428182353231, -122.494715027467) | 1 | 8 | 3 | 29491 | 35 | |||
22467 | 211031 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2375 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5992617.61467 | 2099318.2887 | 37.7439038024205 | -122.468203163863 | (37.7439038024205, -122.468203163863) | 1 | 8 | 4 | 29491 | 40 | |||
65 | 264979 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2450 California St | 1 | Front Yard : Yard | Tree | MTA 3 | 6002592 | 2115500 | 37.7889058459562 | -122.434871073784 | (37.7889058459562, -122.434871073784) | 13 | 9 | 1 | 29490 | 27 | |||||
4438 | 254757 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2450 California St | 13 | Front Yard : Yard | Tree | MTA 3 | 6002592 | 2115500 | 37.7889058459562 | -122.434871073784 | (37.7889058459562, -122.434871073784) | 13 | 9 | 1 | 29490 | 27 | |||||
141285 | 120542 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2450 California St | 1 | Front Yard : Yard | Tree | MTA 3 | DPW for City Agency | 6002644.10897 | 2115479.97736 | 37.7888538273233 | -122.434689351726 | (37.7888538273233, -122.434689351726) | 13 | 9 | 1 | 29490 | 27 | ||||
194127 | 122584 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2500X Lyon St | 4 | Median : Cutout | Tree | Private 2 | 11 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
41826 | 187121 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2600 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985174.7424 | 2097328.4139 | 37.7380074703554 | -122.493791914706 | (37.7380074703554, -122.493791914706) | 1 | 8 | 3 | 29491 | 35 | |||
97343 | 187133 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2600 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985163.4571 | 2097445.4987 | 37.7383282936023 | -122.493839558913 | (37.7383282936023, -122.493839558913) | 1 | 8 | 3 | 29491 | 35 | |||
102914 | 187129 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2600 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 0ft | 5985149.8207 | 2097410.2322 | 37.7382306634066 | -122.493884107972 | (37.7382306634066, -122.493884107972) | 1 | 8 | 3 | 29491 | 35 | |||
12887 | 185307 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2601 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984973.1253 | 2097316.8359 | 37.7379638824881 | -122.494488141215 | (37.7379638824881, -122.494488141215) | 1 | 8 | 3 | 29491 | 35 | |||
60102 | 185310 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2601 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984962.2385 | 2097256.121 | 37.7377965384833 | -122.494521307154 | (37.7377965384833, -122.494521307154) | 1 | 8 | 3 | 29491 | 35 | |||
143757 | 185290 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2601 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984983.8028 | 2097379.2257 | 37.738135813056 | -122.494455822202 | (37.738135813056, -122.494455822202) | 1 | 8 | 3 | 29491 | 35 | |||
158532 | 185308 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2601 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985001.1798 | 2097292.5499 | 37.7378988415191 | -122.494389354717 | (37.7378988415191, -122.494389354717) | 1 | 8 | 3 | 29491 | 35 | |||
49351 | 21431 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2692X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
168039 | 21429 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2692X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
54367 | 253555 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 27 Ceres St | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 6013919.66127 | 2093997.42296 | 37.7305010827376 | -122.394172607985 | (37.7305010827376, -122.394172607985) | 10 | 3 | 8 | 58 | 1 | ||||
11755 | 186875 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985206.2214 | 2096387.7822 | 37.7354265885186 | -122.493613787113 | (37.7354265885186, -122.493613787113) | 1 | 8 | 3 | 29491 | 35 | |||
55245 | 186890 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985200.262 | 2096503.3044 | 37.7357434330648 | -122.493642900348 | (37.7357434330648, -122.493642900348) | 1 | 8 | 3 | 29491 | 35 | |||
130337 | 186855 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985186.2801 | 2096278.9071 | 37.7351264799029 | -122.49367471051 | (37.7351264799029, -122.49367471051) | 1 | 8 | 3 | 29491 | 35 | |||
133423 | 186893 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985181.9251 | 2096557.8565 | 37.7358921458374 | -122.493710315825 | (37.7358921458374, -122.493710315825) | 1 | 8 | 3 | 29491 | 35 | |||
134727 | 186880 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5985201.1788 | 2096460.2128 | 37.7356251686507 | -122.49363655642 | (37.7356251686507, -122.49363655642) | 1 | 8 | 3 | 29491 | 35 | |||
173124 | 186878 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985170.4646 | 2096439.5838 | 37.7355667300556 | -122.493741225987 | (37.7355667300556, -122.493741225987) | 1 | 8 | 3 | 29491 | 35 | |||
191503 | 186889 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2700 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985183.3004 | 2096502.846 | 37.7357411821318 | -122.493701508581 | (37.7357411821318, -122.493701508581) | 1 | 8 | 3 | 29491 | 35 | |||
53240 | 185023 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2701 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985046.088 | 2096329.59 | 37.7352574390957 | -122.494163132435 | (37.7352574390957, -122.494163132435) | 1 | 8 | 3 | 29491 | 35 | |||
128912 | 184982 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2701 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984985.373 | 2096691.786 | 37.7362483795762 | -122.494399733702 | (37.7362483795762, -122.494399733702) | 1 | 8 | 3 | 29491 | 35 | |||
165017 | 185033 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2701 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985049.8565 | 2096299.4419 | 37.7351748809707 | -122.494147882197 | (37.7351748809707, -122.494147882197) | 1 | 8 | 3 | 29491 | 35 | |||
187095 | 21459 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2701X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | 5985119.0068215 | 2096832.7848434 | 37.7366433445438 | -122.493948101207 | (37.7366433445438, -122.493948101207) | 1 | 8 | 3 | 29491 | 35 | |||
40897 | 21491 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2792X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.7351618711636 | -122.49411119238 | (37.7351618711636, -122.49411119238) | 1 | 8 | 3 | 29491 | 35 | |||
87610 | 185118 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2850 35th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 0ft | 5985615.0479 | 2096000.8357 | 37.7343880441022 | -122.492171858431 | (37.7343880441022, -122.492171858431) | 1 | 8 | 3 | 29491 | 35 | |||
6708 | 256455 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2901 Sunset Blvd | 4 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
141879 | 211032 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 297 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5993259.54182 | 2099680.27875 | 37.7449347888095 | -122.466009845078 | (37.7449347888095, -122.466009845078) | 1 | 8 | 4 | 29491 | 40 | |||
116936 | 100068 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 303 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2012 12:00:00 AM | Permit Number 769006 | 5990392 | 2090762 | 37.720281613079 | -122.47527420247 | (37.720281613079, -122.47527420247) | 1 | 8 | 4 | 64 | 40 | |||
33716 | 178129 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 345 Tocoloma Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012554.38724 | 2086809.43241 | 37.7106883309719 | -122.398388432799 | (37.7106883309719, -122.398388432799) | 10 | 3 | 8 | 309 | 1 | |||
21134 | 87016 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 35 Whitfield Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.381653502791 | (37.7310090102049, -122.381653502791) | 10 | 3 | 8 | 58 | 1 | |||
109718 | 87015 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 35 Whitfield Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.381653502791 | (37.7310090102049, -122.381653502791) | 10 | 3 | 8 | 58 | 1 | |||
160963 | 87014 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 35 Whitfield Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.381653502791 | (37.7310090102049, -122.381653502791) | 10 | 3 | 8 | 58 | 1 | |||
147596 | 234475 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 378 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007368.44216 | 2096501.62636 | 37.7370107660349 | -122.416998547241 | (37.7370107660349, -122.416998547241) | 2 | 7 | 7 | 28859 | 2 | |||
189697 | 234478 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 398 Surrey St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 5ft | 6001098.40077 | 2096167.19905 | 37.7357378071451 | -122.43865288754 | (37.7357378071451, -122.43865288754) | 2 | 7 | 5 | 63 | 7 | |||
83492 | 116067 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 4150X CLEMENT ST | 5 | Front Yard : Yard | Tree | DPW 1 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777818 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | |
52814 | 211034 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 417 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5995115.07777 | 2100328.51022 | 37.7468215422 | -122.45964072765 | (37.7468215422, -122.45964072765) | 1 | 8 | 4 | 59 | 40 | |||
105094 | 96843 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 417 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995136 | 2100316.9 | 37.7467908665237 | -122.459567540316 | (37.7467908665237, -122.459567540316) | 1 | 8 | 4 | 59 | 40 | |||||
122904 | 96844 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 417 Dewey Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995136 | 2100316.9 | 37.7467908665237 | -122.459567540316 | (37.7467908665237, -122.459567540316) | 1 | 8 | 4 | 59 | 40 | |||||
168170 | 211033 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 417 Dewey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5995123.84893 | 2100332.44688 | 37.7468328556504 | -122.459610683101 | (37.7468328556504, -122.459610683101) | 1 | 8 | 4 | 59 | 40 | |||
99863 | 114934 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 4400x OCEAN AVE | 10 | Front Yard : Cutout | Tree | Private 2 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | |
113218 | 114925 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 4400x OCEAN AVE | 3 | Front Yard : Cutout | Tree | Private 2 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | |
63272 | 4532 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6005027.0371 | 2113673.2533 | 37.784028006638 | -122.42631605912 | (37.784028006638, -122.42631605912) | 7 | 9 | 11 | 28858 | 41 | |
127704 | 4530 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6004963.1338 | 2113665.364 | 37.7840027322121 | -122.426536579485 | (37.7840027322121, -122.426536579485) | 7 | 9 | 11 | 28858 | 41 | |
137065 | 4531 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6004996.2689 | 2113667.7308 | 37.7840111039908 | -122.426422112629 | (37.7840111039908, -122.426422112629) | 7 | 9 | 11 | 28858 | 41 | |
97385 | 112912 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 480X BEACON ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 30 | 6002571 | 2098077 | 37.7410653426557 | -122.433697996676 | (37.7410653426557, -122.433697996676) | 2 | 7 | 5 | 63 | 7 | ||||
19548 | 234472 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 4810 17th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 2ft | 5998175.60392 | 2105685.14055 | 37.7617050378737 | -122.449443663887 | (37.7617050378737, -122.449443663887) | 15 | 5 | 11 | 29492 | 9 | |||
71549 | 234477 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Grand View Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 5999979.48342 | 2101750.0189 | 37.7510031819599 | -122.442922193204 | (37.7510031819599, -122.442922193204) | 2 | 4 | 5 | 28862 | 22 | ||||
10548 | 211015 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 78 | : | Tree | Private 2 | 3 | Width 0ft | 5991307.93934 | 2093199.2311 | 37.7270266932138 | -122.472285706431 | (37.7270266932138, -122.472285706431) | 9 | 8 | 4 | 64 | 40 | |||
20336 | 211013 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 44 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5991332.59313 | 2093509.69784 | 37.727880584217 | -122.472223101034 | (37.727880584217, -122.472223101034) | 9 | 8 | 4 | 64 | 40 | |||
34002 | 211012 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 35 | : | Tree | Private 2 | 3 | Width 0ft | 5991334.38006 | 2093575.3838 | 37.7280610448729 | -122.472221709761 | (37.7280610448729, -122.472221709761) | 9 | 8 | 4 | 64 | 40 | |||
67535 | 211010 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 27 | : | Tree | Private 2 | 3 | Width 0ft | 5991339.10103 | 2093646.61822 | 37.7282569100089 | -122.472210579766 | (37.7282569100089, -122.472210579766) | 9 | 8 | 4 | 64 | 40 | |||
106955 | 211009 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 25 | : | Tree | Private 2 | 4 | Width 0ft | 5991341.55983 | 2093667.80622 | 37.728315229259 | -122.472203623507 | (37.728315229259, -122.472203623507) | 9 | 8 | 4 | 64 | 40 | |||
160689 | 211014 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 53 | : | Tree | Private 2 | 3 | Width 0ft | 5991322.30761 | 2093384.47859 | 37.7275361681597 | -122.4722495339 | (37.7275361681597, -122.4722495339) | 9 | 8 | 4 | 64 | 40 | |||
191418 | 211011 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500 Junipero Serra Blvd | 34 | : | Tree | Private 2 | 3 | Width 0ft | 5991335.35345 | 2093583.37833 | 37.7280830521881 | -122.472218927265 | (37.7280830521881, -122.472218927265) | 9 | 8 | 4 | 64 | 40 | |||
6586 | 258122 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 4 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:11:00 PM | 3 | 5x5 | ||||||||||||
6935 | 258120 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 2 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:06:00 PM | 3 | 5x5 | ||||||||||||
13326 | 258119 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 1 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:14:00 PM | 3 | 5x5 | ||||||||||||
14131 | 258121 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 3 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:09:00 PM | 3 | 5x5 | ||||||||||||
86234 | 173745 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
186953 | 173744 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
193081 | 173746 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
3808 | 20305 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 50X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
13843 | 20301 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 50X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
20168 | 211040 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 52 Burnside Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6001161.45161 | 2095717.92279 | 37.7345077855016 | -122.438402718629 | (37.7345077855016, -122.438402718629) | 9 | 7 | 5 | 63 | 7 | ||||
36557 | 211039 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 52 Burnside Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6001157.31367 | 2095726.26325 | 37.7345304511011 | -122.438417622186 | (37.7345304511011, -122.438417622186) | 9 | 7 | 5 | 63 | 7 | ||||
161876 | 211038 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 52 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 6001171.81546 | 2095754.02956 | 37.7346075158123 | -122.438369473392 | (37.7346075158123, -122.438369473392) | 2 | 7 | 5 | 63 | 7 | ||||
96483 | 4970 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5200X Diamond Heights Blvd | 6 | Median : Cutout | Tree | DPW 1 | 01/09/2018 12:00:00 AM | 3 | 12 | 6000842.33366 | 2099520.2529 | 37.7449299333661 | -122.439778532074 | (37.7449299333661, -122.439778532074) | 2 | 7 | 5 | 63 | 7 | ||
194257 | 4968 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5200X Diamond Heights Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12/03/2018 12:00:00 AM | 3 | 12 | 6000815.91312 | 2099549.13893 | 37.7450077436274 | -122.439871959934 | (37.7450077436274, -122.439871959934) | 2 | 7 | 5 | 63 | 7 | ||
194284 | 4966 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5200X Diamond Heights Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12/03/2018 12:00:00 AM | 3 | 12 | 6000791.48606 | 2099581.9209 | 37.7450963646197 | -122.439958774198 | (37.7450963646197, -122.439958774198) | 2 | 7 | 5 | 63 | 7 | ||
68490 | 243115 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 18 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001841.69539 | 2098643.31719 | 37.7425789076843 | -122.436260181872 | (37.7425789076843, -122.436260181872) | 2 | 7 | 5 | 63 | 7 | |||
87630 | 243112 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 15 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001806.81928 | 2098684.11193 | 37.7426889388393 | -122.436383692077 | (37.7426889388393, -122.436383692077) | 2 | 7 | 5 | 63 | 7 | |||
113834 | 243114 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 17 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001830.21459 | 2098656.61242 | 37.7426147609522 | -122.436300830338 | (37.7426147609522, -122.436300830338) | 2 | 7 | 5 | 63 | 7 | |||
115061 | 243111 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 13 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001795.3662 | 2098698.75734 | 37.7427285009166 | -122.436424341429 | (37.7427285009166, -122.436424341429) | 2 | 7 | 5 | 63 | 7 | |||
127523 | 243106 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 9 | Median : Yard | Tree | DPW 1 | 01/09/2018 12:00:00 AM | 3 | 6001667.33897 | 2098826.57882 | 37.7430721930381 | -122.436876170699 | (37.7430721930381, -122.436876170699) | 2 | 7 | 5 | 63 | 7 |
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) );