trees
3,267 rows where qSpecies_id = 67 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5340 | 247013 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Valley St | 3 | : | Tree | Private 2 | 14 | Width 3ft | 6002616.04169 | 2099183.02337 | 37.7441047811073 | -122.433621285011 | (37.7441047811073, -122.433621285011) | 2 | 7 | 5 | 63 | 22 | |||
| 9444 | 205868 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Lakeview Ave | 1 | : | Tree | Private 2 | 11/04/1969 12:00:00 AM | 13 | Width 3ft | Permit Number 6398 | 5996845.79725 | 2089640.92362 | 37.7175753652817 | -122.452884796511 | (37.7175753652817, -122.452884796511) | 9 | 8 | 6 | 28861 | 24 | |
| 13010 | 247253 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6000028.37595 | 2108519.10482 | 37.7695922091358 | -122.443239243804 | (37.7695922091358, -122.443239243804) | 15 | 5 | 11 | 29492 | 9 | |||
| 14853 | 188956 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1706 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014961.30392 | 2096622.74747 | 37.7377675329349 | -122.390754864938 | (37.7377675329349, -122.390754864938) | 10 | 3 | 8 | 58 | 1 | |||
| 15917 | 247048 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6002432.31725 | 2099137.61339 | 37.7439696696596 | -122.434253316852 | (37.7439696696596, -122.434253316852) | 2 | 7 | 5 | 63 | 22 | |||
| 16361 | 188907 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1551 19th St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6013010.92349 | 2105173.17566 | 37.7611367706692 | -122.398098002138 | (37.7611367706692, -122.398098002138) | 10 | 3 | 8 | 28856 | 29 | |||
| 17030 | 220770 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Pearl St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6005613.92059 | 2108688.47135 | 37.7703741651755 | -122.423931067487 | (37.7703741651755, -122.423931067487) | 8 | 2 | 5 | 28853 | 19 | |||
| 17440 | 188953 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1723 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014879.29111 | 2096612.07207 | 37.7377336698595 | -122.391037679267 | (37.7377336698595, -122.391037679267) | 10 | 3 | 8 | 58 | 1 | |||
| 19471 | 188996 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1770 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014669.28207 | 2096840.44612 | 37.7383490822538 | -122.391779751256 | (37.7383490822538, -122.391779751256) | 10 | 3 | 8 | 58 | 1 | |||
| 20625 | 188952 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014856.84284 | 2096629.67768 | 37.7377807655571 | -122.391116524617 | (37.7377807655571, -122.391116524617) | 10 | 3 | 8 | 58 | 1 | |||
| 23330 | 188972 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 55 Vesta St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6012266.05718 | 2094101.57422 | 37.7306950098702 | -122.399896704685 | (37.7306950098702, -122.399896704685) | 10 | 3 | 8 | 58 | 1 | |||
| 23515 | 188900 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1336 20th St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6013884.30991 | 2104803.71969 | 37.7601709320582 | -122.395051432701 | (37.7601709320582, -122.395051432701) | 10 | 3 | 8 | 28856 | 29 | |||
| 23517 | 189018 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1711 La Salle Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014940.20739 | 2096568.46333 | 37.7376173092958 | -122.390824013816 | (37.7376173092958, -122.390824013816) | 10 | 3 | 8 | 58 | 1 | |||
| 24787 | 188993 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Topeka Ave | 3 | : | Tree | Private 2 | 15 | Width 3ft | 6012747.96084 | 2095104.27422 | 37.7334750715082 | -122.398301003391 | (37.7334750715082, -122.398301003391) | 10 | 3 | 8 | 58 | 1 | |||
| 24875 | 205662 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1598 10th Ave | 12 | : | Tree | Private 2 | 13 | Width 2ft | 5993106.37013 | 2104709.96458 | 37.7587361743455 | -122.466905058137 | (37.7587361743455, -122.466905058137) | 1 | 8 | 4 | 56 | 12 | |||
| 25457 | 189004 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1743 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014780.96102 | 2096683.31962 | 37.7379238441057 | -122.391382635804 | (37.7379238441057, -122.391382635804) | 10 | 3 | 8 | 58 | 1 | |||
| 28281 | 250792 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 290 32nd Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5985918.61873 | 2113977.26033 | 37.7837640802965 | -122.492445705309 | (37.7837640802965, -122.492445705309) | 11 | 6 | 1 | 55 | 33 | |||
| 28379 | 188948 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1747 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014759.80068 | 2096701.45444 | 37.7379724641572 | -122.391457065516 | (37.7379724641572, -122.391457065516) | 10 | 3 | 8 | 58 | 1 | |||
| 29278 | 188994 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1791 La Salle Ave | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6014563.36259 | 2096847.51308 | 37.7383626062416 | -122.392146465983 | (37.7383626062416, -122.392146465983) | 10 | 3 | 8 | 58 | 1 | |||
| 29471 | 246937 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 Frederick St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5998522.81883 | 2107568.5127 | 37.7668961594508 | -122.448378425024 | (37.7668961594508, -122.448378425024) | 15 | 5 | 11 | 29492 | 9 | |||
| 33420 | 175639 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 28 De Long St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5995095.5192 | 2086815.41001 | 37.7097167133235 | -122.458730228841 | (37.7097167133235, -122.458730228841) | 9 | 8 | 6 | 28861 | 25 | |||
| 35388 | 188957 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1708 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014940.68574 | 2096639.31184 | 37.7378118713318 | -122.390827309835 | (37.7378118713318, -122.390827309835) | 10 | 3 | 8 | 58 | 1 | |||
| 36390 | 188977 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Thomas Ave | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6012688.07294 | 2095454.36579 | 37.7344330140672 | -122.398532612087 | (37.7344330140672, -122.398532612087) | 10 | 3 | 8 | 58 | 1 | |||
| 37109 | 188963 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1742 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014798.75794 | 2096747.77521 | 37.7381018136532 | -122.39132560709 | (37.7381018136532, -122.39132560709) | 10 | 3 | 8 | 58 | 1 | |||
| 38467 | 204378 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Ramsell St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992980.7825 | 2088221.20971 | 37.7134549279767 | -122.466141167706 | (37.7134549279767, -122.466141167706) | 9 | 8 | 6 | 64 | 24 | |||
| 39679 | 188951 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1735 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014820.98612 | 2096656.00943 | 37.7378510772752 | -122.391242339775 | (37.7378510772752, -122.391242339775) | 10 | 3 | 8 | 58 | 1 | |||
| 40945 | 205664 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1598 10th Ave | 15 | : | Tree | Private 2 | 10 | Width 2ft | 5993105.62585 | 2104716.92689 | 37.7587552480768 | -122.466908138321 | (37.7587552480768, -122.466908138321) | 1 | 8 | 4 | 56 | 12 | |||
| 41031 | 188980 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 77 Robblee Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012410.68844 | 2095820.65993 | 37.7354233241252 | -122.399517335579 | (37.7354233241252, -122.399517335579) | 10 | 3 | 8 | 58 | 1 | |||
| 41536 | 204380 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 64 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992207.49196 | 2088316.25633 | 37.713671258107 | -122.468820820922 | (37.713671258107, -122.468820820922) | 9 | 8 | 6 | 64 | 24 | |||
| 41896 | 204368 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 504 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993515.00932 | 2089252.8539 | 37.7163183837543 | -122.464369561706 | (37.7163183837543, -122.464369561706) | 9 | 8 | 6 | 64 | 24 | |||
| 42299 | 222229 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 8 Aquavista Way | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5998081.93369 | 2101924.01441 | 37.7513725632107 | -122.44949661419 | (37.7513725632107, -122.44949661419) | 1 | 5 | 4 | 63 | 38 | |||
| 43012 | 247519 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 5 | : | Tree | Private 2 | 10 | Width 3ft | 6000008.96236 | 2108515.32213 | 37.7695807157979 | -122.443306122774 | (37.7695807157979, -122.443306122774) | 15 | 5 | 11 | 29492 | 9 | |||
| 43554 | 188898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 801 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012769.9943 | 2103729.94433 | 37.7571605522208 | -122.39882998641 | (37.7571605522208, -122.39882998641) | 10 | 3 | 8 | 28856 | 29 | |||
| 47223 | 247252 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6000037.64512 | 2108520.16776 | 37.7695956562448 | -122.443207258529 | (37.7695956562448, -122.443207258529) | 15 | 5 | 11 | 29492 | 9 | |||
| 47567 | 220771 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 Webster St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6004135.7148 | 2109869.98632 | 37.7735347533659 | -122.429128439333 | (37.7735347533659, -122.429128439333) | 7 | 9 | 11 | 29492 | 10 | |||
| 49085 | 204374 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 546 Head St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993518.36116 | 2089503.4985 | 37.7170067869068 | -122.46437616365 | (37.7170067869068, -122.46437616365) | 9 | 8 | 6 | 64 | 24 | |||
| 49535 | 188849 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1112 Harrison St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6010631.69356 | 2110389.62029 | 37.7753271309641 | -122.406694404849 | (37.7753271309641, -122.406694404849) | 8 | 2 | 9 | 28853 | 34 | |||
| 52325 | 220773 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2800 Mariposa St | 2 | : | Tree | Private 2 | 11 | Width 4ft | 6009163.19506 | 2105934.0417 | 37.7630108741738 | -122.41145945011 | (37.7630108741738, -122.41145945011) | 8 | 4 | 7 | 28859 | 19 | |||
| 52823 | 188962 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1738 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014828.18654 | 2096725.40837 | 37.7380420321219 | -122.39122229388 | (37.7380420321219, -122.39122229388) | 10 | 3 | 8 | 58 | 1 | |||
| 54291 | 250780 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 267 32nd Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5985869.60841 | 2114147.39692 | 37.7842283606933 | -122.492627794654 | (37.7842283606933, -122.492627794654) | 11 | 6 | 1 | 55 | 33 | |||
| 58042 | 247047 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6002401.43844 | 2099135.75495 | 37.7439628141295 | -122.434359955762 | (37.7439628141295, -122.434359955762) | 2 | 7 | 5 | 63 | 22 | |||
| 58444 | 247054 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 501 Valley St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6002623.07266 | 2099147.15401 | 37.7440066911524 | -122.433594410547 | (37.7440066911524, -122.433594410547) | 2 | 7 | 5 | 63 | 22 | |||
| 59291 | 204365 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 294 Ramsell St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992993.26737 | 2089135.18818 | 37.715965213689 | -122.46616439447 | (37.715965213689, -122.46616439447) | 9 | 8 | 6 | 64 | 24 | |||
| 63918 | 189005 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1746 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014786.72658 | 2096751.06079 | 37.7381101674427 | -122.391367435462 | (37.7381101674427, -122.391367435462) | 10 | 3 | 8 | 58 | 1 | |||
| 65908 | 189009 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1738 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014827.845 | 2096719.03701 | 37.7380245187208 | -122.391223029525 | (37.7380245187208, -122.391223029525) | 10 | 3 | 8 | 58 | 1 | |||
| 66194 | 188905 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 390 19th St | 4 | : | Tree | Private 2 | 13 | Width 3ft | 6013268.70779 | 2105235.79503 | 37.7613230643314 | -122.397210821847 | (37.7613230643314, -122.397210821847) | 10 | 3 | 8 | 28856 | 29 | |||
| 66369 | 188856 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 355 11th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6008743.51462 | 2108952.72037 | 37.7712759171908 | -122.413124449536 | (37.7712759171908, -122.413124449536) | 8 | 2 | 9 | 28853 | 34 | |||
| 66469 | 189008 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1735 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014822.13481 | 2096654.03054 | 37.7378457073978 | -122.391238229874 | (37.7378457073978, -122.391238229874) | 10 | 3 | 8 | 58 | 1 | |||
| 67067 | 246485 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 342 Duncan St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6004030.83293 | 2099862.05053 | 37.7460494067509 | -122.428777647976 | (37.7460494067509, -122.428777647976) | 2 | 7 | 5 | 63 | 22 | |||
| 67730 | 189006 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1742 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014800.84328 | 2096742.56697 | 37.73808762863 | -122.391318032994 | (37.73808762863, -122.391318032994) | 10 | 3 | 8 | 58 | 1 | |||
| 67920 | 188974 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1901 Quint St | 4 | : | Tree | Private 2 | 10 | Width 3ft | 6012413.00879 | 2095230.70151 | 37.7338035506988 | -122.39946790794 | (37.7338035506988, -122.39946790794) | 10 | 3 | 8 | 58 | 1 | |||
| 68437 | 250783 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 273 32nd Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5985872.78396 | 2114090.54911 | 37.7840724587071 | -122.492612620392 | (37.7840724587071, -122.492612620392) | 11 | 6 | 1 | 55 | 33 | |||
| 68671 | 125804 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3711 Fillmore St | 6 | : | Tree | Private 2 | 5 | Width 3ft | 6002009.77145 | 2121217.59748 | 37.804571802419 | -122.437295066808 | (37.804571802419, -122.437295066808) | 13 | 9 | 1 | 57 | 17 | |||
| 69465 | 188999 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1762 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014713.69596 | 2096808.35553 | 37.7382634335195 | -122.391623945508 | (37.7382634335195, -122.391623945508) | 10 | 3 | 8 | 58 | 1 | |||
| 71598 | 250071 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1520 Gough St | 3 | : | Tree | Private 2 | 9 | Width 4ft | 6005405.66402 | 2115050.94063 | 37.7878321887404 | -122.425104206101 | (37.7878321887404, -122.425104206101) | 13 | 9 | 1 | 28858 | 41 | |||
| 71825 | 125803 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3711 Fillmore St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6002008.1217 | 2121228.27649 | 37.8046010303654 | -122.43730154104 | (37.8046010303654, -122.43730154104) | 13 | 9 | 1 | 57 | 17 | |||
| 74252 | 188958 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1710 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014921.65166 | 2096653.12278 | 37.7378487372257 | -122.390894085388 | (37.7378487372257, -122.390894085388) | 10 | 3 | 8 | 58 | 1 | |||
| 74342 | 188971 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1763 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014673.94986 | 2096765.72011 | 37.7381441591176 | -122.391758388748 | (37.7381441591176, -122.391758388748) | 10 | 3 | 8 | 58 | 1 | |||
| 74579 | 204361 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 251 Ralston St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5992186.2665 | 2089542.38653 | 37.7170366884615 | -122.468983359893 | (37.7170366884615, -122.468983359893) | 9 | 8 | 6 | 64 | 24 | |||
| 77585 | 188975 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1901 Quint St | 6 | : | Tree | Private 2 | 10 | Width 1ft | 6012428.39873 | 2095250.09643 | 37.7338576629061 | -122.399416061108 | (37.7338576629061, -122.399416061108) | 10 | 3 | 8 | 58 | 1 | |||
| 79104 | 188968 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1770 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014669.82562 | 2096841.0987 | 37.7383509042781 | -122.391777917528 | (37.7383509042781, -122.391777917528) | 10 | 3 | 8 | 58 | 1 | |||
| 79620 | 247251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6000047.76346 | 2108521.63198 | 37.7696002535789 | -122.443172364836 | (37.7696002535789, -122.443172364836) | 15 | 5 | 11 | 29492 | 9 | |||
| 79893 | 188955 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1711 La Salle Ave | 1 | : | Tree | Private 2 | 8 | Width 1ft | 6014937.85326 | 2096568.85447 | 37.737618252668 | -122.390832180559 | (37.737618252668, -122.390832180559) | 10 | 3 | 8 | 58 | 1 | |||
| 83513 | 188981 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Robblee Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6012603.96331 | 2095970.26137 | 37.7358448696291 | -122.398859603804 | (37.7358448696291, -122.398859603804) | 10 | 3 | 8 | 58 | 1 | |||
| 84111 | 188960 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1728 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 1ft | 6014895.27133 | 2096673.06939 | 37.7379020427381 | -122.390986689509 | (37.7379020427381, -122.390986689509) | 10 | 3 | 8 | 58 | 1 | |||
| 84725 | 188940 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2225 Jerrold Ave | 2 | : | Tree | Private 2 | 12 | Width 2ft | 6012204.04277 | 2099300.38228 | 37.7449663847043 | -122.400476139687 | (37.7449663847043, -122.400476139687) | 10 | 3 | 8 | 58 | 1 | |||
| 85199 | 188855 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Heron St | 3 | : | Tree | Private 2 | 11 | Width 2ft | 6010012.0343 | 2110035.42428 | 37.77431990198 | -122.408812964744 | (37.77431990198, -122.408812964744) | 8 | 2 | 9 | 28853 | 34 | |||
| 85739 | 222230 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 8 Aquavista Way | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5998088.24008 | 2101938.03895 | 37.7514114319011 | -122.449475816475 | (37.7514114319011, -122.449475816475) | 1 | 5 | 4 | 63 | 38 | |||
| 85794 | 204369 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 527 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993483.16274 | 2089373.74444 | 37.7166484844088 | -122.464488410726 | (37.7166484844088, -122.464488410726) | 9 | 8 | 6 | 64 | 24 | |||
| 86570 | 204390 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Junipero Serra Blvd | 94 | : | Tree | Private 2 | 5 | Width 0ft | 5991146.57188 | 2090545.43725 | 37.7197306930948 | -122.472650140495 | (37.7197306930948, -122.472650140495) | 9 | 8 | 4 | 64 | 40 | |||
| 87723 | 188909 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 Mississippi St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6014064.59876 | 2105675.24732 | 37.7625739808237 | -122.394488921123 | (37.7625739808237, -122.394488921123) | 10 | 3 | 8 | 28856 | 29 | |||
| 88171 | 188949 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1743 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014778.43205 | 2096687.06655 | 37.7379339920459 | -122.391391641629 | (37.7379339920459, -122.391391641629) | 10 | 3 | 8 | 58 | 1 | |||
| 89129 | 188970 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1767 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014660.08395 | 2096773.80214 | 37.7381655809769 | -122.391806895488 | (37.7381655809769, -122.391806895488) | 10 | 3 | 8 | 58 | 1 | |||
| 91252 | 189003 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1747 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014760.40732 | 2096699.60508 | 37.7379674198647 | -122.391454838795 | (37.7379674198647, -122.391454838795) | 10 | 3 | 8 | 58 | 1 | |||
| 91457 | 204373 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 543 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993483.88652 | 2089481.01504 | 37.7169430654519 | -122.46449369334 | (37.7169430654519, -122.46449369334) | 9 | 8 | 6 | 64 | 24 | |||
| 93070 | 189015 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1710 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014923.18832 | 2096650.89402 | 37.7378427027714 | -122.390888616642 | (37.7378427027714, -122.390888616642) | 10 | 3 | 8 | 58 | 1 | |||
| 93354 | 188969 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1778 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014628.04346 | 2096874.23861 | 37.7384395801299 | -122.391924697674 | (37.7384395801299, -122.391924697674) | 10 | 3 | 8 | 58 | 1 | |||
| 93976 | 188965 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1754 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014743.47747 | 2096789.17091 | 37.7382124095618 | -122.391519634049 | (37.7382124095618, -122.391519634049) | 10 | 3 | 8 | 58 | 1 | |||
| 94346 | 188852 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 397 08th St | 2 | : | Tree | Private 2 | 22 | Width 3ft | 6010041.33013 | 2109925.85439 | 37.77402068943 | -122.408703893195 | (37.77402068943, -122.408703893195) | 8 | 2 | 9 | 28853 | 34 | |||
| 94945 | 205660 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1598 10th Ave | 9 | : | Tree | Private 2 | 5 | Width 2ft | 5993107.07403 | 2104701.08149 | 37.7587118243221 | -122.46690197797 | (37.7587118243221, -122.46690197797) | 1 | 8 | 4 | 56 | 12 | |||
| 95653 | 204370 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 531 Head St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993483.30762 | 2089398.8506 | 37.7167174282511 | -122.464489731835 | (37.7167174282511, -122.464489731835) | 9 | 8 | 6 | 64 | 24 | |||
| 98115 | 204376 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 567 Head St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5993486.95229 | 2089627.04139 | 37.7173441954665 | -122.464493693328 | (37.7173441954665, -122.464493693328) | 9 | 8 | 6 | 64 | 24 | |||
| 100192 | 188979 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Thomas Ave | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6012664.04998 | 2095467.26552 | 37.7344670956772 | -122.398616572822 | (37.7344670956772, -122.398616572822) | 10 | 3 | 8 | 58 | 1 | |||
| 100256 | 189013 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1728 La Salle Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6014896.64739 | 2096670.03652 | 37.7378937914553 | -122.390981719843 | (37.7378937914553, -122.390981719843) | 10 | 3 | 8 | 58 | 1 | |||
| 104028 | 188893 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 721 Wisconsin St | 1 | : | Tree | Private 2 | 12 | Width 1ft | 6012746.65722 | 2104146.94793 | 37.7583042524484 | -122.398939962706 | (37.7583042524484, -122.398939962706) | 10 | 3 | 8 | 28856 | 29 | |||
| 104418 | 188961 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1734 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014842.71506 | 2096714.04694 | 37.7380116422333 | -122.391171267237 | (37.7380116422333, -122.391171267237) | 10 | 3 | 8 | 58 | 1 | |||
| 104803 | 247015 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Valley St | 7 | : | Tree | Private 2 | 10 | Width 3ft | 6002564.17564 | 2099179.51077 | 37.7440921933056 | -122.4338003751 | (37.7440921933056, -122.4338003751) | 2 | 7 | 5 | 63 | 22 | |||
| 105587 | 205658 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1598 10th Ave | 6 | : | Tree | Private 2 | 9 | Width 2ft | 5993107.26748 | 2104689.10541 | 37.7586789522928 | -122.466900438308 | (37.7586789522928, -122.466900438308) | 1 | 8 | 4 | 56 | 12 | |||
| 108915 | 250786 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 276 32nd Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5985914.65421 | 2114070.62696 | 37.7840202063211 | -122.492466298901 | (37.7840202063211, -122.492466298901) | 11 | 6 | 1 | 55 | 33 | |||
| 109238 | 188851 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 397 08th St | 1 | : | Tree | Private 2 | 22 | Width 3ft | 6010057.61121 | 2109905.66708 | 37.7739661716411 | -122.408646149513 | (37.7739661716411, -122.408646149513) | 8 | 2 | 9 | 28853 | 34 | |||
| 109951 | 204371 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 535 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993483.80262 | 2089422.42802 | 37.7167821947225 | -122.464489731828 | (37.7167821947225, -122.464489731828) | 9 | 8 | 6 | 64 | 24 | |||
| 110308 | 188899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 801 Wisconsin St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012769.67955 | 2103741.86982 | 37.7571932794713 | -122.398831911879 | (37.7571932794713, -122.398831911879) | 10 | 3 | 8 | 28856 | 29 | |||
| 110405 | 188904 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 450 Missouri St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6013484.89022 | 2104980.58732 | 37.7606343527251 | -122.396445243359 | (37.7606343527251, -122.396445243359) | 10 | 3 | 8 | 28856 | 29 | |||
| 113365 | 204372 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 538 Head St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993517.68116 | 2089452.91347 | 37.7168678533586 | -122.464374843447 | (37.7168678533586, -122.464374843447) | 9 | 8 | 6 | 64 | 24 | |||
| 115173 | 188966 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1758 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014724.06467 | 2096802.26386 | 37.7382472825865 | -122.391587669559 | (37.7382472825865, -122.391587669559) | 10 | 3 | 8 | 58 | 1 | |||
| 115216 | 188947 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1751 La Salle Ave | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6014734.22474 | 2096720.3313 | 37.7380228765606 | -122.391546814229 | (37.7380228765606, -122.391546814229) | 10 | 3 | 8 | 58 | 1 | |||
| 115322 | 188897 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 837 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 4ft | 6012777.55941 | 2103554.05206 | 37.7566780119987 | -122.398791479242 | (37.7566780119987, -122.398791479242) | 10 | 3 | 8 | 28856 | 29 | |||
| 119061 | 205870 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 27 Lakeview Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5997419.74541 | 2089183.01907 | 37.7163509392228 | -122.450867930105 | (37.7163509392228, -122.450867930105) | 9 | 8 | 6 | 28861 | 24 | |||
| 119162 | 220774 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2800 Mariposa St | 5 | : | Tree | Private 2 | 15 | Width 3ft | 6009090.09562 | 2105931.65448 | 37.7630002190167 | -122.411712108343 | (37.7630002190167, -122.411712108343) | 8 | 4 | 7 | 28859 | 19 | |||
| 119172 | 189010 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1734 La Salle Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6014844.65282 | 2096707.75266 | 37.7379944669672 | -122.391164127549 | (37.7379944669672, -122.391164127549) | 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) );