trees
953 rows where qSpecies_id = 60 sorted by PlotSize 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52807 | 123817 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1925 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992665.27685 | 2112027.39662 | 37.7788024241016 | -122.468963063439 | (37.7788024241016, -122.468963063439) | 11 | 6 | 2 | 54 | 11 | |||
| 52854 | 123824 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1665 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993487.5757 | 2112056.30859 | 37.7789292839599 | -122.466120533372 | (37.7789292839599, -122.466120533372) | 11 | 6 | 2 | 54 | 11 | |||
| 53393 | 188350 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Dukes Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6016183.29888 | 2096350.88685 | 37.7370887822104 | -122.386510848195 | (37.7370887822104, -122.386510848195) | 10 | 3 | 8 | 58 | 1 | |||
| 55247 | 124076 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 701 Funston Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991934.28865 | 2110305.99584 | 37.7740336644487 | -122.471366355947 | (37.7740336644487, -122.471366355947) | 11 | 6 | 2 | 54 | 11 | |||
| 55938 | 175783 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 771 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006465.53434 | 2093625.53998 | 37.7290628338846 | -122.419916279827 | (37.7290628338846, -122.419916279827) | 9 | 7 | 7 | 309 | 5 | |||
| 56097 | 188358 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1334 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017132.81962 | 2095655.66164 | 37.7352323503922 | -122.383179517428 | (37.7352323503922, -122.383179517428) | 10 | 3 | 8 | 58 | 1 | |||
| 57867 | 188291 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 40 Sheridan St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6009385.19996 | 2109515.63966 | 37.7728575647512 | -122.410944589137 | (37.7728575647512, -122.410944589137) | 8 | 2 | 9 | 28853 | 34 | |||
| 58302 | 188285 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 106 Langton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6010183.94442 | 2110713.51419 | 37.7761914064457 | -122.408266129292 | (37.7761914064457, -122.408266129292) | 8 | 2 | 9 | 28853 | 34 | |||
| 58533 | 222576 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 471 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003000.71138 | 2105505.41806 | 37.7614863982993 | -122.432742735495 | (37.7614863982993, -122.432742735495) | 15 | 4 | 5 | 28862 | 3 | |||
| 59817 | 221362 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1301 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001384.01408 | 2099859.31671 | 37.7458917403255 | -122.437929785824 | (37.7458917403255, -122.437929785824) | 2 | 4 | 5 | 63 | 22 | |||
| 60265 | 221323 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3517 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006097.76573 | 2104905.61236 | 37.7600146325834 | -122.421988676659 | (37.7600146325834, -122.421988676659) | 2 | 4 | 5 | 28859 | 19 | |||
| 60384 | 204655 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 452 Victoria St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5993265.60688 | 2090192.2995 | 37.7188834957636 | -122.465299811433 | (37.7188834957636, -122.465299811433) | 9 | 8 | 6 | 64 | 24 | |||
| 60641 | 204654 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 222 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992216.41936 | 2089361.24223 | 37.7165410523041 | -122.468865962403 | (37.7165410523041, -122.468865962403) | 9 | 8 | 6 | 64 | 24 | |||
| 60659 | 175761 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011060.579 | 2091989.46007 | 37.7248283040662 | -122.403915678669 | (37.7248283040662, -122.403915678669) | 10 | 3 | 7 | 309 | 28 | |||
| 60961 | 188300 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008269.7706 | 2109537.20803 | 37.7728541761188 | -122.41480452791 | (37.7728541761188, -122.41480452791) | 8 | 2 | 9 | 28853 | 34 | |||
| 62111 | 175778 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 281 Vienna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004138.17928 | 2091770.31166 | 37.7238373950554 | -122.427829991858 | (37.7238373950554, -122.427829991858) | 9 | 7 | 6 | 28861 | 5 | |||
| 63468 | 204661 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 218 Acadia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6001436.20899 | 2095068.95473 | 37.7327414936084 | -122.437406337246 | (37.7327414936084, -122.437406337246) | 9 | 7 | 5 | 63 | 40 | |||
| 64562 | 204644 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 150 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994179.89282 | 2090937.7889 | 37.7209831150476 | -122.462193545901 | (37.7209831150476, -122.462193545901) | 9 | 8 | 6 | 28861 | 24 | |||
| 65282 | 221342 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 211 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005048.208 | 2100165.37235 | 37.7469397877337 | -122.425281276331 | (37.7469397877337, -122.425281276331) | 2 | 7 | 5 | 63 | 22 | |||
| 65291 | 221359 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 188 Graystone Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999338.89083 | 2104005.40055 | 37.7571593642224 | -122.445299560921 | (37.7571593642224, -122.445299560921) | 2 | 5 | 5 | 28862 | 3 | |||
| 65937 | 188305 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 635 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015454.10981 | 2106058.18427 | 37.7637025904139 | -122.389709812266 | (37.7637025904139, -122.389709812266) | 14 | 3 | 8 | 28856 | 29 | |||
| 66237 | 175786 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008114.21781 | 2093492.54626 | 37.7287904076408 | -122.414207227876 | (37.7287904076408, -122.414207227876) | 9 | 3 | 7 | 309 | 28 | |||
| 66818 | 222545 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2825 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002444.04339 | 2095477.86439 | 37.7339215111673 | -122.43395122468 | (37.7339215111673, -122.43395122468) | 2 | 7 | 5 | 63 | 7 | |||
| 66946 | 188341 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2351 Silver Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6013156.07372 | 2096444.56636 | 37.7371779607887 | -122.396983972339 | (37.7371779607887, -122.396983972339) | 10 | 3 | 8 | 58 | 1 | |||
| 67207 | 188299 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1022 Minna St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6007530.78901 | 2109693.3141 | 37.7732412569071 | -122.417371822555 | (37.7732412569071, -122.417371822555) | 8 | 2 | 9 | 28853 | 19 | |||
| 68435 | 188303 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6008234.3659 | 2109502.33979 | 37.7727564467773 | -122.414924528938 | (37.7727564467773, -122.414924528938) | 8 | 2 | 9 | 28853 | 34 | |||
| 69275 | 253221 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 148 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6010428.10303 | 2093767.62468 | 37.7296754160783 | -122.406227307752 | (37.7296754160783, -122.406227307752) | 10 | 3 | 7 | 309 | 28 | ||||
| 69956 | 120687 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2040 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:45:00 PM | 3 | Width 3ft | 5989191.37637 | 2111280.32009 | 37.7765498370385 | -122.480925799615 | (37.7765498370385, -122.480925799615) | 11 | 6 | 2 | 55 | 26 | ||
| 70123 | 222500 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 150 Albion St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005885.57234 | 2106325.14441 | 37.7639003639399 | -122.422823438173 | (37.7639003639399, -122.422823438173) | 8 | 4 | 5 | 28859 | 19 | |||
| 70251 | 204641 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 290 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995679.43604 | 2091904.4278 | 37.7237235031239 | -122.457079989076 | (37.7237235031239, -122.457079989076) | 9 | 8 | 4 | 28861 | 24 | |||
| 70458 | 188315 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 850 Carolina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012418.40198 | 2104012.51765 | 37.7579168397997 | -122.400065779927 | (37.7579168397997, -122.400065779927) | 10 | 3 | 8 | 28856 | 29 | |||
| 71189 | 222566 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 115 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004480.72884 | 2096010.51075 | 37.7354994094663 | -122.426947702995 | (37.7354994094663, -122.426947702995) | 2 | 7 | 5 | 28861 | 2 | |||
| 73047 | 222544 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2885 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002432.22505 | 2095435.01424 | 37.7338031837708 | -122.433989022279 | (37.7338031837708, -122.433989022279) | 2 | 7 | 5 | 63 | 7 | |||
| 73918 | 222556 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 54 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007284.70429 | 2099159.83714 | 37.7443049117519 | -122.41747640203 | (37.7443049117519, -122.41747640203) | 2 | 7 | 7 | 28859 | 2 | |||
| 74871 | 222573 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3917 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003673.95782 | 2101843.15091 | 37.7514688410299 | -122.430152981203 | (37.7514688410299, -122.430152981203) | 2 | 4 | 5 | 28862 | 22 | |||
| 75051 | 175777 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 281 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004127.09808 | 2091752.98507 | 37.7237891931904 | -122.427867063726 | (37.7237891931904, -122.427867063726) | 9 | 7 | 6 | 28861 | 5 | |||
| 75078 | 125881 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2101 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001760.22052 | 2119747.88013 | 37.8005221579273 | -122.438053316704 | (37.8005221579273, -122.438053316704) | 13 | 9 | 1 | 57 | 17 | |||
| 75747 | 222553 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 184 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007213.79342 | 2097921.72013 | 37.740901328539 | -122.417633860722 | (37.740901328539, -122.417633860722) | 2 | 7 | 7 | 28859 | 2 | |||
| 76818 | 175756 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 837 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000844.62416 | 2089035.80235 | 37.7161421822999 | -122.439019362161 | (37.7161421822999, -122.439019362161) | 9 | 7 | 6 | 28861 | 5 | |||
| 77209 | 204658 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5994773.2638 | 2095284.74721 | 37.7329529584151 | -122.46045727068 | (37.7329529584151, -122.46045727068) | 9 | 8 | 4 | 59 | 40 | |||
| 77238 | 222551 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 192 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007190.09246 | 2097874.19927 | 37.7407695131158 | -122.4177124426 | (37.7407695131158, -122.4177124426) | 2 | 7 | 7 | 28859 | 2 | |||
| 77267 | 204643 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 290 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995381.41136 | 2092014.79797 | 37.7240094335681 | -122.458118187113 | (37.7240094335681, -122.458118187113) | 9 | 8 | 4 | 28861 | 24 | |||
| 77816 | 221364 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1243 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001375.81776 | 2100058.24789 | 37.7464374920934 | -122.437972374152 | (37.7464374920934, -122.437972374152) | 2 | 4 | 5 | 63 | 22 | |||
| 78470 | 222543 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 186 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004445.20895 | 2097256.60692 | 37.7389188989883 | -122.427159238823 | (37.7389188989883, -122.427159238823) | 2 | 7 | 5 | 63 | 7 | |||
| 80882 | 188322 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6012715.86863 | 2103660.87857 | 37.7569678967592 | -122.399012327554 | (37.7569678967592, -122.399012327554) | 10 | 3 | 8 | 28856 | 29 | |||
| 81149 | 221324 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006261.00789 | 2104075.99736 | 37.7577459083505 | -122.421365183881 | (37.7577459083505, -122.421365183881) | 2 | 4 | 5 | 28859 | 19 | |||
| 83011 | 221360 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 184 Graystone Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999311.90468 | 2104005.96159 | 37.7571593642225 | -122.445392929434 | (37.7571593642225, -122.445392929434) | 2 | 5 | 5 | 28862 | 3 | |||
| 83052 | 221352 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3181 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007731.91032 | 2102655.64405 | 37.7539287629142 | -122.416177589427 | (37.7539287629142, -122.416177589427) | 2 | 4 | 7 | 28859 | 19 | |||
| 85476 | 175760 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 885 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011559.50494 | 2090784.62511 | 37.7215479360666 | -122.402106275984 | (37.7215479360666, -122.402106275984) | 10 | 3 | 7 | 309 | 28 | |||
| 85568 | 222501 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 140 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005880.72851 | 2106423.94239 | 37.7641713665432 | -122.422847213547 | (37.7641713665432, -122.422847213547) | 8 | 4 | 5 | 28859 | 19 | |||
| 86565 | 221328 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 178 Peralta Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009834.37272 | 2100044.46783 | 37.7468770447458 | -122.408722547804 | (37.7468770447458, -122.408722547804) | 2 | 7 | 7 | 28859 | 2 | |||
| 86585 | 188289 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 40 Sheridan St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6009413.38466 | 2109546.86827 | 37.7729448916301 | -122.410849300561 | (37.7729448916301, -122.410849300561) | 8 | 2 | 9 | 28853 | 34 | |||
| 88808 | 222554 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 166 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007158.63327 | 2098165.90408 | 37.7415686992375 | -122.417841889206 | (37.7415686992375, -122.417841889206) | 2 | 7 | 7 | 28859 | 2 | |||
| 89469 | 221327 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 936 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6010186.18174 | 2103764.32859 | 37.7571106569582 | -122.407768272711 | (37.7571106569582, -122.407768272711) | 2 | 4 | 7 | 28859 | 19 | |||
| 89554 | 222560 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1409 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008015.99739 | 2099911.75152 | 37.7464106212529 | -122.415000947938 | (37.7464106212529, -122.415000947938) | 2 | 7 | 7 | 28859 | 2 | |||
| 91002 | 171137 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2424 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5999100.50151 | 2088972.29058 | 37.715868400781 | -122.445043298224 | (37.715868400781, -122.445043298224) | 9 | 7 | 6 | 28861 | 25 | |||
| 91061 | 188355 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1339 Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017230.94644 | 2095282.00984 | 37.7342117988404 | -122.38281425957 | (37.7342117988404, -122.38281425957) | 10 | 3 | 8 | 58 | 1 | |||
| 93313 | 221353 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3181 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007743.59292 | 2102655.40482 | 37.7539287629281 | -122.416137171192 | (37.7539287629281, -122.416137171192) | 2 | 4 | 7 | 28859 | 19 | |||
| 93788 | 222574 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 382 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003928.91308 | 2102165.887 | 37.7523694356007 | -122.429294326484 | (37.7523694356007, -122.429294326484) | 2 | 4 | 5 | 28862 | 22 | |||
| 94041 | 222575 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003870.03255 | 2102162.86972 | 37.7523578172736 | -122.429497729752 | (37.7523578172736, -122.429497729752) | 2 | 4 | 5 | 28862 | 22 | |||
| 94892 | 188302 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6008239.71976 | 2109507.11568 | 37.7727698610843 | -122.414906347362 | (37.7727698610843, -122.414906347362) | 8 | 2 | 9 | 28853 | 34 | |||
| 95200 | 221329 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 92 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010301.69617 | 2100286.438 | 37.7475676053645 | -122.407123632349 | (37.7475676053645, -122.407123632349) | 2 | 7 | 7 | 28859 | 2 | |||
| 95516 | 221322 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 76 Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005240.85494 | 2105024.43276 | 37.7602925195122 | -122.424960775029 | (37.7602925195122, -122.424960775029) | 2 | 4 | 5 | 28859 | 19 | |||
| 99241 | 222555 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 121 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006651.1877 | 2098952.76416 | 37.7437006698548 | -122.419652282953 | (37.7437006698548, -122.419652282953) | 2 | 7 | 7 | 28859 | 2 | |||
| 99370 | 171136 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2418 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5999120.62883 | 2088989.10518 | 37.7159157186008 | -122.444974937154 | (37.7159157186008, -122.444974937154) | 9 | 7 | 6 | 28861 | 25 | |||
| 99724 | 222590 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4486 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999473.95393 | 2105750.34682 | 37.7619582635881 | -122.444957897684 | (37.7619582635881, -122.444957897684) | 15 | 5 | 5 | 28862 | 3 | |||
| 100508 | 175764 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 325 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010619.03901 | 2092334.04764 | 37.7257497917057 | -122.405466295127 | (37.7257497917057, -122.405466295127) | 10 | 3 | 7 | 309 | 28 | |||
| 101323 | 188323 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6012718.59247 | 2103642.79546 | 37.7569183962771 | -122.399001638237 | (37.7569183962771, -122.399001638237) | 10 | 3 | 8 | 28856 | 29 | |||
| 101498 | 204672 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 370 Monterey Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999659.74264 | 2094714.76051 | 37.7316678047238 | -122.443522570705 | (37.7316678047238, -122.443522570705) | 9 | 7 | 4 | 63 | 40 | |||
| 101504 | 119916 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3801 Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5986867.20951 | 2111818.56024 | 37.7778923194923 | -122.489005232889 | (37.7778923194923, -122.489005232889) | 11 | 6 | 2 | 55 | 26 | |||
| 102359 | 204612 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5992412.91605 | 2102688.13741 | 37.7531447159591 | -122.469156169131 | (37.7531447159591, -122.469156169131) | 1 | 8 | 4 | 56 | 12 | |||
| 103196 | 222567 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 115 College Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004467.78746 | 2096013.76695 | 37.7355076184861 | -122.426992678096 | (37.7355076184861, -122.426992678096) | 2 | 7 | 5 | 28861 | 2 | |||
| 103448 | 118672 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4600 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 3ft | 5981237.2536 | 2110989.81786 | 37.7752866381156 | -122.508419343439 | (37.7752866381156, -122.508419343439) | 11 | 6 | 2 | 55 | 26 | ||
| 103736 | 188330 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 214 Texas St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6013707.23683 | 2106019.48516 | 37.7634993094715 | -122.395749036807 | (37.7634993094715, -122.395749036807) | 14 | 3 | 8 | 28856 | 29 | |||
| 104043 | 175776 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 281 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004111.17595 | 2091728.88242 | 37.7237221118835 | -122.427920387213 | (37.7237221118835, -122.427920387213) | 9 | 7 | 6 | 28861 | 5 | |||
| 105333 | 175775 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 17 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000241.49713 | 2093189.32696 | 37.7275124782167 | -122.441401917158 | (37.7275124782167, -122.441401917158) | 9 | 7 | 6 | 28861 | 25 | |||
| 106403 | 221358 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100 Berkeley Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000996.09085 | 2097469.17329 | 37.7393069033887 | -122.439099895546 | (37.7393069033887, -122.439099895546) | 2 | 7 | 5 | 63 | 7 | |||
| 108306 | 222581 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 193 Diamond St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6001755.3451 | 2104807.77266 | 37.7595001250595 | -122.436999987566 | (37.7595001250595, -122.436999987566) | 2 | 4 | 5 | 28862 | 3 | |||
| 108311 | 175779 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 302 Silver Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003783.14523 | 2093465.14379 | 37.7284709360627 | -122.429178076504 | (37.7284709360627, -122.429178076504) | 9 | 7 | 6 | 28861 | 5 | |||
| 108832 | 204650 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 254 Howth St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 5997292.00427 | 2090577.42476 | 37.7201723393547 | -122.451409977591 | (37.7201723393547, -122.451409977591) | 9 | 8 | 6 | 28861 | 24 | |||
| 109354 | 221345 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 152 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008640.31836 | 2097829.07218 | 37.74072710647 | -122.412694900948 | (37.74072710647, -122.412694900948) | 10 | 7 | 7 | 28859 | 2 | |||
| 110873 | 188301 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6008261.50029 | 2109526.90873 | 37.7728254319749 | -122.41483240691 | (37.7728254319749, -122.41483240691) | 8 | 2 | 9 | 28853 | 34 | |||
| 111154 | 188298 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1022 Minna St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6007537.97287 | 2109701.89036 | 37.7732652094644 | -122.41734758044 | (37.7732652094644, -122.41734758044) | 8 | 2 | 9 | 28853 | 19 | |||
| 111675 | 188287 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 106 Langton St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6010207.19158 | 2110684.55446 | 37.7761131915025 | -122.408183667747 | (37.7761131915025, -122.408183667747) | 8 | 2 | 9 | 28853 | 34 | |||
| 112897 | 188290 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 40 Sheridan St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6009398.69382 | 2109531.26602 | 37.7729012277415 | -122.410899015985 | (37.7729012277415, -122.410899015985) | 8 | 2 | 9 | 28853 | 34 | |||
| 112970 | 204624 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1830 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993464.78312 | 2103004.20884 | 37.7540732902536 | -122.465541593278 | (37.7540732902536, -122.465541593278) | 1 | 8 | 4 | 56 | 12 | |||
| 115467 | 175762 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011080.31201 | 2091995.56752 | 37.7248461762995 | -122.403847893187 | (37.7248461762995, -122.403847893187) | 10 | 3 | 7 | 309 | 28 | |||
| 116046 | 247045 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 596 Valley St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6002079.02681 | 2099155.53035 | 37.7439988068049 | -122.435476194275 | (37.7439988068049, -122.435476194275) | 2 | 7 | 5 | 63 | 22 | |||
| 117206 | 222584 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 374 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001130.45133 | 2104105.95648 | 37.7575375705211 | -122.439110874466 | (37.7575375705211, -122.439110874466) | 2 | 4 | 5 | 28862 | 38 | |||
| 117460 | 204623 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1880 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993786.05175 | 2102711.73048 | 37.7532887441949 | -122.464409343218 | (37.7532887441949, -122.464409343218) | 1 | 8 | 4 | 56 | 12 | |||
| 120254 | 222547 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 615 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007991.01103 | 2096013.86294 | 37.7357064756744 | -122.414811530923 | (37.7357064756744, -122.414811530923) | 2 | 7 | 7 | 28859 | 2 | |||
| 120418 | 222505 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3632 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005354.29828 | 2105491.73896 | 37.7615820394108 | -122.424601669449 | (37.7615820394108, -122.424601669449) | 8 | 4 | 5 | 28859 | 19 | |||
| 121399 | 188345 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2055 Silver Ave | 8 | : | Tree | Private 2 | 5 | Width 3ft | 6012515.97712 | 2096106.68244 | 37.7362145503607 | -122.399173381754 | (37.7362145503607, -122.399173381754) | 10 | 3 | 8 | 58 | 1 | |||
| 122856 | 222583 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 193 Diamond St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001753.50389 | 2104887.2031 | 37.7597181171131 | -122.43701204208 | (37.7597181171131, -122.43701204208) | 2 | 4 | 5 | 28862 | 3 | |||
| 123431 | 188320 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6012714.93717 | 2103702.00953 | 37.7570807814757 | -122.399018435778 | (37.7570807814757, -122.399018435778) | 10 | 3 | 8 | 28856 | 29 | |||
| 123566 | 222592 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 352 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003592.38415 | 2108668.42769 | 37.7702047958459 | -122.430922129977 | (37.7702047958459, -122.430922129977) | 15 | 9 | 11 | 29492 | 10 | |||
| 126754 | 222558 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 28 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007156.30356 | 2099319.03484 | 37.7447348074641 | -122.417931668505 | (37.7447348074641, -122.417931668505) | 2 | 7 | 7 | 28859 | 2 | |||
| 128662 | 221351 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 Sycamore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006363.61838 | 2105832.54053 | 37.7625747506491 | -122.421135037456 | (37.7625747506491, -122.421135037456) | 8 | 4 | 7 | 28859 | 19 | |||
| 131085 | 222562 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 190 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007642.65731 | 2100277.00661 | 37.7473925433497 | -122.416317784757 | (37.7473925433497, -122.416317784757) | 2 | 7 | 7 | 28859 | 2 | |||
| 132242 | 222548 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 191 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007220.93745 | 2097850.24968 | 37.7407054885677 | -122.417604094958 | (37.7407054885677, -122.417604094958) | 2 | 7 | 7 | 28859 | 2 |
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) );