trees
438 rows where qSpecies_id = 63 sorted by TreeID descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61382 | 234515 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6010924.44859 | 2100544.92665 | 37.7483121900522 | -122.404988378323 | (37.7483121900522, -122.404988378323) | 2 | 7 | 7 | 28859 | 2 | |||
145433 | 234514 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 998 York St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 7ft | 6009944.54234 | 2103430.26244 | 37.7561798559202 | -122.408580392894 | (37.7561798559202, -122.408580392894) | 2 | 4 | 7 | 28859 | 19 | |||
186214 | 234513 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 998 York St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 6009942.57021 | 2103461.5506 | 37.7562656557487 | -122.408589420289 | (37.7562656557487, -122.408589420289) | 2 | 4 | 7 | 28859 | 19 | |||
161041 | 234512 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300 San Jose Ave | 61 | Front Yard : Yard | Tree | Private 2 | 12 | Width 6ft | 6003219.80457 | 2095456.80721 | 37.7339076867834 | -122.431267680974 | (37.7339076867834, -122.431267680974) | 2 | 7 | 5 | 63 | 7 | |||
62583 | 234511 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1300 San Jose Ave | 59 | Front Yard : Yard | Tree | Private 2 | 5 | Width 10ft | 6003237.34595 | 2095470.24367 | 37.7339455743229 | -122.431207993878 | (37.7339455743229, -122.431207993878) | 2 | 7 | 5 | 63 | 7 | |||
2154 | 234510 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1101 San Jose Ave | 20 | Front Yard : Yard | Tree | Private 2 | 15 | 6004874.94559 | 2096454.63294 | 37.7367411519672 | -122.425616344829 | (37.7367411519672, -122.425616344829) | 2 | 7 | 5 | 28859 | 2 | ||||
73422 | 234509 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1101 San Jose Ave | 9 | Front Yard : Yard | Tree | Private 2 | 25 | 6004750.38207 | 2096347.45133 | 37.7364398161369 | -122.426039387727 | (37.7364398161369, -122.426039387727) | 2 | 7 | 5 | 28859 | 2 | ||||
176495 | 234508 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 201 Coso Ave | 2 | Side Yard : Yard | Tree | Private 2 | 28 | Width 5ft | 6007691.39954 | 2099521.32268 | 37.745320345265 | -122.416095727735 | (37.745320345265, -122.416095727735) | 2 | 7 | 7 | 28859 | 2 | |||
187165 | 234507 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100 San Jose Ave | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 9ft | 6004787.92016 | 2096687.497 | 37.7373756263678 | -122.425933801003 | (37.7373756263678, -122.425933801003) | 2 | 7 | 5 | 63 | 7 | |||
148660 | 234506 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100 San Jose Ave | 8 | Front Yard : Yard | Tree | Private 2 | 24 | 6004826.97139 | 2096714.28402 | 37.737451384369 | -122.425800688759 | (37.737451384369, -122.425800688759) | 2 | 7 | 5 | 63 | 7 | ||||
119227 | 234505 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100 San Jose Ave | 7 | Front Yard : Yard | Tree | Private 2 | 16 | 6004841.55243 | 2096717.56088 | 37.7374612058616 | -122.425750508406 | (37.7374612058616, -122.425750508406) | 2 | 7 | 5 | 63 | 7 | ||||
105900 | 234504 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100 San Jose Ave | 5 | Front Yard : Yard | Tree | Private 2 | 16 | 6004845.11812 | 2096728.13188 | 37.7374904329363 | -122.425738932323 | (37.7374904329363, -122.425738932323) | 2 | 7 | 5 | 63 | 7 | ||||
19749 | 234503 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1000 San Jose Ave | 39 | Front Yard : Yard | Tree | Private 2 | 2 | 6005117.95051 | 2097175.77056 | 37.7387349615553 | -122.424827458621 | (37.7387349615553, -122.424827458621) | 2 | 7 | 5 | 63 | 7 | ||||
104488 | 234502 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 3502 24th St | 1 | Front Yard : Yard | Tree | Private 2 | 27 | 6006115.28896 | 2102029.42996 | 37.7521182909488 | -122.421723779538 | (37.7521182909488, -122.421723779538) | 2 | 4 | 5 | 28859 | 19 | ||||
164309 | 233330 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 4053 20th St | 9 | Front Yard : Yard | Tree | Private 2 | 16 | Width 3ft | 6003355.15759 | 2104159.05112 | 37.7578096927712 | -122.431420737491 | (37.7578096927712, -122.431420737491) | 2 | 4 | 5 | 28862 | 3 | |||
18973 | 233322 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 51 Prentiss St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008884.18383 | 2098343.89419 | 37.7421543791283 | -122.411888074199 | (37.7421543791283, -122.411888074199) | 10 | 7 | 7 | 28859 | 2 | |||
116365 | 2273 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 750X Brotherhood Way | 7 | Median : Cutout | Tree | DPW 1 | 35 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
134014 | 2272 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 750X Brotherhood Way | 6 | Median : Cutout | Tree | DPW 1 | 20 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
138520 | 22454 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 6155X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 40M | 6013523.9988031 | 2091160.9249677 | 37.722690633869 | -122.395341851189 | (37.722690633869, -122.395341851189) | 10 | 3 | 8 | 58 | 1 | |||
105788 | 218299 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1 Ardenwood Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 8ft | 5991311.90242 | 2096390.21304 | 37.7357885567818 | -122.472504543874 | (37.7357885567818, -122.472504543874) | 1 | 8 | 4 | 29491 | 40 | |||
20964 | 217820 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1x Junipero Serra Blvd | 7 | Median : Yard | Tree | DPW 1 | 3 | 5991627.31768 | 2095659.97546 | 37.7338017601455 | -122.471360849935 | (37.7338017601455, -122.471360849935) | 1 | 8 | 4 | 59 | 40 | ||||
140469 | 21312 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2501X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 35 | |||
38282 | 21135 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2292X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | ||||
74662 | 21131 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2292X Sunset Blvd | 4 | Median : Cutout | Tree | DPW 1 | 0 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | |||
170298 | 211082 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 843 Detroit St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 5999417.62854 | 2095618.00896 | 37.7341341018996 | -122.444424494503 | (37.7341341018996, -122.444424494503) | 9 | 7 | 4 | 59 | 40 | |||
136927 | 211081 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 90 Melrose Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5999513.42858 | 2095531.79881 | 37.7339028547188 | -122.444087092249 | (37.7339028547188, -122.444087092249) | 9 | 7 | 4 | 63 | 40 | |||
186578 | 211080 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 90 Melrose Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5999525.10685 | 2095532.7271 | 37.7339060697915 | -122.444046783738 | (37.7339060697915, -122.444046783738) | 9 | 7 | 4 | 63 | 40 | |||
28006 | 211079 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2319 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 3ft | 5992294.50858 | 2099658.84702 | 37.7448202223807 | -122.469345163475 | (37.7448202223807, -122.469345163475) | 1 | 8 | 4 | 29491 | 40 | |||
59640 | 211078 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 97 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 5994121.91269 | 2090532.87853 | 37.7198679898921 | -122.462364611346 | (37.7198679898921, -122.462364611346) | 9 | 8 | 6 | 28861 | 24 | |||
105224 | 211077 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 100x Idora Ave | 9 | Median : Yard | Tree | DPW 1 | 9 | Width 9ft | 5995433.61803 | 2099390.76131 | 37.7442650295015 | -122.458471384168 | (37.7442650295015, -122.458471384168) | 1 | 8 | 4 | 59 | 40 | |||
70780 | 211076 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 700x Miramar Ave | 2 | Median : Yard | Tree | DPW 1 | 74 | 5995394.80602 | 2094076.5012 | 37.7296711442905 | -122.458221033586 | (37.7296711442905, -122.458221033586) | 9 | 7 | 4 | 28861 | 40 | ||||
133 | 211075 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 650x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 34 | 5995390.83549 | 2093912.64173 | 37.7292209976493 | -122.458222905073 | (37.7292209976493, -122.458222905073) | 9 | 7 | 4 | 28861 | 40 | ||||
60529 | 211074 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 650x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 30 | 5995392.34643 | 2093881.33119 | 37.7291351132945 | -122.458215416413 | (37.7291351132945, -122.458215416413) | 9 | 7 | 4 | 28861 | 40 | ||||
28620 | 211073 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 602x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 26 | 5995385.83715 | 2093544.41078 | 37.7282096371561 | -122.458213544022 | (37.7282096371561, -122.458213544022) | 9 | 7 | 4 | 28861 | 40 | ||||
30931 | 211072 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 602x Miramar Ave | 2 | Median : Yard | Tree | DPW 1 | 35 | 5995382.34021 | 2093429.07469 | 37.7278927511259 | -122.458217288807 | (37.7278927511259, -122.458217288807) | 9 | 7 | 4 | 28861 | 40 | ||||
161389 | 211071 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 8 | Median : Yard | Tree | DPW 1 | 25 | 5995380.09454 | 2093218.25605 | 37.727313764897 | -122.458209800169 | (37.727313764897, -122.458209800169) | 9 | 7 | 4 | 28861 | 40 | ||||
12567 | 211070 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 7 | Median : Yard | Tree | DPW 1 | 24 | 5995378.92982 | 2093188.43217 | 37.7272318087773 | -122.458211668947 | (37.7272318087773, -122.458211668947) | 9 | 7 | 4 | 28861 | 40 | ||||
145613 | 211069 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 3 | Median : Yard | Tree | DPW 1 | 29 | 5995377.19569 | 2093059.06381 | 37.7268764947539 | -122.458208304568 | (37.7268764947539, -122.458208304568) | 9 | 7 | 4 | 28861 | 40 | ||||
50718 | 211068 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 1 | Median : Yard | Tree | DPW 1 | 35 | 5995376.89131 | 2092998.0023 | 37.7267088170477 | -122.4582049393 | (37.7267088170477, -122.4582049393) | 9 | 7 | 4 | 28861 | 40 | ||||
99546 | 211067 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 5 | Median : Yard | Tree | DPW 1 | 39 | 5995372.66361 | 2092795.985 | 37.7261538831809 | -122.458204939322 | (37.7261538831809, -122.458204939322) | 9 | 7 | 4 | 28861 | 40 | ||||
87097 | 211066 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 500x Miramar Ave | 2 | Median : Yard | Tree | DPW 1 | 36 | 5995372.70371 | 2092704.86629 | 37.7259036953978 | -122.458198208802 | (37.7259036953978, -122.458198208802) | 9 | 7 | 4 | 28861 | 40 | ||||
62980 | 211065 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 400x Miramar Ave | 1 | Median : Yard | Tree | DPW 1 | 25 | 5995367.47216 | 2092431.62053 | 37.7251531275117 | -122.458196526171 | (37.7251531275117, -122.458196526171) | 9 | 7 | 4 | 28861 | 40 | ||||
67798 | 211064 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 300x Miramar Ave | 3 | Median : Yard | Tree | DPW 1 | 35 | 5995363.79151 | 2092232.49572 | 37.7246061670234 | -122.458194844436 | (37.7246061670234, -122.458194844436) | 9 | 7 | 4 | 28861 | 40 | ||||
126413 | 211063 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 333 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 4ft | 5994231.86901 | 2100876.38212 | 37.7482750327754 | -122.462734494413 | (37.7482750327754, -122.462734494413) | 1 | 8 | 4 | 29491 | 40 | |||
60775 | 211062 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2088 15th Ave | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 33 | Width 6ft | 5991653.15073 | 2101238.7756 | 37.7491212147934 | -122.47167795089 | (37.7491212147934, -122.47167795089) | 1 | 8 | 4 | 29491 | 12 | |||
99356 | 211061 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2088 15th Ave | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 6ft | 5991650.04455 | 2101251.74063 | 37.7491566336932 | -122.47168963669 | (37.7491566336932, -122.47168963669) | 1 | 8 | 4 | 29491 | 12 | |||
48354 | 211060 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2088 15th Ave | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 6ft | 5991645.7062 | 2101259.684 | 37.7491781931242 | -122.471705217417 | (37.7491781931242, -122.471705217417) | 1 | 8 | 4 | 29491 | 12 | |||
98798 | 211059 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2088 15th Ave | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 6ft | 5991648.13538 | 2101268.04551 | 37.74920129221 | -122.471697426622 | (37.74920129221, -122.471697426622) | 1 | 8 | 4 | 29491 | 12 | |||
179563 | 211058 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 447 Lawton St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 3ft | 5992805.57319 | 2104540.3462 | 37.7582530810297 | -122.467933005722 | (37.7582530810297, -122.467933005722) | 1 | 8 | 4 | 56 | 12 | |||
74337 | 211057 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 447 Lawton St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 5992810.26786 | 2104540.37946 | 37.7582534434534 | -122.467916772063 | (37.7582534434534, -122.467916772063) | 1 | 8 | 4 | 56 | 12 | |||
118830 | 211056 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1600 17th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 5990908.64637 | 2104472.93122 | 37.7579582535812 | -122.474488420401 | (37.7579582535812, -122.474488420401) | 1 | 8 | 4 | 56 | 12 | ||||
85285 | 20978 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2002X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
41594 | 20767 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1692X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
77265 | 20512 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1211X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
111313 | 20511 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1211X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
13465 | 20460 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 495X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
50762 | 2044 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 700X Bosworth St | 1 | Front Yard : Cutout | Tree | DPW 1 | 36 | Permit Number 772999 | 6002154.6210393 | 2095431.8532492 | 37.7337787461998 | -122.434948555048 | (37.7337787461998, -122.434948555048) | 2 | 7 | 5 | 63 | 7 | |||
8061 | 20397 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 262X Sunset Blvd | 42 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
2047 | 20346 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 40 | |||||||||||||
14475 | 20345 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 40 | |||||||||||||
3556 | 20340 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | |||||||||||||
9886 | 20336 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
10520 | 20335 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
7308 | 20330 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
16263 | 20326 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
954 | 20324 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
12952 | 20300 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 50X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
191991 | 202090 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1 Gould St | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6012861.1738 | 2091181.83519 | 37.7227111623612 | -122.397634574298 | (37.7227111623612, -122.397634574298) | 10 | 3 | 8 | 58 | 1 | ||||
65486 | 201795 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 8ft | 6015420.28917 | 2088209.03426 | 37.7146906018698 | -122.388580780005 | (37.7146906018698, -122.388580780005) | 10 | 3 | 8 | 58 | 1 | |||
87306 | 201794 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6015439.96848 | 2088181.18977 | 37.7146152368657 | -122.388510817234 | (37.7146152368657, -122.388510817234) | 10 | 3 | 8 | 58 | 1 | |||
145724 | 201793 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015446.06267 | 2088163.05451 | 37.7145657786635 | -122.388488487967 | (37.7145657786635, -122.388488487967) | 10 | 3 | 8 | 58 | 1 | |||
12042 | 201792 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 8ft | 6015451.0989 | 2088156.51994 | 37.7145481150837 | -122.388470624731 | (37.7145481150837, -122.388470624731) | 10 | 3 | 8 | 58 | 1 | |||
160221 | 201791 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6015459.4491 | 2088143.48556 | 37.7145127879215 | -122.388440853585 | (37.7145127879215, -122.388440853585) | 10 | 3 | 8 | 58 | 1 | |||
90634 | 201790 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6015475.6761 | 2088115.28204 | 37.7144362457024 | -122.388382798743 | (37.7144362457024, -122.388382798743) | 10 | 3 | 8 | 58 | 1 | |||
192204 | 201789 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015483.87953 | 2088094.96024 | 37.7143809005356 | -122.388353026664 | (37.7143809005356, -122.388353026664) | 10 | 3 | 8 | 58 | 1 | |||
67974 | 201788 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6015494.63123 | 2088072.87111 | 37.7143208438162 | -122.388314323455 | (37.7143208438162, -122.388314323455) | 10 | 3 | 8 | 58 | 1 | |||
154751 | 201787 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 8ft | 6015507.5354 | 2088050.73887 | 37.7142607879799 | -122.388268177459 | (37.7142607879799, -122.388268177459) | 10 | 3 | 8 | 58 | 1 | |||
154803 | 201786 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6015524.34656 | 2088008.79963 | 37.714146562401 | -122.38820714586 | (37.714146562401, -122.38820714586) | 10 | 3 | 8 | 58 | 1 | |||
133522 | 201785 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6015530.91454 | 2087992.79913 | 37.7141029920284 | -122.388183328214 | (37.7141029920284, -122.388183328214) | 10 | 3 | 8 | 58 | 1 | |||
2009 | 201784 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015541.73553 | 2087974.13978 | 37.7140523566047 | -122.388144625001 | (37.7140523566047, -122.388144625001) | 10 | 3 | 8 | 58 | 1 | |||
84080 | 201783 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015549.05195 | 2087952.54872 | 37.7139934770858 | -122.388117830599 | (37.7139934770858, -122.388117830599) | 10 | 3 | 8 | 58 | 1 | |||
124322 | 201782 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015559.74323 | 2087927.45907 | 37.713925178088 | -122.388079127353 | (37.713925178088, -122.388079127353) | 10 | 3 | 8 | 58 | 1 | |||
96989 | 201781 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015573.4977 | 2087883.43723 | 37.713805064638 | -122.388028516222 | (37.713805064638, -122.388028516222) | 10 | 3 | 8 | 58 | 1 | |||
132708 | 201780 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015582.72471 | 2087849.79956 | 37.7137132132682 | -122.387994278123 | (37.7137132132682, -122.387994278123) | 10 | 3 | 8 | 58 | 1 | |||
187046 | 201779 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015589.3271 | 2087835.51364 | 37.7136743526627 | -122.387970461377 | (37.7136743526627, -122.387970461377) | 10 | 3 | 8 | 58 | 1 | |||
164947 | 201778 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 8ft | 6015594.19044 | 2087820.40535 | 37.7136331376383 | -122.387952598145 | (37.7136331376383, -122.387952598145) | 10 | 3 | 8 | 58 | 1 | |||
99536 | 201777 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6015601.56547 | 2087780.3718 | 37.7135236217889 | -122.387924315354 | (37.7135236217889, -122.387924315354) | 10 | 3 | 8 | 58 | 1 | |||
67122 | 201776 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6015607.24672 | 2087763.10237 | 37.7134765179931 | -122.387903474463 | (37.7134765179931, -122.387903474463) | 10 | 3 | 8 | 58 | 1 | |||
183877 | 201775 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015614.36786 | 2087706.44647 | 37.7133213462866 | -122.387874910195 | (37.7133213462866, -122.387874910195) | 10 | 3 | 8 | 58 | 1 | |||
182292 | 201774 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015625.88693 | 2087662.37118 | 37.7132009621398 | -122.38783202245 | (37.7132009621398, -122.38783202245) | 10 | 3 | 8 | 58 | 1 | |||
48450 | 201773 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015629.12317 | 2087652.01307 | 37.7131727000372 | -122.387820114508 | (37.7131727000372, -122.387820114508) | 10 | 3 | 8 | 58 | 1 | |||
188380 | 201772 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015630.59439 | 2087639.54626 | 37.7131385500726 | -122.387814160092 | (37.7131385500726, -122.387814160092) | 10 | 3 | 8 | 58 | 1 | |||
191105 | 201771 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6015632.38361 | 2087621.49757 | 37.7130890909533 | -122.387806717322 | (37.7130890909533, -122.387806717322) | 10 | 3 | 8 | 58 | 1 | |||
20635 | 201770 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015634.53236 | 2087578.56705 | 37.712971331023 | -122.387796296857 | (37.712971331023, -122.387796296857) | 10 | 3 | 8 | 58 | 1 | |||
114462 | 201769 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015636.77799 | 2087561.79601 | 37.7129254053659 | -122.387787365691 | (37.7129254053659, -122.387787365691) | 10 | 3 | 8 | 58 | 1 | |||
96403 | 201768 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015641.02933 | 2087537.69345 | 37.7128594598683 | -122.387770990859 | (37.7128594598683, -122.387770990859) | 10 | 3 | 8 | 58 | 1 | |||
106214 | 201767 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015642.29299 | 2087514.93769 | 37.7127970469199 | -122.387765036445 | (37.7127970469199, -122.387765036445) | 10 | 3 | 8 | 58 | 1 | |||
32167 | 201766 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015647.69731 | 2087483.94989 | 37.7127122597387 | -122.387744196458 | (37.7127122597387, -122.387744196458) | 10 | 3 | 8 | 58 | 1 | |||
171241 | 201765 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015652.50021 | 2087465.84041 | 37.7126628006338 | -122.387726333216 | (37.7126628006338, -122.387726333216) | 10 | 3 | 8 | 58 | 1 | |||
122823 | 201764 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015653.28128 | 2087440.52101 | 37.7125933216851 | -122.387721868094 | (37.7125933216851, -122.387721868094) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );