trees

438 rows where qSpecies_id = 63 sorted by TreeID

✎ 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)
154451 178178 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 769 Cayuga Ave 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   6001369.37887 2092541.7115 37.725798463024 -122.43745647446 (37.725798463024, -122.43745647446) 9 7 6 28861 25
188305 178179 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 201 Yale St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   6007200.07685 2092715.80897 37.7266062646522 -122.417312460112 (37.7266062646522, -122.417312460112) 9 3 7 309 28
146926 18112 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1102X Portola Dr 1 Median : Cutout Tree DPW 1     24 10   5995262.3028257 2098061.6496673 37.7406057719366 -122.458967536918 (37.7406057719366, -122.458967536918) 1 7 4 59 40
193872 18113 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1102X PORTOLA DR 2 Median : Cutout Tree DPW 1     24 10   5995249 2098057 37.7405922403942 -122.459013196083 (37.7405922403942, -122.459013196083) 1 7 4 59 40
173494 181382 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1500 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984896.9779 2104470.096 37.7576003251998 -122.49527879388 (37.7576003251998, -122.49527879388) 1 8 3 56 35
173903 184079 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 Sunset Blvd 80 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984934.15 2104045.1938 37.7564358379272 -122.49511890768 (37.7564358379272, -122.49511890768) 1 8 3 56 35
167835 184087 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 Sunset Blvd 88 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5984947.9817 2104096.3091 37.7565769961358 -122.495074842554 (37.7565769961358, -122.495074842554) 1 8 3 56 35
2394 184349 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1251 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     28 Width 0ft   5984659.3559 2106454.1603 37.7630340956965 -122.496246960605 (37.7630340956965, -122.496246960605) 1 8 3 56 35
162189 184737 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984694.2473 2106265.1087 37.7625170568543 -122.496112336517 (37.7625170568543, -122.496112336517) 1 8 3 56 35
125583 184742 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5984665.3886 2106227.5165 37.7624121488276 -122.496209373012 (37.7624121488276, -122.496209373012) 1 8 3 56 35
34962 184744 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984688.1718 2106200.1767 37.7623384159342 -122.496128558374 (37.7623384159342, -122.496128558374) 1 8 3 56 35
69152 184781 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984718.1696 2105899.6288 37.7615149526664 -122.496002635394 (37.7615149526664, -122.496002635394) 1 8 3 56 35
52616 184782 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 43 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984677.5396 2105882.9212 37.7614666984861 -122.496141923024 (37.7614666984861, -122.496141923024) 1 8 3 56 35
68325 184784 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984713.613 2105863.1758 37.7614145960538 -122.496015705201 (37.7614145960538, -122.496015705201) 1 8 3 56 35
41307 184977 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2701 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984998.3534 2096742.4516 37.7363882534207 -122.494358589298 (37.7363882534207, -122.494358589298) 1 8 3 29491 35
193239 184993 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2701 Sunset Blvd 19 Sidewalk: Property side : Yard Tree Private 2     29 Width 0ft   5985021.3833 2096558.6319 37.7358848813643 -122.494265421421 (37.7358848813643, -122.494265421421) 1 8 3 29491 35
39844 185075 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2801 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985040.8539 2096108.9226 37.7346512389504 -122.494164969235 (37.7346512389504, -122.494164969235) 1 8 3 29491 35
184638 185176 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2500 Sunset Blvd 28 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5985156.5992 2097794.2406 37.7392854441206 -122.493888963204 (37.7392854441206, -122.493888963204) 1 8 3 29491 35
63898 185202 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2500 Sunset Blvd 55 Sidewalk: Property side : Yard Tree Private 2     20 Width 0ft   5985155.2712 2097966.8909 37.7397594177965 -122.493906274966 (37.7397594177965, -122.493906274966) 1 8 3 29491 35
116998 185204 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2500 Sunset Blvd 57 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5985139.3342 2097991.4603 37.7398259462999 -122.493963187792 (37.7398259462999, -122.493963187792) 1 8 3 29491 35
45510 185230 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2509 44th Ave 1 Sidewalk: Property side : Yard Tree Private 2     35 Width 0ft   5982693.8052 2098008.2989 37.7397287878455 -122.50241990404 (37.7397287878455, -122.50241990404) 1 8 3 29491 35
109871 185295 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984962.8666 2097355.3585 37.7380690548117 -122.494526449097 (37.7380690548117, -122.494526449097) 1 8 3 29491 35
43488 185314 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 39 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5985007.4607 2097237.2784 37.7377474483668 -122.494363565845 (37.7377474483668, -122.494363565845) 1 8 3 29491 35
143060 185340 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     20 Width 0ft   5984975.3236 2097003.7352 37.7371043205037 -122.494457466722 (37.7371043205037, -122.494457466722) 1 8 3 29491 35
78578 185360 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 85 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985022.2207 2096895.7045 37.7368104416486 -122.494287364038 (37.7368104416486, -122.494287364038) 1 8 3 29491 35
156225 185362 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 87 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984999.1909 2096870.1623 37.7367389618664 -122.494365104774 (37.7367389618664, -122.494365104774) 1 8 3 29491 35
128546 185363 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 88 Sidewalk: Property side : Yard Tree Private 2     43 Width 0ft   5984980.3483 2096870.9998 37.7367401586853 -122.494430312609 (37.7367401586853, -122.494430312609) 1 8 3 29491 35
188950 185409 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2300 Sunset Blvd 24 unknown : Yard Tree Private 2     8 Width 0ft   5985081.6412 2099150.9001 37.7430060796886 -122.494248101225 (37.7430060796886, -122.494248101225) 1 8 3 29491 35
189399 185410 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2300 Sunset Blvd 25 unknown : Yard Tree Private 2     8 Width 0ft   5985099.6362 2099155.3989 37.7430194852088 -122.494186211855 (37.7430194852088, -122.494186211855) 1 8 3 29491 35
75335 185550 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2201 Sunset Blvd 34 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5984877.5845 2099886.0836 37.7450127509214 -122.495007861214 (37.7450127509214, -122.495007861214) 1 8 3 29491 35
172030 185637 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 17 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5985047.0682 2100399.1831 37.7464315030837 -122.494459642192 (37.7464315030837, -122.494459642192) 1 8 3 29491 35
56295 185638 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5985050.0993 2100407.4104 37.7464542704067 -122.494449767525 (37.7464542704067, -122.494449767525) 1 8 3 29491 35
190239 185656 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 37 Sidewalk: Property side : Yard Tree Private 2     16 Width 0ft   5985042.305 2100549.4408 37.746843791076 -122.494487187243 (37.746843791076, -122.494487187243) 1 8 3 29491 35
95767 185659 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 40 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5985060.0587 2100566.7616 37.7468923883135 -122.494427074117 (37.7468923883135, -122.494427074117) 1 8 3 29491 35
101713 185705 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2101 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984891.1634 2100474.9689 37.7466304646766 -122.495004322509 (37.7466304646766, -122.495004322509) 1 8 3 29491 35
21400 186097 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 43 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984866.2826 2101735.8043 37.7500909175156 -122.495183318527 (37.7500909175156, -122.495183318527) 1 8 3 29491 35
42969 186098 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 44 Sidewalk: Property side : Yard Tree Private 2     15 Width 0ft   5984859.9858 2101721.9514 37.7500525125937 -122.495204071455 (37.7500525125937, -122.495204071455) 1 8 3 29491 35
192105 186099 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5984856.2078 2101707.4688 37.7500125261534 -122.495216067916 (37.7500125261534, -122.495216067916) 1 8 3 29491 35
16186 186101 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984808.9821 2101715.6546 37.7500322370685 -122.495379978089 (37.7500322370685, -122.495379978089) 1 8 3 29491 35
86298 186102 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 48 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984817.1679 2101703.0611 37.7499981380626 -122.495350742926 (37.7499981380626, -122.495350742926) 1 8 3 29491 35
152112 186248 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 12 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984775.1177 2103139.467 37.7539396511246 -122.495602086568 (37.7539396511246, -122.495602086568) 1 8 3 56 35
126322 186253 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 64 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984779.1353 2103090.988 37.7538067764424 -122.495584617514 (37.7538067764424, -122.495584617514) 1 8 3 56 35
170803 186254 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984796.5449 2103072.2391 37.7537563165951 -122.495523029283 (37.7537563165951, -122.495523029283) 1 8 3 56 35
106470 186343 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984811.8118 2102790.6052 37.7529839215525 -122.495449463877 (37.7529839215525, -122.495449463877) 1 8 3 56 35
121598 186348 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984789.3132 2102727.1271 37.7528083107787 -122.495522585708 (37.7528083107787, -122.495522585708) 1 8 3 56 35
54785 186417 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1601 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984727.1251 2104191.8612 37.7568264235859 -122.495845680799 (37.7568264235859, -122.495845680799) 1 8 3 56 35
45383 186433 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1601 Sunset Blvd 21 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984738.4307 2104031.9087 37.7563879005336 -122.495794783817 (37.7563879005336, -122.495794783817) 1 8 3 56 35
170849 186531 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 2 unknown : Yard Tree Private 2     9 Width 0ft   5984751.3064 2104919.289 37.7588251541556 -122.495815712177 (37.7588251541556, -122.495815712177) 1 8 3 56 35
132701 186592 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 63 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984742.0945 2104511.4521 37.757704808066 -122.495817486185 (37.757704808066, -122.495817486185) 1 8 3 56 35
93032 186593 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 64 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984773.0801 2104494.2844 37.7576594849516 -122.495709060541 (37.7576594849516, -122.495709060541) 1 8 3 56 35
103634 186594 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984719.4834 2104488.841 37.7576414000341 -122.495894015518 (37.7576414000341, -122.495894015518) 1 8 3 56 35
11326 186595 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 66 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984740.8383 2104479.6291 37.7576173573885 -122.49581948315 (37.7576173573885, -122.49581948315) 1 8 3 56 35
178211 186688 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1401 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984691.4289 2105282.7412 37.7598195855983 -122.496049606755 (37.7598195855983, -122.496049606755) 1 8 3 56 35
33872 186702 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1401 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     23 Width 0ft   5984718.4366 2105146.0279 37.7594457908807 -122.495946116181 (37.7594457908807, -122.495946116181) 1 8 3 56 35
63026 186711 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984852.6024 2106104.2938 37.762084778312 -122.495552790494 (37.762084778312, -122.495552790494) 1 8 3 56 35
61393 186897 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2700 Sunset Blvd 46 Sidewalk: Property side : Yard Tree Private 2     33 Width 0ft   5985183.7588 2096592.6965 37.7359879144627 -122.493706542591 (37.7359879144627, -122.493706542591) 1 8 3 29491 35
102199 186902 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2700 Sunset Blvd 51 Sidewalk: Property side : Yard Tree Private 2     17 Width 0ft   5985182.8419 2096662.3766 37.7361791837873 -122.493714845671 (37.7361791837873, -122.493714845671) 1 8 3 29491 35
85521 187012 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2501 Sunset Blvd 31 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5984974.837 2098002.6963 37.7398471711362 -122.494532769595 (37.7398471711362, -122.494532769595) 1 8 3 29491 35
183575 187017 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2501 Sunset Blvd 36 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5984955.1646 2097931.5729 37.7396507340198 -122.494595545547 (37.7396507340198, -122.494595545547) 1 8 3 29491 35
157519 187090 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 26 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5985165.338 2097125.749 37.7374504565555 -122.493809499319 (37.7374504565555, -122.493809499319) 1 8 3 29491 35
42716 187095 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 31 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5985178.0339 2097175.5923 37.7375880557056 -122.493769276198 (37.7375880557056, -122.493769276198) 1 8 3 29491 35
120570 187096 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 32 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985160.1655 2097173.7115 37.7375818461267 -122.493830916284 (37.7375818461267, -122.493830916284) 1 8 3 29491 35
66936 187102 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5985165.8082 2097224.4952 37.7377216147142 -122.493815148362 (37.7377216147142, -122.493815148362) 1 8 3 29491 35
49420 187123 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     37 Width 0ft   5985149.3505 2097343.9312 37.7380485911062 -122.493880849001 (37.7380485911062, -122.493880849001) 1 8 3 29491 35
79197 187345 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2200 Sunset Blvd 30 Sidewalk: Property side : Yard Tree Private 2     29 Width 0ft   5985074.9529 2099709.2267 37.7445387020266 -122.494312372955 (37.7445387020266, -122.494312372955) 1 8 3 29491 35
20177 187394 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5985039.81 2100667.7899 37.7471685994587 -122.494504537591 (37.7471685994587, -122.494504537591) 1 8 3 29491 35
72242 187396 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 49 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5985054.0302 2100695.3416 37.74724508117 -122.494457396667 (37.74724508117, -122.494457396667) 1 8 3 29491 35
133127 194437 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1021 Minnesota St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6015301.57899 2103740.56291 37.7573304413508 -122.390075457711 (37.7573304413508, -122.390075457711) 10 3 8 28856 29
100087 194438 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1051 18th St 1 Side Yard : Yard Tree Private 2     11     6014405.25344 2105708.40792 37.7626839643245 -122.39331303148 (37.7626839643245, -122.39331303148) 10 3 8 28856 29
17195 194439 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 32 Median : Yard Tree DPW 1     12     6012481.17054 2103301.60211 37.7559683209947 -122.3997987802 (37.7559683209947, -122.3997987802) 10 3 8 28856 29
95523 194440 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 33 Median : Yard Tree DPW 1     6     6012485.2688 2103286.14111 37.7559260969364 -122.399783521388 (37.7559260969364, -122.399783521388) 10 3 8 28856 29
170052 194441 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 39 Median : Yard Tree DPW 1     18     6012501.46554 2103105.94469 37.7554322198433 -122.399714855461 (37.7554322198433, -122.399714855461) 10 3 8 28856 29
34697 194442 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 51 Median : Yard Tree DPW 1     24     6012500.2858 2102979.92319 37.7550861265451 -122.399710087265 (37.7550861265451, -122.399710087265) 10 3 8 28856 29
65583 194443 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1900 23rd St 2 Front Yard : Yard Tree Private 2     28     6012732.21441 2102858.09004 37.7547645253758 -122.398899455441 (37.7547645253758, -122.398899455441) 10 3 8 28856 29
185304 194444 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 25th St 14 Sidewalk: Curb side : Yard Tree Private 2     14     6014137.98688 2101954.90704 37.7523628094083 -122.393974650128 (37.7523628094083, -122.393974650128) 10 3 8 28856 1
126912 194445 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 25th St 15 Sidewalk: Curb side : Yard Tree Private 2     11     6014148.42594 2101954.90209 37.7523633759809 -122.393938549541 (37.7523633759809, -122.393938549541) 10 3 8 28856 1
140344 194446 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 25th St 16 Sidewalk: Curb side : Yard Tree Private 2     18     6014162.91853 2101954.38506 37.7523627617528 -122.393888395238 (37.7523627617528, -122.393888395238) 10 3 8 28856 1
120848 194447 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 680 De Haro St 4 Sidewalk: Property side : Yard Tree Private 2     1     6012074.20817 2105270.47212 37.761351707727 -122.401344555627 (37.761351707727, -122.401344555627) 10 3 8 28856 29
40232 194448 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 32 Median : Yard Tree DPW 1     27     6012284.461 2102001.80848 37.7523884032163 -122.400387777686 (37.7523884032163, -122.400387777686) 10 3 8 28856 29
37115 194449 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 23 Median : Yard Tree DPW 1     23     6012259.688 2102130.23115 37.7527396424455 -122.400482467314 (37.7527396424455, -122.400482467314) 10 3 8 28856 29
109147 194450 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 21 Median : Yard Tree DPW 1     27     6012266.91736 2102141.9772 37.7527722977062 -122.40045829173 (37.7527722977062, -122.40045829173) 10 3 8 28856 29
37367 194451 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 930 Kansas St 1 Front Yard : Yard Tree Private 2     29     6011573.12502 2104017.28324 37.7578827599862 -122.402989455212 (37.7578827599862, -122.402989455212) 10 3 8 28856 29
78908 194452 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 20th St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6011998.43391 2104639.55141 37.7596151114626 -122.401562284167 (37.7596151114626, -122.401562284167) 10 3 8 28856 29
43289 194453 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2250 26th St 1 Sidewalk: Curb side : Yard Tree Private 2     9     6011877.75436 2101392.1938 37.750691845665 -122.401751398122 (37.750691845665, -122.401751398122) 10 3 8 28856 29
133881 194454 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Rhode Island St 7 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   6012013.85217 2102295.56099 37.753179889343 -122.40134423455 (37.753179889343, -122.40134423455) 10 3 8 28856 29
128353 194455 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 22nd St 11 Front Yard : Yard Tree Private 2     8     6013406.26386 2103790.51305 37.757362292666 -122.396633751156 (37.757362292666, -122.396633751156) 10 3 8 28856 29
81035 194456 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 22nd St 12 Front Yard : Yard Tree Private 2     2     6013384.43791 2103815.09856 37.7574285843868 -122.396710957944 (37.7574285843868, -122.396710957944) 10 3 8 28856 29
29047 194457 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 32 Sidewalk: Property side : Yard Tree Private 2     30     6012708.71911 2101842.22219 37.7519738634013 -122.398909414543 (37.7519738634013, -122.398909414543) 10 3 8 28856 29
66190 194458 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 33 Sidewalk: Property side : Yard Tree Private 2     26     6012757.94703 2101850.0059 37.7519979787223 -122.398739722368 (37.7519979787223, -122.398739722368) 10 3 8 28856 29
166032 194459 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 34 Sidewalk: Property side : Yard Tree Private 2     24     6012781.55557 2101851.76257 37.7520041175184 -122.398658203327 (37.7520041175184, -122.398658203327) 10 3 8 28856 29
132354 194460 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 1 Sidewalk: Curb side : Yard Tree Private 2     24     6012680.82829 2101890.2153 37.7521040879384 -122.399009233909 (37.7521040879384, -122.399009233909) 10 3 8 28856 29
163675 194461 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 3 Sidewalk: Curb side : Yard Tree Private 2     27     6012563.25713 2101880.94422 37.7520720792617 -122.399415164477 (37.7520720792617, -122.399415164477) 10 3 8 28856 29
161957 194462 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 4 Sidewalk: Curb side : Yard Tree Private 2     25     6012536.20636 2101883.40971 37.7520773412124 -122.399508883748 (37.7520773412124, -122.399508883748) 10 3 8 28856 29
172636 194463 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 5 Sidewalk: Curb side : Yard Tree Private 2     18     6012509.33056 2101878.68569 37.7520628720051 -122.399601493222 (37.7520628720051, -122.399601493222) 10 3 8 28856 29
79719 194464 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 6 Sidewalk: Curb side : Yard Tree Private 2     16     6012478.49596 2101876.43729 37.7520549795584 -122.399707966672 (37.7520549795584, -122.399707966672) 10 3 8 28856 29
148743 194465 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 7 Sidewalk: Curb side : Yard Tree Private 2     23     6012451.33342 2101881.30035 37.7520668182527 -122.399802240798 (37.7520668182527, -122.399802240798) 10 3 8 28856 29
131381 194466 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 8 Sidewalk: Curb side : Yard Tree Private 2     25     6012435.9357 2101881.1338 37.7520655025415 -122.399855477046 (37.7520655025415, -122.399855477046) 10 3 8 28856 29
38402 194467 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Quint St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   6012416.6749 2095223.97206 37.7337852773717 -122.399454760738 (37.7337852773717, -122.399454760738) 10 3 8 58 1
137520 194468 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Quint St 5 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   6012422.70585 2095229.76642 37.7338015236278 -122.399434316464 (37.7338015236278, -122.399434316464) 10 3 8 58 1
97073 194469 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 981 Le Conte Ave 1 Sidewalk: Curb side : Yard Tree Private 2     29     6013175.32991 2089516.24763 37.7181552814285 -122.396431907321 (37.7181552814285, -122.396431907321) 10 3 8 58 1

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