trees

155 rows where qSpecies_id = 109 sorted by Zip Codes

✎ 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)
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                      
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                      
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                      
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
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
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
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
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
133152 188429 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 449 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 6ft   6011226.32469 2106249.13843 37.7639915632946 -122.40434593142 (37.7639915632946, -122.40434593142) 8 3 8 28856 29
135623 258062 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 567 Mississippi St 2 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
183281 188431 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 889 Vermont St 1 Sidewalk: Curb side : Yard Tree Private 2     3     6011294.06359 2104194.03596 37.7583524966 -122.403967010163 (37.7583524966, -122.403967010163) 10 3 8 28856 29
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
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
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
193015 125945 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100 Alice B Toklas Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006900.61191 2114145.75127 37.7854310968993 -122.41986769754 (37.7854310968993, -122.41986769754) 13 9 9 28858 36
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
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
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
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
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
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
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
171826 116667 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 100x Esmeralda Ave 3 Unaccepted Street : Yard Tree DPW 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
181200 248088 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 14 Montcalm St 2 Side Yard : Yard Tree Private 2     21     6010648.22773 2100325.37229 37.7476938971542 -122.405928083511 (37.7476938971542, -122.405928083511) 2 7 7 28859 2
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
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
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
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
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
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
121236 256783 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 176 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994250 2093087 37.7268883657721 -122.462106990145 (37.7268883657721, -122.462106990145) 9 8 4 28861 40
135624 256784 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 176 Dorado Ter 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994250 2093087 37.7268883657721 -122.462106990145 (37.7268883657721, -122.462106990145) 9 8 4 28861 40
176130 222760 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 10x Benton Ave 8 Median : Yard Tree DPW 1     12     6004726.81144 2094996.18589 37.73272821244 -122.426024717968 (37.73272821244, -122.426024717968) 2 7 7 28861 2
191394 205961 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 600x Wildwood Way 1 Median : Yard Tree DPW 1     16     5995381.06521 2093316.38835 37.7275832683311 -122.458213544042 (37.7275832683311, -122.458213544042) 9 7 4 28861 40
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
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
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
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
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
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
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
134875 222763 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 324 Cumberland St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003511.54798 2104505.04624 37.7587685751304 -122.430904567088 (37.7587685751304, -122.430904567088) 2 4 5 28862 3
137550 253388 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 30 Grand View Ave 1 Side Yard : Yard Tree Private 2       3x3   6000475 2103841 37.7567727470696 -122.441358672007 (37.7567727470696, -122.441358672007) 2 4 5 28862 38
191476 121091 Undocumented 4 Cedrus deodara :: Deodar Cedar 109 30X Grand View Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000475 2103841 37.7567727470696 -122.441358672007 (37.7567727470696, -122.441358672007) 2 4 5 28862 38
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
125322 185206 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2500 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985140.6623 2098012.0455 37.7398825454368 -122.493960112537 (37.7398825454368, -122.493960112537) 1 8 3 29491 35
134036 185070 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2550x Yorba St 1 Median : Cutout Tree DPW 1     1 Width 0ft   5985042.3194 2096218.4188 37.7349519720941 -122.494167970386 (37.7349519720941, -122.494167970386) 1 8 3 29491 35
135419 205960 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 55 Marcela Ave 4 Sidewalk: Curb side : Yard Tree Private 2     1 Width 4ft   5994725.83926 2100688.55493 37.747787744113 -122.461012759449 (37.747787744113, -122.461012759449) 1 8 4 29491 40
138765 205968 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 340 Rivera St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   5992072.49202 2100505.518 37.7471321311413 -122.470174489472 (37.7471321311413, -122.470174489472) 1 8 4 29491 40
139596 185191 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2500 Sunset Blvd 43 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985141.9904 2097877.9096 37.7395143219875 -122.493945637707 (37.7395143219875, -122.493945637707) 1 8 3 29491 35
143069 185482 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2400 Sunset Blvd 35 unknown : Yard Tree Private 2     1 Width 0ft   5985148.9628 2098503.7667 37.7412331652619 -122.493967642795 (37.7412331652619, -122.493967642795) 1 8 3 29491 35
145792 185190 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2500 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985158.5914 2097861.3086 37.7394697114092 -122.493887016425 (37.7394697114092, -122.493887016425) 1 8 3 29491 35
146744 205966 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 340 Rivera St 4 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   5992057.77948 2100503.94185 37.7471269528584 -122.470225249018 (37.7471269528584, -122.470225249018) 1 8 4 29491 40
154677 181855 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2321 30th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5986995.4808 2099452.2108 37.7439452086002 -122.487652784151 (37.7439452086002, -122.487652784151) 1 8 3 29491 35
156711 185487 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2400 Sunset Blvd 40 unknown : Yard Tree Private 2     1 Width 0ft   5985139.0022 2098533.6484 37.7413146295557 -122.494004284239 (37.7413146295557, -122.494004284239) 1 8 3 29491 35
166613 185858 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2000 Sunset Blvd 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985012.4452 2100952.2478 37.7479480417082 -122.494620128976 (37.7479480417082, -122.494620128976) 1 8 3 29491 35
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
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
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
124217 109412 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 24 DELMAR ST 1 Front Yard : Yard Tree Private 2   04/03/2015 12:00:00 AM 3 3x3 Permit Number 774367 5999307.7 2108197.1 37.7686669444558 -122.445708866914 (37.7686669444558, -122.445708866914) 15 5 11 29492 9
160978 112451 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1526 MASONIC AVE 1 Front Yard : Cutout Tree Private 2       3x6   5999767 2107205 37.7659690994291 -122.444048894864 (37.7659690994291, -122.444048894864) 15 5 5 29492 9
164452 117027 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 731 CLAYTON ST 1 Front Yard : Cutout Tree Private 2           5998515 2108057 37.7682369747157 -122.448440651351 (37.7682369747157, -122.448440651351) 15 5 11 29492 9
175617 222759 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 25 Woodland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   5997031.40026 2106439.64122 37.7637111852528 -122.453455459504 (37.7637111852528, -122.453455459504) 15 5 11 29492 12
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
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
129291 101899 Undocumented 4 Cedrus deodara :: Deodar Cedar 109 99X MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2           6008233.5 2119097.7 37.7991029311983 -122.415607021356 (37.7991029311983, -122.415607021356) 5 1 10 308 32
167667 125943 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 90 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     48     6008175.06816 2119117.82547 37.799154906033 -122.415810641761 (37.799154906033, -122.415810641761) 5 1 10 308 32
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
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
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
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
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

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