2,306 rows where qSpecies_id = 15 sorted by qCaretaker_id

View and edit SQL

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)
22 262394 Significant Tree 6 Pinus radiata :: Monterey Pine 15 66 Cleary Ct 1 Sidewalk: Property side : Cutout Tree DPW 1   11/13/2020 12:00:00 AM 3 3x3   6004824 2113713 37.7841256623529 -122.427021325889 (37.7841256623529, -122.427021325889) 13 9 11 28858 41
161 194506 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 299x Cashmere St 26 Median : Yard Tree DPW 1     18     6016624.93937 2096021.78221 37.7362095654157 -122.384960961105 (37.7362095654157, -122.384960961105) 10 3 8 58 1
182 20628 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1492X Sunset Blvd 11 Median : Cutout Tree DPW 1     36 60   5984803.7392562 2105036.6950477 37.7591505890295 -122.495643037613 (37.7591505890295, -122.495643037613) 1 8 3 56 35
243 21365 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2592X Sunset Blvd 27 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985018.1742183 2097562.094386 37.7386399329486 -122.494350460592 (37.7386399329486, -122.494350460592) 1 8 3 29491 35
245 251484 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 900 Bosworth St 7 Front Yard : Yard Tree DPW 1           6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
289 211158 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 300x Marietta Dr 38 Median : Cutout Tree DPW 1     21 Width 5ft   5999457.51761 2097516.55077 37.7393493243992 -122.444422982731 (37.7393493243992, -122.444422982731) 9 7 4 59 40
306 20543 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1303X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1     36 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
342 115652 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 18 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
430 121151 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1X Payson St 1 Side Yard : Yard Tree DPW 1     25 3x3   5992041 2087761 37.7121370380572 -122.469355880776 (37.7121370380572, -122.469355880776) 9 8 4 64 24
689 119914 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 400X Brotherhood Way 1 Front Yard : Yard Tree DPW 1       100x100                      
815 20416 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 453X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
844 254210 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 300x Esmeralda Ave 20 Unaccepted Street : Yard Tree DPW 1                              
932 111099 Undocumented 4 Pinus radiata :: Monterey Pine 15 480X LAKESHORE DR 20 Median : Cutout Tree DPW 1       30x200   5984942 2095282 37.7323749444343 -122.494445798495 (37.7323749444343, -122.494445798495) 1 8 4 64 35
1144 20400 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 45 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
1176 119263 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 495X Lakeshore Dr 1 Median : Yard Tree DPW 1       10x30                      
1189 261265 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 5 Median : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
1378 95407 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2X Cranleigh Dr 9 Median : Yard Tree DPW 1     80     5991370.3 2095943.7 37.7345659248964 -122.472270103664 (37.7345659248964, -122.472270103664) 1 8 4 64 40
1531 20287 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
1886 20313 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
1982 20405 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 50 Sidewalk: Curb side : Cutout Tree DPW 1     6 60                      
2030 112443 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2199x 25TH ST 3 Sidewalk: Property side : Yard Tree DPW 1       3x3   6012503 2101856 37.7520002291367 -122.399621792735 (37.7520002291367, -122.399621792735) 10 3 8 28856 29
2194 261477 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 6 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
2568 20451 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 495X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
2808 261474 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 4 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
2812 19775 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY18 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 50ST                      
2845 21487 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2792X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     6 60   5985060.3629888 2096294.4798015 37.7351618711636 -122.49411119238 (37.7351618711636, -122.49411119238) 1 8 3 29491 35
2894 11190 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 140 Idora Ave 1 Median : Cutout Tree DPW 1     24 8   5995683.1150394 2099368.7198886 37.7442188444672 -122.457607088025 (37.7442188444672, -122.457607088025) 1 8 4 59 40
2907 194508 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 299x Cashmere St 28 Median : Yard Tree DPW 1     23     6016611.71691 2096022.49532 37.7362107920965 -122.385006726687 (37.7362107920965, -122.385006726687) 10 3 8 58 1
3000 20052 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY53 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 30                      
3106 20323 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
3149 21387 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2601X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     3 40   5985098.343425 2097506.3093477 37.7384914535226 -122.494069167367 (37.7384914535226, -122.494069167367) 1 8 3 29491 35
3197 261564 Undocumented 4 Pinus radiata :: Monterey Pine 15 1801 25th St 9 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
3269 178256 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 500x Mansell St 14 Median : Cutout Tree DPW 1     15 Width 0ft   6010359.75763 2090312.49843 37.7201845359677 -122.40622025079 (37.7201845359677, -122.40622025079) 10 3 8 309 28
3326 104499 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 44X SATURN ST 1 Median : Yard Tree DPW 1     18     6000456 2106003 37.7627079858093 -122.44157952537 (37.7627079858093, -122.44157952537) 15 5 5 28862 3
3639 20284 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
4038 20457 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 495X Sunset Blvd 22 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
4494 20293 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
4731 19749 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY15 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
4776 19969 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY43 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 15                      
5041 20311 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 50X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
5134 13416 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 442 Marietta Dr 1 Median : Cutout Tree DPW 1     6 5   5999568.3476194 2097073.0677048 37.7381379481581 -122.444007926391 (37.7381379481581, -122.444007926391) 9 7 4 59 40
5216 20045 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY52 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
5276 9649 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 420X Masonic Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   5999128.38767 2111347.91542 37.7773080410323 -122.446555809153 (37.7773080410323, -122.446555809153) 15 5 11 29492 16
5304 261473 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 3 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
5459 20942 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1992X Sunset Blvd 20 Sidewalk: Curb side : Cutout Tree DPW 1     42 60   5984875.9454268 2101638.8759791 37.7498253446275 -122.495142757654 (37.7498253446275, -122.495142757654) 1 8 3 29491 35
5888 261561 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1801 25th St 6 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
5905 261162 Significant Tree 6 Pinus radiata :: Monterey Pine 15 595 Newhall St 1 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   6016024 2097656 37.7406635379999 -122.387152626875 (37.7406635379999, -122.387152626875) 10 3 8 58 1
5980 113539 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100X CASHMERE ST 2 Median : Yard Tree DPW 1     20     6017054 2095889 37.7358686950692 -122.383468266853 (37.7358686950692, -122.383468266853) 10 3 8 58 1
6109 20338 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 25 Sidewalk: Curb side : Cutout Tree DPW 1     48 40                      
6239 261665 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 401X Greenwich St 1 Unaccepted Street : Cutout Tree DPW 1                              
6415 20399 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 44 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
6528 20289 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
6752 20418 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 453X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
6936 261840 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 10 Sidewalk: Property side : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
6984 20069 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY55 2 Sidewalk: Curb side : Cutout Tree DPW 1     36 40ST                      
7041 20329 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
7152 261481 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 10 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
7330 20367 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 17 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
7403 20408 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 53 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
7420 20458 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 495X Sunset Blvd 23 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
7693 4980 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 5200X Diamond Heights Blvd 16 Median : Cutout Tree DPW 1     36 12   6000724.3855206 2099633.2111664 37.7452333754909 -122.440194472866 (37.7452333754909, -122.440194472866) 2 7 5 63 7
8084 20421 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 453X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
8135 20290 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
8368 173917 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2160X 09th Ave 5 Median : Cutout Tree DPW 1       6x10   5993671 2100995 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698) 1 8 4 29491 40
8513 112444 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2199x 25TH ST 4 Sidewalk: Property side : Yard Tree DPW 1       3x3   6012503 2101856 37.7520002291367 -122.399621792735 (37.7520002291367, -122.399621792735) 10 3 8 28856 29
8660 20402 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 47 Sidewalk: Curb side : Cutout Tree DPW 1     48 60                      
8757 20337 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 24 Sidewalk: Curb side : Cutout Tree DPW 1     48 40                      
9033 254440 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 501X Brotherhood Way 20 Median : Yard Tree DPW 1       10x10   5992686 2087818 37.7123307991194 -122.467130733446 (37.7123307991194, -122.467130733446) 9 8 4 64 24
9066 260960 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1001 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
9087 20433 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 485X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
9165 20427 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 453X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
9285 20285 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
9341 20735 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1601X Sunset Blvd 22 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984865.3499442 2104298.7792234 37.7571280850658 -122.495375540207 (37.7571280850658, -122.495375540207) 1 8 3 56 35
9368 20394 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 262X Sunset Blvd 39 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
9667 20951 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1992X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5984875.9454268 2101638.8759791 37.7498253446275 -122.495142757654 (37.7498253446275, -122.495142757654) 1 8 3 29491 35
9819 261478 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 7 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
10032 254212 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 81X Elsie St 10 Back Yard : Yard Tree DPW 1                              
10141 211242 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 50x Santa Rita Ave 16 Median : Cutout Tree DPW 1     16 Width 5ft   5993561.81952 2100384.28411 37.7468852429767 -122.465015753384 (37.7468852429767, -122.465015753384) 1 8 4 29491 40
10142 20420 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 453X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
10428 4975 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 5200X Diamond Heights Blvd 11 Median : Cutout Tree DPW 1     12 12   6000932.35718 2099423.5316 37.744669483426 -122.439460315968 (37.744669483426, -122.439460315968) 2 7 5 63 7
10560 178279 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 900 Brotherhood Way 6 Front Yard : Yard Tree DPW 1     4 Width 0ft   5987917.15522 2088760.91322 37.7146433748779 -122.483682180705 (37.7146433748779, -122.483682180705) 1 8 4 64 14
10595 262051 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 851X Alemany Blvd 2 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
10821 4986 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 5300 Diamond Heights Blvd 3 Median : Cutout Tree DPW 1     12     6001419.5409281 2098992.5811716 37.7435139095193 -122.437744874344 (37.7435139095193, -122.437744874344) 2 7 5 63 7
11212 20461 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 495X Sunset Blvd 26 Sidewalk: Curb side : Cutout Tree DPW 1     6 60                      
11223 211225 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2270x 09th Ave 2 Median : Cutout Tree DPW 1     21 Width 3ft   5993181.98406 2100575.01172 37.7473870233022 -122.466343037597 (37.7473870233022, -122.466343037597) 1 8 4 29491 40
11436 20292 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
11490 20283 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 20X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
11544 20435 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 485X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 30                      
11693 261491 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 7 Sidewalk: Property side : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
11791 20943 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1992X Sunset Blvd 19 Median : Cutout Tree DPW 1     6 60   5984875.9454268 2101638.8759791 37.7498253446275 -122.495142757654 (37.7498253446275, -122.495142757654) 1 8 3 29491 35
11825 264757 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 176 Hahn St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007577 2087516 37.7123498887131 -122.4156414431 (37.7123498887131, -122.4156414431) 9 7 8 309 39
11834 261266 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1100X Portola Dr 6 Sidewalk: Property side : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
11955 20344 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 101X Sunset Blvd 30 Sidewalk: Curb side : Cutout Tree DPW 1     24 40                      
11962 19853 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 STAIRWAY29 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
11998 20308 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 50X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     48 60                      
12060 101900 Property Tree 8 Pinus radiata :: Monterey Pine 15 1100 Ocean Ave 1 Front Yard : Yard Tree DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
12112 20431 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 485X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     36 30                      
12163 21077 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2192X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree DPW 1     42 60   5984923.321673 2100279.0596028 37.7460944336033 -122.494878681905 (37.7460944336033, -122.494878681905) 1 8 3 29491 35
12253 261479 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1000 Portola Dr 8 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
12400 20426 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 453X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      

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