trees

155 rows where qSpecies_id = 109

✎ View and edit SQL

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)
471 205972 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 400x Marietta Dr 49 Median : Cutout Tree DPW 1     2 Width 3ft   5998976.04571 2096922.6715 37.7376911903888 -122.446044988292 (37.7376911903888, -122.446044988292) 9 7 4 59 40
1654 19584 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY4 7 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
1935 19720 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY13 18 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
3100 19586 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY4 9 Sidewalk: Curb side : Cutout Tree DPW 1     3 60                      
3296 19833 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY25 17 Sidewalk: Curb side : Cutout Tree DPW 1     18 60X                      
5014 125944 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 Alice B Toklas Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006919.44761 2114149.75866 37.7854431613244 -122.419802815953 (37.7854431613244, -122.419802815953) 13 9 9 28858 36
5414 261208 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1131 Sutter St 1 Front Yard : Cutout Tree Private 2       3x3   6007175 2115019 37.7878442781586 -122.418980353142 (37.7878442781586, -122.418980353142) 13 9 10 28858 21
5828 19721 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY13 19 Sidewalk: Curb side : Cutout Tree DPW 1     3 40ST                      
5903 19583 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY4 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 60                      
6107 19832 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY25 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 60X                      
6682 222764 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 191 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6000158.84379 2105641.525 37.76169853039 -122.442581324981 (37.76169853039, -122.442581324981) 15 5 5 28862 3
8596 19826 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY25 10 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
8827 19825 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 STAIRWAY25 9 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
13663 258677 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 607 Congo St 1 Sidewalk: Property side : Yard Tree Private 2       10x10   6000094 2095817 37.7347190533418 -122.442100351643 (37.7347190533418, -122.442100351643) 9 7 4 63 40
14318 222761 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 3995 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6003074.11018 2104735.69559 37.7593770879038 -122.43243390112 (37.7593770879038, -122.43243390112) 2 4 5 28862 3
16617 205970 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 Bella Vista Way 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 3ft   5998533.62176 2097061.44244 37.7380469478033 -122.447584640212 (37.7380469478033, -122.447584640212) 9 7 4 59 40
17652 187553 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 3960 Somerset St 1 Side Yard : Yard Tree Private 2     16     6011370.89706 2088323.01324 37.7147783208511 -122.402585230642 (37.7147783208511, -122.402585230642) 10 7 8 309 39
17811 185472 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2400 Sunset Blvd 24 unknown : Yard Tree Private 2     1 Width 0ft   5985147.6347 2098429.3943 37.7410288809669 -122.493966755049 (37.7410288809669, -122.493966755049) 1 8 3 29491 35
20813 248179 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 218 Esmeralda Ave 8 Side Yard : Yard Tree Private 2     23     6007450.1378 2098674.92433 37.7429827563392 -122.416870017934 (37.7429827563392, -122.416870017934) 2 7 7 28859 2
22418 100843 Undocumented 4 Cedrus deodara :: Deodar Cedar 109 1 Estero Ave 1 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
23612 253210 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 567 Mississippi St 1 Sidewalk: Property side : Yard Tree Private 2   05/02/2019 12:00:00 AM 3 3x3   6014163 2104519 37.7594046471392 -122.394067636073 (37.7594046471392, -122.394067636073) 10 3 8 28856 29
25772 188433 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1 Jack Balestreri Way 8 Front Yard : Yard Tree Private 2     22     6012415.19625 2104737.50493 37.7599073164779 -122.400127781893 (37.7599073164779, -122.400127781893) 10 3 8 28856 29
26724 125941 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 330 Cherry St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5996203.89662 2115167.13558 37.7876271253444 -122.456948819342 (37.7876271253444, -122.456948819342) 11 6 1 54 31
27427 188430 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 895 Vermont St 2 Sidewalk: Curb side : Yard Tree Private 2     3     6011323.63457 2104185.0777 37.7583295512927 -122.403864109736 (37.7583295512927, -122.403864109736) 10 3 8 28856 29
27831 98834 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 333 Pacheco St 3 Sidewalk: Curb side : Cutout Tree Private 2           5994230.9 2100817.4 37.748113026994 -122.462733567037 (37.748113026994, -122.462733567037) 1 8 4 29491 40
27948 205967 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 340 Rivera St 3 Sidewalk: Property side : Yard Tree Private 2     6 Width 3ft   5992062.49278 2100502.89931 37.7471243628055 -122.470208875054 (37.7471243628055, -122.470208875054) 1 8 4 29491 40
30134 101033 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1010X Portola Dr 7 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
30713 99829 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 2398 Broadway 3 Front Yard : Yard Tree Private 2           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376) 13 9 1 29490 27
33226 188428 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 437 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 4ft   6011224.31071 2106297.23257 37.7641235064287 -122.404356282613 (37.7641235064287, -122.404356282613) 8 3 8 28856 29
34735 249869 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 230 Greenwich St 5 Sidewalk: Curb side : Yard Tree Private 2     15 Width 0ft   6011727.52121 2120455.9779 37.8030282150334 -122.403612074753 (37.8030282150334, -122.403612074753) 3 1 10 308 23
37591 187040 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2501 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984973.3237 2097770.8307 37.7392104419663 -122.49452091353 (37.7392104419663, -122.49452091353) 1 8 3 29491 35
39009 255287 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 2758 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999862 2117824 37.7951315610034 -122.444483561153 (37.7951315610034, -122.444483561153) 13 9 1 57 17
39962 187547 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1398 Somerset St 1 Side Yard : Yard Tree Private 2     15     6011342.64618 2088318.49889 37.7147643480751 -122.402682560663 (37.7147643480751, -122.402682560663) 10 7 8 309 39
41783 205963 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1575 Plymouth Ave 1 Sidewalk: Curb side : Yard Tree Private 2     39 Width 3ft   5995549.16241 2094435.18175 37.730664862776 -122.4577133537 (37.730664862776, -122.4577133537) 9 7 4 28861 40
42128 102522 Undocumented 4 Cedrus deodara :: Deodar Cedar 109 1X 31st St 2 Unaccepted Street : Yard Tree Private 2           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233) 9 7 4 59 40
42238 26408 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 34 Maple St 5 Sidewalk: Property side : Cutout Tree DPW 1     3 10   5996561.99823 2116111.65083 37.7902410678174 -122.455778167326 (37.7902410678174, -122.455778167326) 11 6 1 54 31
42557 101977 Property Tree 8 Cedrus deodara :: Deodar Cedar 109 601 Grand View Ave   Front Yard : Yard Tree Private 2           6000076.2 2101609.9 37.7506239629918 -122.442577679409 (37.7506239629918, -122.442577679409) 2 4 5 28862 22
42569 186969 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2550x Yorba St 1 Median : Cutout Tree DPW 1     1 Width 0ft   5985198.4325 2096209.9829 37.7349379433341 -122.493627618821 (37.7349379433341, -122.493627618821) 1 8 3 29491 35
43597 78107 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 970 GUERRERO ST 1 Front Yard : Yard Tree Private 2     15     6005649.9 2103318.5 37.7556315237614 -122.423424799558 (37.7556315237614, -122.423424799558) 2 4 5 28859 19
45148 181856 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2321 30th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 0ft   5986994.4655 2099435.9665 37.7439005468649 -122.48765510164 (37.7439005468649, -122.48765510164) 1 8 3 29491 35
46378 185499 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2400 Sunset Blvd 53 unknown : Yard Tree Private 2     1 Width 0ft   5985130.3697 2098685.0494 37.741729830799 -122.494045287668 (37.741729830799, -122.494045287668) 1 8 3 29491 35
47970 185575 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2201 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984929.5876 2099652.8652 37.744375440677 -122.494810854753 (37.744375440677, -122.494810854753) 1 8 3 29491 35
48358 112182 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 301x CORBETT AVE 8 Sidewalk: Property side : Yard Tree DPW 1       3x3   5999677 2105220 37.760513648973 -122.444217531177 (37.760513648973, -122.444217531177) 15 5 5 28862 3
48978 87197 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 617 Sanchez St 1 Front Yard : Yard Tree Private 2         Permit Number 50213 6003760 2104634 37.7591367256626 -122.430054504807 (37.7591367256626, -122.430054504807) 2 4 5 28862 3
49113 186347 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1801 Sunset Blvd 14 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984771.9036 2102744.0011 37.7528536226758 -122.495584034876 (37.7528536226758, -122.495584034876) 1 8 3 56 35
54286 181536 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1300 Sunset Blvd 14 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984851.3492 2105801.1612 37.7612523876307 -122.495534766047 (37.7612523876307, -122.495534766047) 1 8 3 56 35
55770 249867 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 230 Greenwich St 3 Sidewalk: Curb side : Yard Tree Private 2     20 Width 0ft   6011726.07393 2120469.26255 37.8030646105966 -122.403618018374 (37.8030646105966, -122.403618018374) 3 1 10 28860 6
56151 187558 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 3959 Somerset St 2 Side Yard : Yard Tree Private 2     14     6011340.42145 2088314.93577 37.7147544402534 -122.402689999868 (37.7147544402534, -122.402689999868) 10 7 8 309 39
56487 222767 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 301 Upper Ter 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 3ft   5999265.86502 2105880.94381 37.7623049720107 -122.445686985283 (37.7623049720107, -122.445686985283) 15 5 5 29492 3
57971 185943 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2001 Sunset Blvd 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984815.4773 2101526.8869 37.7495143130094 -122.49534359797 (37.7495143130094, -122.49534359797) 1 8 3 29491 35
58916 205964 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 340 Rivera St 6 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   5992030.75114 2100502.15338 37.7471204795254 -122.470318579738 (37.7471204795254, -122.470318579738) 1 8 4 29491 40
59355 222755 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1201 San Jose Ave 63 Front Yard : Yard Tree Private 2     2     6004520.50239 2096106.24314 37.7357645179181 -122.426817006298 (37.7357645179181, -122.426817006298) 2 7 5 28861 2
60236 187049 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2501 Sunset Blvd 68 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984997.5359 2097656.4952 37.738897924427 -122.494428773867 (37.738897924427, -122.494428773867) 1 8 3 29491 35
64212 187557 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 3959 Somerset St 1 Side Yard : Yard Tree Private 2     17     6011334.94928 2088323.74418 37.7147783208423 -122.402709533143 (37.7147783208423, -122.402709533143) 10 7 8 309 39
67929 181368 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1500 Sunset Blvd 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984948.7535 2104361.5119 37.7573052146707 -122.4950917287 (37.7573052146707, -122.4950917287) 1 8 3 56 35
69395 188432 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1 Jack Balestreri Way 6 Front Yard : Yard Tree Private 2     16     6012439.74697 2104738.60671 37.7599117105733 -122.400042949735 (37.7599117105733, -122.400042949735) 10 3 8 28856 29
70049 187545 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1399 Somerset St 1 Side Yard : Yard Tree Private 2     16     6011375.77756 2088317.82522 37.7147643480702 -122.40256799691 (37.7147643480702, -122.40256799691) 10 7 8 309 39
70249 113112 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1633 OAKDALE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2           6014731 2095647 37.7350755495662 -122.391482947841 (37.7350755495662, -122.391482947841) 10 3 8 58 1
71413 181375 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1500 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984932.3448 2104426.3747 37.7574823492807 -122.495153258567 (37.7574823492807, -122.495153258567) 1 8 3 56 35
73741 185501 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2400 Sunset Blvd 55 unknown : Yard Tree Private 2     2 Width 0ft   5985131.6978 2098729.54 37.7418520677037 -122.494043973834 (37.7418520677037, -122.494043973834) 1 8 3 29491 35
74277 251372 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1526 Masonic Ave 1 Sidewalk: Property side : Cutout Tree Private 2   11/01/2017 12:00:00 AM 3 3x3 Permit Number 779800 5999767 2107205 37.7659690994291 -122.444048894864 (37.7659690994291, -122.444048894864) 15 5 5 29492 9
74444 51490 Permitted Site 7 Cedrus deodara :: Deodar Cedar 109 1141 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2005 12:00:00 AM     Permit Number 47801 6006346.62176787 2120383.49035499 37.8025271407982 -122.42222766993 (37.8025271407982, -122.42222766993) 5 9 1 28858 32
74804 222757 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1351 Douglass St 4 Sidewalk: Property side : Yard Tree Private 2     18 Width 6ft   6001399.79942 2099748.33907 37.7455879196477 -122.437867255078 (37.7455879196477, -122.437867255078) 2 4 5 63 22
75652 188435 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 47 Ceres St 1 : Tree Private 2     14 Width 3ft   6013897.60555 2093909.5086 37.730258461857 -122.394242705643 (37.730258461857, -122.394242705643) 10 3 8 58 1
75721 205965 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 340 Rivera St 5 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   5992042.12067 2100502.3853 37.7471217736611 -122.470279282079 (37.7471217736611, -122.470279282079) 1 8 4 29491 40
78900 254971 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 972 Guerrero St 1 Front Yard : Yard Tree Private 2       3x3   6005650 2103315 37.7556219192197 -122.423424204919 (37.7556219192197, -122.423424204919) 2 4 5 28859 19
83233 249878 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 230 Greenwich St 14 Back Yard : Yard Tree Private 2     23 Width 0ft   6011550.21069 2120457.44752 37.8030223442537 -122.404225768513 (37.8030223442537, -122.404225768513) 3 1 10 28860 6
83249 205969 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 340 Rivera St 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 3ft   5992083.35814 2100504.34625 37.7471295420093 -122.470136830344 (37.7471295420093, -122.470136830344) 1 8 4 29491 40
84436 113237 Undocumented 4 Cedrus deodara :: Deodar Cedar 109 700X JUNIPERO SERRA BLVD 1 Median : Cutout Tree Private 2       3x3   5991325 2093086 37.7267167762023 -122.472218478241 (37.7267167762023, -122.472218478241) 9 8 4 64 40
85627 222770 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 81 Digby St 2 Sidewalk: Property side : Yard Tree Private 2     2     6002588.1649 2097709.69049 37.7400577698522 -122.433612402404 (37.7400577698522, -122.433612402404) 2 7 5 63 7
85861 116668 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100x Esmeralda Ave 4 Unaccepted Street : Yard Tree DPW 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
86087 181462 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1400 Sunset Blvd 22 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984903.9819 2105176.5315 37.7595404106399 -122.495306668351 (37.7595404106399, -122.495306668351) 1 8 3 56 35
86731 120440 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 99 22nd Ave 3 Sidewalk: Property side : Yard Tree Private 2     26     5988935.73102 2114756.99709 37.7860809522857 -122.482064894816 (37.7860809522857, -122.482064894816) 11 6 1 55 33
87221 222766 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 230 States St 2 Sidewalk: Property side : Yard Tree Private 2     15 Width 3ft   6000813.28716 2106520.59939 37.7641495354877 -122.440380922268 (37.7641495354877, -122.440380922268) 15 5 5 28862 3
89352 249871 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 230 Greenwich St 7 Sidewalk: Curb side : Yard Tree Private 2     12 Width 0ft   6011715.31721 2120468.19877 37.8030610888482 -122.403655167571 (37.8030610888482, -122.403655167571) 3 1 10 28860 6
91073 205974 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 645 Edna St 1 Sidewalk: Property side : Yard Tree Private 2     9     5998776.7097 2095073.04363 37.732601166099 -122.446601147923 (37.732601166099, -122.446601147923) 9 7 4 59 40
91435 187245 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2401 Sunset Blvd 28 Median : Yard Tree DPW 1     1 Width 0ft   5984968.6731 2098517.9713 37.74126161674 -122.494592058244 (37.74126161674, -122.494592058244) 1 8 3 29491 35
92202 249870 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 230 Greenwich St 6 Sidewalk: Curb side : Yard Tree Private 2     10 Width 0ft   6011716.19315 2120469.03614 37.8030634369921 -122.403652195296 (37.8030634369921, -122.403652195296) 3 1 10 28860 6
93405 222762 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 310 Liberty St 29 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   6003941.63846 2103927.14529 37.7572061559584 -122.429375905767 (37.7572061559584, -122.429375905767) 2 4 5 28862 3
93858 222754 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1319 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009549.26243 2101463.40193 37.7507571508265 -122.409808579911 (37.7507571508265, -122.409808579911) 2 4 7 28859 19
97059 222768 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 79 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6002832.56338 2108743.90779 37.7703689643988 -122.433555737015 (37.7703689643988, -122.433555737015) 15 5 5 29492 9
97164 222771 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 112 27th St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6005731.8211 2100248.43843 37.7472064655097 -122.422923303361 (37.7472064655097, -122.422923303361) 2 7 5 28859 22
99985 101898 Undocumented 4 Cedrus deodara :: Deodar Cedar 109 99X MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2           6008233.5 2119097.7 37.7991029311983 -122.415607021356 (37.7991029311983, -122.415607021356) 5 1 10 308 32
100469 123935 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1 08th Ave 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5993304.58921 2114931.5281 37.7868132950893 -122.466962635679 (37.7868132950893, -122.466962635679) 11 6 1 54 11
102066 205973 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 Edgehill Way 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5994796.55724 2098924.8239 37.7429490497539 -122.460640430205 (37.7429490497539, -122.460640430205) 1 8 4 59 40
102464 248911 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1633 Oakdale Ave 1 Front Yard : Yard Tree Private 2           6014844.92913 2095599.8976 37.7349525388235 -122.391085759591 (37.7349525388235, -122.391085759591) 10 3 8 58 1
102676 186338 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1801 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984768.4217 2102859.4402 37.7531703827167 -122.49560458965 (37.7531703827167, -122.49560458965) 1 8 3 56 35
103759 187248 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2401 Sunset Blvd 31 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984942.1217 2098467.7278 37.7411221075772 -122.49468015895 (37.7411221075772, -122.49468015895) 1 8 3 29491 35
104420 67845 Permitted Site 7 Cedrus deodara :: Deodar Cedar 109 4175 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/04/1993 12:00:00 AM   3x3 Permit Number 767162 6002749.4858836 2100326.5930757 37.7472523267557 -122.433241561015 (37.7472523267557, -122.433241561015) 2 4 5 63 22
107422 186342 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1801 Sunset Blvd 9 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984831.8998 2102810.9611 37.7530409894565 -122.495381497893 (37.7530409894565, -122.495381497893) 1 8 3 56 35
110861 106342 Permitted Site 7 Cedrus deodara :: Deodar Cedar 109 497 VALLEY ST 4 Sidewalk: Curb side : Cutout Tree Private 2   04/17/2014 12:00:00 AM 6   Permit Number 770848 6002779 2099138 37.7439904023543 -122.433054595711 (37.7439904023543, -122.433054595711) 2 7 5 63 22
112470 187019 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2501 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     0 Width 0ft   5984951.1292 2097900.2988 37.7395646275627 -122.494607193049 (37.7395646275627, -122.494607193049) 1 8 3 29491 35
113048 184873 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 1201 Sunset Blvd 63 Sidewalk: Property side : Yard Tree Private 2     26 Width 0ft   5984678.6788 2106815.322 37.7640268760632 -122.496206778479 (37.7640268760632, -122.496206778479) 1 8 3 56 35
113943 222765 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 272 Corbett Ave 1 Side Yard : Yard Tree Private 2     16 Width 3ft   5999637.29501 2105376.06979 37.760939912666 -122.444366068238 (37.760939912666, -122.444366068238) 15 5 5 28862 3
115960 205971 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 400x Marietta Dr 50 Median : Cutout Tree DPW 1     8 Width 3ft   5998959.86382 2096907.26724 37.7376479698832 -122.446099828942 (37.7376479698832, -122.446099828942) 9 7 4 59 40
117634 125946 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 Alice B Toklas Pl 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006887.30647 2114142.45385 37.7854212934049 -122.419913496417 (37.7854212934049, -122.419913496417) 13 9 9 28858 36
118182 247914 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 399 Franconia St 5 Side Yard : Yard Tree Private 2     22     6010000.52553 2098831.51714 37.7435558520369 -122.408062476915 (37.7435558520369, -122.408062476915) 2 7 7 28859 2
118458 248040 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 21 Rutledge St 2 Front Yard : Yard Tree Private 2     8     6010515.95575 2099424.13934 37.7452119095038 -122.406321984771 (37.7452119095038, -122.406321984771) 2 7 7 28859 2
119590 187241 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2401 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984938.8538 2098551.4669 37.7413518412824 -122.494697630172 (37.7413518412824, -122.494697630172) 1 8 3 29491 35
120016 188434 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 406 Arkansas St 2 Sidewalk: Curb side : Yard Tree Private 2     19 Width 4ft   6012917.44565 2105140.82493 37.7610427357449 -122.398419034005 (37.7610427357449, -122.398419034005) 10 3 8 28856 29

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);