trees
3,267 rows where qSpecies_id = 67 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194439 | 62177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 33 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780357 | 6000151.49887 | 2091775.04378 | 37.7236240542963 | -122.441611590516 | (37.7236240542963, -122.441611590516) | 9 | 7 | 6 | 28861 | 25 |
194424 | 62181 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 18 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2017 12:00:00 AM | 3 | Permit Number 778619 | 6000227.93753 | 2091768.58709 | 37.7236106804803 | -122.441346893068 | (37.7236106804803, -122.441346893068) | 9 | 7 | 6 | 28861 | 25 | |
194233 | 205842 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 27 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994419.52632 | 2090108.84131 | 37.7187208182988 | -122.461305149719 | (37.7187208182988, -122.461305149719) | 9 | 8 | 6 | 28861 | 24 | |||
194168 | 124494 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2760 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5996375.54996 | 2111283.13534 | 37.7769725472552 | -122.456074024047 | (37.7769725472552, -122.456074024047) | 11 | 6 | 2 | 54 | 16 | |||
194149 | 175605 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 243 Curtis St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 2ft | 6000870.76223 | 2087251.30173 | 37.7112438287074 | -122.438801214504 | (37.7112438287074, -122.438801214504) | 9 | 7 | 6 | 28861 | 5 | |||
194122 | 45253 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 574 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44100 | 6009814.86507162 | 2098861.28779426 | 37.7436271988368 | -122.408706547484 | (37.7436271988368, -122.408706547484) | 2 | 7 | 7 | 28859 | 2 | ||
194101 | 125826 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1865 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6004120.08533 | 2118341.02861 | 37.7967932278896 | -122.429786828517 | (37.7967932278896, -122.429786828517) | 13 | 9 | 1 | 57 | 17 | |||
194040 | 175614 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100x Mansell St | 10 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6011421.83278 | 2090628.04482 | 37.7211103133815 | -122.402571168832 | (37.7211103133815, -122.402571168832) | 10 | 7 | 8 | 309 | 28 | |||
194032 | 7693 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6008532.7031 | 2121045.4305 | 37.804467726204 | -122.414709587149 | (37.804467726204, -122.414709587149) | 3 | 1 | 10 | 308 | 23 | |||
193999 | 205852 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 295 Montana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994085.70454 | 2089317.72121 | 37.7165293737121 | -122.462401678704 | (37.7165293737121, -122.462401678704) | 9 | 8 | 6 | 28861 | 24 | |||
193878 | 34952 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 315 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1997 12:00:00 AM | Permit Number 38549 | 5994259.00226066 | 2099898.8670044 | 37.7455925857292 | -122.462569772731 | (37.7455925857292, -122.462569772731) | 1 | 8 | 4 | 29491 | 40 | |||
193874 | 57620 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1315 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1976 12:00:00 AM | 7 | Permit Number 16513 | 6013619.85223 | 2105678.11132 | 37.7625571104404 | -122.396027350002 | (37.7625571104404, -122.396027350002) | 14 | 3 | 8 | 28856 | 29 | ||
193871 | 204462 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 370 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993936.39242 | 2099669.25948 | 37.7449435572048 | -122.463668638206 | (37.7449435572048, -122.463668638206) | 1 | 8 | 4 | 29491 | 40 | |||
193852 | 125835 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1880 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005163.71131 | 2117490.06883 | 37.7945157505458 | -122.426115027887 | (37.7945157505458, -122.426115027887) | 13 | 9 | 1 | 28858 | 27 | |||
193843 | 220797 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2450 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6011199.76823 | 2102316.33036 | 37.7531914636338 | -122.404160976856 | (37.7531914636338, -122.404160976856) | 10 | 4 | 8 | 28859 | 19 | |||
193716 | 204403 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1434 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5994303.38506 | 2105740.37136 | 37.7616344195158 | -122.462840015477 | (37.7616344195158, -122.462840015477) | 1 | 5 | 11 | 56 | 12 | |||
193688 | 200144 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1351 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6013679.8971 | 2090868.8737 | 37.7218973889739 | -122.394782497653 | (37.7218973889739, -122.394782497653) | 10 | 3 | 8 | 58 | 1 | |||
193670 | 182824 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2309 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5986840.4933 | 2102978.0036 | 37.7536170454165 | -122.488447760064 | (37.7536170454165, -122.488447760064) | 1 | 8 | 3 | 56 | 35 | |||
193645 | 245947 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997917.0355 | 2107832.895 | 37.7675874329446 | -122.450492783652 | (37.7675874329446, -122.450492783652) | 15 | 5 | 11 | 29492 | 9 | |||
193570 | 205840 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 39 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994420.75333 | 2090183.87687 | 37.7189269186341 | -122.461306344918 | (37.7189269186341, -122.461306344918) | 9 | 8 | 6 | 28861 | 24 | |||
193494 | 4256 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4082 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003396.98562 | 2100411.62921 | 37.7475225268465 | -122.431008624962 | (37.7475225268465, -122.431008624962) | 2 | 4 | 5 | 63 | 22 | |||
193484 | 39920 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1938 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 5 | Permit Number 41195 | 6001498.4263 | 2115139.9308 | 37.7878550389128 | -122.438628871511 | (37.7878550389128, -122.438628871511) | 13 | 6 | 1 | 29490 | 27 | |
193317 | 8897 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5993420.4630402 | 2112810.6467907 | 37.7809966203952 | -122.466407540491 | (37.7809966203952, -122.466407540491) | 11 | 6 | 2 | 54 | 11 | |||
193204 | 248558 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 169 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997302.141 | 2107744.3175 | 37.7673090091983 | -122.452613219954 | (37.7673090091983, -122.452613219954) | 15 | 5 | 11 | 29492 | 9 | |||
193132 | 250790 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 284 32nd Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5985915.81821 | 2114007.58209 | 37.7838471713633 | -122.492457627621 | (37.7838471713633, -122.492457627621) | 11 | 6 | 1 | 55 | 33 | |||
193028 | 175654 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5989491.89044 | 2089216.44658 | 37.7159856948481 | -122.478272601196 | (37.7159856948481, -122.478272601196) | 1 | 8 | 4 | 64 | 14 | ||||
192975 | 1894 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 79 Beatrice Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017701.0374377 | 2094273.2748059 | 37.7314679721847 | -122.381118877186 | (37.7314679721847, -122.381118877186) | 10 | 3 | 8 | 58 | 1 | |||
192965 | 204418 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1245 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5996733.53974 | 2107102.37962 | 37.7655138169466 | -122.454533540707 | (37.7655138169466, -122.454533540707) | 15 | 5 | 11 | 29492 | 12 | |||
192880 | 175657 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5990127.49163 | 2089397.98883 | 37.7165210414792 | -122.476088939347 | (37.7165210414792, -122.476088939347) | 1 | 8 | 4 | 64 | 14 | ||||
192803 | 255689 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5 Perego Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999477 | 2101586 | 37.7505241650892 | -122.444648037001 | (37.7505241650892, -122.444648037001) | 2 | 5 | 5 | 63 | 38 | ||||
192773 | 220914 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 228 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008251.75534 | 2097533.86672 | 37.7398947209705 | -122.414017530307 | (37.7398947209705, -122.414017530307) | 2 | 7 | 7 | 28859 | 2 | |||
192697 | 246006 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Ashbury St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998992.533 | 2108633.4236 | 37.7698469791765 | -122.446830400622 | (37.7698469791765, -122.446830400622) | 15 | 5 | 11 | 29492 | 9 | |||
192609 | 248143 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Massasoit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009914.12622 | 2099368.67535 | 37.745025933311 | -122.408399106651 | (37.745025933311, -122.408399106651) | 2 | 7 | 7 | 28859 | 2 | |||
192573 | 204422 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1890 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993170.0741 | 2102669.55872 | 37.7531374251538 | -122.466536437709 | (37.7531374251538, -122.466536437709) | 1 | 8 | 4 | 56 | 12 | |||
192464 | 94063 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 3 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
192463 | 9879 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1515 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6005356.5169 | 2115030.8291 | 37.7877741910602 | -122.42527281445 | (37.7877741910602, -122.42527281445) | 13 | 9 | 11 | 28858 | 27 | |||
192450 | 204531 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 27 | Median : Cutout | Tree | DPW 1 | 14 | Width 3ft | 5999192.43538 | 2097025.16393 | 37.7379849647319 | -122.44530419515 | (37.7379849647319, -122.44530419515) | 9 | 7 | 4 | 59 | 40 | |||
192422 | 189030 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010021.47788 | 2111859.88889 | 37.7793299837179 | -122.408909048327 | (37.7793299837179, -122.408909048327) | 14 | 2 | 9 | 28853 | 34 | |||
192416 | 220915 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3590 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008484.31774 | 2098174.70194 | 37.7416673728638 | -122.413258729115 | (37.7416673728638, -122.413258729115) | 2 | 7 | 7 | 28859 | 2 | |||
192395 | 102739 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1249 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016779.4097 | 2092749.4074 | 37.7272328159816 | -122.384199065737 | (37.7272328159816, -122.384199065737) | 10 | 3 | 8 | 58 | 1 | |||
192336 | 9245 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6500 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5986886.6516554 | 2112572.1737573 | 37.7799626628655 | -122.488993391881 | (37.7799626628655, -122.488993391881) | 11 | 6 | 2 | 55 | 26 | |||
192089 | 8834 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
191993 | 188889 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 812 Rhode Island St | 2 | : | Tree | Private 2 | 3 | Width 6ft | 6011824.00346 | 2104560.8876 | 37.7593893834298 | -122.402160024888 | (37.7593893834298, -122.402160024888) | 10 | 3 | 8 | 28856 | 29 | |||
191984 | 7409 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1074 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6010471.6875 | 2111110.743 | 37.7772982123977 | -122.407298752214 | (37.7772982123977, -122.407298752214) | 14 | 2 | 9 | 28853 | 34 | |||
191981 | 26060 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 236 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5994622.6639 | 2088111.443 | 37.713248125396 | -122.460458337607 | (37.713248125396, -122.460458337607) | 9 | 8 | 6 | 28861 | 24 | |||
191971 | 250733 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2801 Lake St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5986711.11836 | 2114419.3556 | 37.7850242490222 | -122.489736514746 | (37.7850242490222, -122.489736514746) | 11 | 6 | 1 | 55 | 33 | |||
191970 | 32555 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 149 Buena Vista Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 37042 | 6001443.27762787 | 2107418.20108086 | 37.7666499791028 | -122.438266279926 | (37.7666499791028, -122.438266279926) | 15 | 5 | 5 | 28862 | 3 | ||||
191872 | 56160 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 529 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 7 | Permit Number 12268 | 5990914.4091 | 2111783.83889 | 37.7780323666648 | -122.475002157716 | (37.7780323666648, -122.475002157716) | 11 | 6 | 2 | 54 | 26 | ||
191779 | 175687 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 212 Madison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005610.85605 | 2092639.17461 | 37.7263063029891 | -122.42280090294 | (37.7263063029891, -122.42280090294) | 9 | 7 | 7 | 309 | 5 | |||
191618 | 205737 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2308 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993060.80297 | 2100494.20728 | 37.7471581620186 | -122.466756196957 | (37.7471581620186, -122.466756196957) | 1 | 8 | 4 | 29491 | 40 | |||
191600 | 204480 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 475 Warren Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994431.65083 | 2104463.74584 | 37.7581365226027 | -122.462303805475 | (37.7581365226027, -122.462303805475) | 1 | 5 | 4 | 63 | 12 | |||
191570 | 116847 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 987 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009201 | 2103425 | 37.7561237360793 | -122.411151453462 | (37.7561237360793, -122.411151453462) | 2 | 4 | 7 | 28859 | 19 | |||
191444 | 220845 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 138 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010146.15101 | 2100203.68642 | 37.7473316817309 | -122.4076556668 | (37.7473316817309, -122.4076556668) | 2 | 7 | 7 | 28859 | 2 | |||
191388 | 38376 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3809 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40435 | 5982211.97867906 | 2102828.4142054 | 37.7529351608085 | -122.504442832568 | (37.7529351608085, -122.504442832568) | 1 | 8 | 3 | 56 | 35 | ||
191169 | 175620 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 12 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6009477.4678 | 2090042.25002 | 37.7193930983987 | -122.409250984045 | (37.7193930983987, -122.409250984045) | 9 | 3 | 8 | 309 | 18 | |||
191017 | 189031 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010032.2441 | 2111878.47542 | 37.7793816210166 | -122.408873115008 | (37.7793816210166, -122.408873115008) | 14 | 2 | 9 | 28853 | 34 | |||
191016 | 222483 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2617 Diamond St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002309.54618 | 2096507.28827 | 37.7367404388252 | -122.434489800761 | (37.7367404388252, -122.434489800761) | 2 | 7 | 5 | 63 | 7 | |||
190801 | 175726 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 448 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010217.17242 | 2091300.20495 | 37.7228885968184 | -122.406782695777 | (37.7228885968184, -122.406782695777) | 10 | 3 | 7 | 309 | 28 | |||
190773 | 36094 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39197 | 6009173.48990003 | 2106882.99462813 | 37.7656170584886 | -122.411490890744 | (37.7656170584886, -122.411490890744) | 8 | 4 | 7 | 28853 | 19 | |||
190655 | 199913 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1282 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016634.5363 | 2092932.8401 | 37.7277284749637 | -122.384712669452 | (37.7277284749637, -122.384712669452) | 10 | 3 | 8 | 58 | 1 | |||
190653 | 175724 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 436 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010269.07582 | 2091316.0366 | 37.7229349712507 | -122.406604390786 | (37.7229349712507, -122.406604390786) | 10 | 3 | 7 | 309 | 28 | |||
190625 | 112792 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 23x Joice St | 3 | Unaccepted Street : Cutout | Tree | Private 2 | 5 | 6010303.89255 | 2116225.84414 | 37.7913336739481 | -122.408240067851 | (37.7913336739481, -122.408240067851) | 5 | 1 | 10 | 28857 | 21 | ||||
190555 | 222420 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Henry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6003357.339 | 2107395.21062 | 37.7666955314936 | -122.431644234308 | (37.7666955314936, -122.431644234308) | 15 | 5 | 5 | 28862 | 3 | |||
190523 | 248601 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 462 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997503.371 | 2107472.2255 | 37.766573441884 | -122.451897565692 | (37.766573441884, -122.451897565692) | 15 | 5 | 11 | 29492 | 9 | |||
190504 | 217641 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 345 West Portal Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5992125.359 | 2096901.9557 | 37.7372407232731 | -122.469729376124 | (37.7372407232731, -122.469729376124) | 1 | 8 | 4 | 59 | 40 | |||
190497 | 248361 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 709 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999005.2518 | 2108246.1052 | 37.7687842275564 | -122.446758533868 | (37.7687842275564, -122.446758533868) | 15 | 5 | 11 | 29492 | 9 | |||
190477 | 122358 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 155 Appleton Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
190475 | 125767 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Beach St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6001920.94521 | 2121150.96957 | 37.8043838099173 | -122.437597683295 | (37.8043838099173, -122.437597683295) | 13 | 9 | 1 | 57 | 17 | |||
190427 | 222365 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 69 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004118.24646 | 2102638.79242 | 37.7536786398761 | -122.428673288838 | (37.7536786398761, -122.428673288838) | 2 | 4 | 5 | 28862 | 22 | |||
190389 | 205670 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1484 08th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993693.07939 | 2105401.95152 | 37.7606700360075 | -122.46492621958 | (37.7606700360075, -122.46492621958) | 1 | 8 | 11 | 56 | 12 | |||
190367 | 204456 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 396 Magellan Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5993813.88862 | 2099553.91261 | 37.7446197841723 | -122.464083858782 | (37.7446197841723, -122.464083858782) | 1 | 8 | 4 | 29491 | 40 | |||
190364 | 199949 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1234 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016872.5031 | 2092757.6701 | 37.7272606504521 | -122.383877814405 | (37.7272606504521, -122.383877814405) | 10 | 3 | 8 | 58 | 1 | |||
190348 | 42166 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 354 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011846.02554 | 2111882.36991 | 37.7794937439822 | -122.402598720465 | (37.7794937439822, -122.402598720465) | 14 | 2 | 9 | 28856 | 34 | ||
190132 | 19346 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 538 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5992530.80337 | 2089863.7154 | 37.7179388802504 | -122.46781582944 | (37.7179388802504, -122.46781582944) | 9 | 8 | 6 | 64 | 24 | |||
190116 | 34163 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 880 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39899 | 6000880.58797723 | 2099688.43723978 | 37.7453939049945 | -122.43965831098 | (37.7453939049945, -122.43965831098) | 2 | 4 | 5 | 63 | 22 | ||
189991 | 52037 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2530 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2005 12:00:00 AM | 0 | Permit Number 48249 | 5982130.19675143 | 2097871.80760373 | 37.7393208872786 | -122.50435848033 | (37.7393208872786, -122.50435848033) | 1 | 8 | 3 | 29491 | 35 | ||
189956 | 114253 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5990028.62528 | 2111858.48615 | 37.778185952947 | -122.478071825887 | (37.778185952947, -122.478071825887) | 11 | 6 | 2 | 55 | 26 | |||
189948 | 9876 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1505 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x4 | 6005371.567 | 2114888.4319 | 37.7873840540746 | -122.425210607423 | (37.7873840540746, -122.425210607423) | 13 | 9 | 11 | 28858 | 27 | |||
189890 | 199906 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1280 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016815.2148 | 2093150.1501 | 37.728335156345 | -122.384103181463 | (37.728335156345, -122.384103181463) | 10 | 3 | 8 | 58 | 1 | |||
189877 | 125792 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3801 Divisadero St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6000092.08317 | 2121324.76719 | 37.8047568595036 | -122.443939089914 | (37.8047568595036, -122.443939089914) | 13 | 9 | 1 | 57 | 17 | |||
189856 | 205698 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2330 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5992340.2953 | 2099583.2383 | 37.7446152659802 | -122.469181341153 | (37.7446152659802, -122.469181341153) | 1 | 8 | 4 | 29491 | 40 | |||
189766 | 175696 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 787 Burrows St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6009276.78289 | 2092878.12716 | 37.7271685765455 | -122.41014478697 | (37.7271685765455, -122.41014478697) | 9 | 3 | 7 | 309 | 28 | |||
189630 | 204367 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 544 Ramsell St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5993020.48058 | 2090812.3003 | 37.7205717282756 | -122.466192141252 | (37.7205717282756, -122.466192141252) | 9 | 8 | 6 | 64 | 24 | |||
189558 | 222266 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 24 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007051.4954 | 2097530.01845 | 37.7398166688167 | -122.418167264814 | (37.7398166688167, -122.418167264814) | 2 | 7 | 7 | 28859 | 2 | |||
189501 | 143119 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004073.3886 | 2119693.6255 | 37.8005044660423 | -122.430044947424 | (37.8005044660423, -122.430044947424) | 13 | 9 | 1 | 57 | 17 | |||
189456 | 182174 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1731 Lawton St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 5988860.3755 | 2104414.7881 | 37.7576797205887 | -122.481567865565 | (37.7576797205887, -122.481567865565) | 1 | 8 | 3 | 56 | 35 | |||
189453 | 125801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3711 Fillmore St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6002004.76332 | 2121253.22913 | 37.804669352783 | -122.437314950825 | (37.804669352783, -122.437314950825) | 13 | 9 | 1 | 57 | 17 | |||
189420 | 10044 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 360 Guerrero St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005474.87318 | 2106843.21233 | 37.7652996739685 | -122.424280773353 | (37.7652996739685, -122.424280773353) | 8 | 4 | 5 | 28853 | 19 | |||
189407 | 182792 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1314 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5989875.7736 | 2103150.7455 | 37.7542679858747 | -122.477963833108 | (37.7542679858747, -122.477963833108) | 1 | 8 | 3 | 56 | 35 | |||
189360 | 189001 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1754 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014744.02673 | 2096786.40007 | 37.7382048318912 | -122.391517541304 | (37.7382048318912, -122.391517541304) | 10 | 3 | 8 | 58 | 1 | |||
189356 | 220965 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006182.97124 | 2103487.11814 | 37.7561245826867 | -122.421593243841 | (37.7561245826867, -122.421593243841) | 2 | 4 | 5 | 28859 | 19 | |||
189335 | 188973 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1901 Quint St | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6012398.63958 | 2095214.62665 | 37.7337586115567 | -122.399516458721 | (37.7337586115567, -122.399516458721) | 10 | 3 | 8 | 58 | 1 | |||
189301 | 204392 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Junipero Serra Blvd | 111 | : | Tree | Private 2 | 2 | Width 0ft | 5991121.6593 | 2090321.76947 | 37.7191151143447 | -122.47271995398 | (37.7191151143447, -122.47271995398) | 9 | 8 | 4 | 64 | 40 | |||
189200 | 200760 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1608 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6014687.6777 | 2094034.6929 | 37.7306460770704 | -122.391520046563 | (37.7306460770704, -122.391520046563) | 10 | 3 | 8 | 58 | 1 | |||
189118 | 175652 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5988848.34422 | 2089725.76423 | 37.7173467747095 | -122.480534235175 | (37.7173467747095, -122.480534235175) | 1 | 8 | 4 | 64 | 14 | ||||
189072 | 138842 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 451 IVY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005140.3897 | 2111105.3042 | 37.7769834569711 | -122.425741060612 | (37.7769834569711, -122.425741060612) | 7 | 9 | 11 | 28852 | 10 | |||
189056 | 188912 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6012391.34406 | 2101833.17524 | 37.7519313326819 | -122.400006314936 | (37.7519313326819, -122.400006314936) | 10 | 3 | 8 | 28856 | 29 | |||
188991 | 175674 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 116 Vienna St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6004710.86363 | 2092757.34918 | 37.7265799630845 | -122.4259205423 | (37.7265799630845, -122.4259205423) | 9 | 7 | 6 | 28861 | 5 | |||
188900 | 54707 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1782 Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1972 12:00:00 AM | 13 | Permit Number 10542 | 6012472.9912 | 2095604.68299 | 37.734833769058 | -122.399286773683 | (37.734833769058, -122.399286773683) | 10 | 3 | 8 | 58 | 1 | ||
188864 | 222195 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4319 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001046.2446 | 2102285.6122 | 37.7525345538484 | -122.439271621102 | (37.7525345538484, -122.439271621102) | 2 | 4 | 5 | 28862 | 22 |
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) );