trees
953 rows where qSpecies_id = 60
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24510 | 204663 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 163 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000334.21865 | 2095199.11319 | 37.7330361672695 | -122.44122551784 | (37.7330361672695, -122.44122551784) | 9 | 7 | 5 | 63 | 40 | ||||
24546 | 22552 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 39 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1992 12:00:00 AM | 20 | 2x3 | 6001599.33681 | 2098534.06318 | 37.7422651486201 | -122.43709036493 | (37.7422651486201, -122.43709036493) | 2 | 7 | 5 | 63 | 7 | ||
24772 | 221325 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006242.86506 | 2104074.32841 | 37.7577403028851 | -122.42142781086 | (37.7577403028851, -122.42142781086) | 2 | 4 | 5 | 28859 | 19 | |||
24955 | 26493 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 519 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004978.6865 | 2110816.0585 | 37.7761801200302 | -122.426279843947 | (37.7761801200302, -122.426279843947) | 7 | 9 | 11 | 28852 | 10 | |||
25164 | 56716 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1522 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015807.4304 | 2095648.0005 | 37.7351379840188 | -122.387761378928 | (37.7351379840188, -122.387761378928) | 10 | 3 | 8 | 58 | 1 | ||||
25180 | 30744 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004178.56485 | 2109886.01831 | 37.7735811988523 | -122.428981357915 | (37.7735811988523, -122.428981357915) | 7 | 9 | 11 | 28852 | 10 |
25373 | 110420 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 419X 18TH AVE | 18 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
25483 | 56043 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4129 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 9 | 3x3 | Permit Number 12130 | 6002248.77832892 | 2105270.36244465 | 37.7607983186187 | -122.435326543463 | (37.7607983186187, -122.435326543463) | 2 | 4 | 5 | 28862 | 3 | |
25487 | 222564 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 160 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007476.41433 | 2100201.58357 | 37.7471760989928 | -122.416887300207 | (37.7471760989928, -122.416887300207) | 2 | 7 | 7 | 28859 | 2 | |||
25949 | 30741 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
26108 | 204620 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1440 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993064.41106 | 2105672.78897 | 37.7613774166458 | -122.467120173251 | (37.7613774166458, -122.467120173251) | 1 | 8 | 4 | 56 | 12 | |||
26153 | 108935 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 12X CAMP ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005858 | 2106413 | 37.7641400388714 | -122.422925047265 | (37.7641400388714, -122.422925047265) | 8 | 4 | 5 | 28859 | 19 | ||||
26486 | 47221 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | 9 | 3 | 7 | 309 | 28 | ||
26513 | 39670 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
26763 | 54426 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 770 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 15 | 3x3 | Permit Number 12242 | 6012397.0815 | 2104349.75534 | 37.7588416315494 | -122.400163199892 | (37.7588416315494, -122.400163199892) | 10 | 3 | 8 | 28856 | 29 | |
26892 | 56727 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1531 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6015734.3799 | 2095622.8211 | 37.7350647995931 | -122.388012186614 | (37.7350647995931, -122.388012186614) | 10 | 3 | 8 | 58 | 1 | ||||
26959 | 10888 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1270X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
27137 | 188340 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2080 Silver Ave | 3 | : | Tree | Private 2 | 6 | Width 2ft | 6012583.47847 | 2096093.49596 | 37.7361821046275 | -122.398939075088 | (37.7361821046275, -122.398939075088) | 10 | 3 | 8 | 58 | 1 | |||
27376 | 35610 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 325 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38967 | 5992638.71984217 | 2094691.8038829 | 37.7312018573426 | -122.467793768821 | (37.7312018573426, -122.467793768821) | 9 | 8 | 4 | 59 | 40 | |||
27809 | 188319 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6012713.14067 | 2103722.27252 | 37.7571363191045 | -122.39902607101 | (37.7571363191045, -122.39902607101) | 10 | 3 | 8 | 28856 | 29 | |||
27981 | 30676 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1040 Minna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34599 | 6007565.37727332 | 2109755.15641274 | 37.7734130071983 | -122.417256559972 | (37.7734130071983, -122.417256559972) | 8 | 2 | 9 | 28853 | 19 |
28325 | 26998 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1223 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/25/1999 12:00:00 AM | 6 | 3X3 | 6008728.29906 | 2094063.8664 | 37.7303936047791 | -122.412124661535 | (37.7303936047791, -122.412124661535) | 9 | 3 | 7 | 309 | 28 | ||
28386 | 49816 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46737 | 6012410.64537 | 2104168.1082 | 37.7583436247676 | -122.400103532548 | (37.7583436247676, -122.400103532548) | 10 | 3 | 8 | 28856 | 29 |
28573 | 101604 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180X Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 2x2 | 5998894.7 | 2093810.1 | 37.7291401587489 | -122.446102418286 | (37.7291401587489, -122.446102418286) | 9 | 7 | 4 | 28861 | 40 | |||
28920 | 204622 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1518 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993700.04012 | 2105141.70568 | 37.7599558699739 | -122.464883245465 | (37.7599558699739, -122.464883245465) | 1 | 8 | 4 | 56 | 12 | |||
29254 | 71993 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3449 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 3 | 5984766.04316 | 2113148.2827 | 37.7814204950816 | -122.496371935666 | (37.7814204950816, -122.496371935666) | 11 | 6 | 2 | 55 | 26 | ||
29421 | 107444 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3333 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6x6 | 6006088.7 | 2103711.1 | 37.7567342687503 | -122.421935176249 | (37.7567342687503, -122.421935176249) | 2 | 4 | 5 | 28859 | 19 | |||
29876 | 204614 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1255 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5990910.22691 | 2105165.14407 | 37.7598589779192 | -122.474533471065 | (37.7598589779192, -122.474533471065) | 1 | 8 | 4 | 56 | 12 | |||
29975 | 175763 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011100.65099 | 2092002.25417 | 37.7248656727096 | -122.40377805363 | (37.7248656727096, -122.40377805363) | 10 | 3 | 7 | 309 | 28 | |||
30252 | 57436 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4331 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 10 | 3x3 | Permit Number 32868 | 6001612.33019827 | 2105235.34197744 | 37.7606659965109 | -122.437525222221 | (37.7606659965109, -122.437525222221) | 2 | 4 | 5 | 28862 | 3 |
30336 | 125888 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 575 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008045.66737 | 2113749.49498 | 37.7844075146451 | -122.415878065725 | (37.7844075146451, -122.415878065725) | 7 | 10 | 9 | 28858 | 36 | |||
30618 | 97004 | Property Tree 8 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195A Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
30698 | 125889 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006091.49195 | 2112832.09387 | 37.781778500422 | -122.422573634365 | (37.781778500422, -122.422573634365) | 7 | 9 | 11 | 28852 | 41 | |||
31225 | 204651 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 27 Majestic Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5997399.75585 | 2089775.82239 | 37.7179774953307 | -122.450979745524 | (37.7179774953307, -122.450979745524) | 9 | 8 | 6 | 28861 | 24 | |||
31303 | 188306 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 635 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015455.75158 | 2106081.00048 | 37.7637653298293 | -122.38970572754 | (37.7637653298293, -122.38970572754) | 14 | 3 | 8 | 28856 | 29 | |||
31918 | 222594 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1701 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003405.54742 | 2098267.585 | 37.7416359640346 | -122.430826033811 | (37.7416359640346, -122.430826033811) | 2 | 7 | 5 | 63 | 7 | |||
32080 | 175788 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008132.91971 | 2093497.94914 | 37.7288062932694 | -122.414142956056 | (37.7288062932694, -122.414142956056) | 9 | 3 | 7 | 309 | 28 | |||
32161 | 123707 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 698 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 5993511.46751 | 2111432.07 | 37.7772166713285 | -122.465992510852 | (37.7772166713285, -122.465992510852) | 11 | 6 | 2 | 54 | 11 | |||
32163 | 116349 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
32334 | 221326 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005468.19863 | 2101476.92488 | 37.7505647282985 | -122.423922233444 | (37.7505647282985, -122.423922233444) | 2 | 4 | 5 | 28859 | 19 | |||
32778 | 47219 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45167 | 6008176.9578 | 2093476.05572 | 37.7287486521041 | -122.413989164793 | (37.7287486521041, -122.413989164793) | 9 | 3 | 7 | 309 | 28 | |
32876 | 188339 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6011007.54195 | 2094765.98142 | 37.7324490889606 | -122.404294355303 | (37.7324490889606, -122.404294355303) | 10 | 3 | 8 | 58 | 1 | |||
33218 | 34342 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 12661268 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38099 | 6010039 | 2101826 | 37.7517801982502 | -122.408140586549 | (37.7517801982502, -122.408140586549) | 2 | 4 | 7 | 28859 | 19 | ||
33277 | 69157 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1259 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 8 | Permit Number 33193 | 5983030.0636 | 2106498.5077 | 37.7630602867444 | -122.501885316454 | (37.7630602867444, -122.501885316454) | 1 | 8 | 3 | 56 | 35 | |
33970 | 181677 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2704 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987307.2214 | 2106457.8989 | 37.7631991100618 | -122.487089290148 | (37.7631991100618, -122.487089290148) | 1 | 8 | 3 | 56 | 35 | |||
34069 | 247043 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 596 Valley St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6002094.89222 | 2099164.93967 | 37.7440255436471 | -122.435422008318 | (37.7440255436471, -122.435422008318) | 2 | 7 | 5 | 63 | 22 | ||||
34147 | 110720 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
34267 | 188311 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 189 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012910.01504 | 2106269.57454 | 37.764141618776 | -122.398523940823 | (37.764141618776, -122.398523940823) | 14 | 3 | 8 | 28856 | 29 | |||
34401 | 27126 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2095X Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
34465 | 222549 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 199 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007198.14969 | 2097813.68298 | 37.7406038022373 | -122.417680295405 | (37.7406038022373, -122.417680295405) | 2 | 7 | 7 | 28859 | 2 | |||
34470 | 188309 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012912.61356 | 2106204.46931 | 37.763962999013 | -122.398510384468 | (37.763962999013, -122.398510384468) | 14 | 3 | 8 | 28856 | 29 | |||
34526 | 22825 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 80 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/1993 12:00:00 AM | 25 | 3X3 | 5999298.50958 | 2099073.67343 | 37.7436157369876 | -122.445084674243 | (37.7436157369876, -122.445084674243) | 2 | 7 | 5 | 63 | 7 | ||
34591 | 251286 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/09/1998 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
34811 | 109380 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 725X BURNETT AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5999257.1 | 2101645.9 | 37.7506760851616 | -122.445412771855 | (37.7506760851616, -122.445412771855) | 2 | 5 | 5 | 63 | 38 | |||||
34856 | 188343 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2055 Silver Ave | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6012604.8118 | 2096159.09388 | 37.7363634115335 | -122.398869919026 | (37.7363634115335, -122.398869919026) | 10 | 3 | 8 | 58 | 1 | |||
35110 | 188332 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 288 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013443.088 | 2105758.2954 | 37.7627674420819 | -122.396644338879 | (37.7627674420819, -122.396644338879) | 14 | 3 | 8 | 28856 | 29 | |||
35216 | 204656 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 201 Sargent St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5993464.3561 | 2089166.28112 | 37.7160777557502 | -122.464538359982 | (37.7160777557502, -122.464538359982) | 9 | 8 | 6 | 64 | 24 | |||
35674 | 222588 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4380 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000121.81513 | 2105788.1369 | 37.762098979601 | -122.44271991951 | (37.762098979601, -122.44271991951) | 15 | 5 | 5 | 28862 | 3 | |||
35714 | 147127 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 583 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x6 | 5986876.14797 | 2111982.26615 | 37.7783423311713 | -122.488986349742 | (37.7783423311713, -122.488986349742) | 11 | 6 | 2 | 55 | 26 | |||
36075 | 175765 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5988629.85447 | 2089774.30196 | 37.7174673468061 | -122.481292995899 | (37.7174673468061, -122.481292995899) | 1 | 8 | 4 | 64 | 14 | ||||
36265 | 181761 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1246 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5989269.0192 | 2106863.9805 | 37.7644282944678 | -122.480333887539 | (37.7644282944678, -122.480333887539) | 1 | 8 | 3 | 56 | 35 | |||
36294 | 16142 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 370 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5999632.4946283 | 2094718.5075125 | 37.7316765391045 | -122.443617041287 | (37.7316765391045, -122.443617041287) | 9 | 7 | 4 | 63 | 40 | |||
37203 | 143861 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3201 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985565.10939 | 2113174.24077 | 37.7815385460111 | -122.493609507183 | (37.7815385460111, -122.493609507183) | 11 | 6 | 2 | 55 | 26 | ||
37364 | 175787 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008123.23514 | 2093495.17198 | 37.7287981238093 | -122.414176239965 | (37.7287981238093, -122.414176239965) | 9 | 3 | 7 | 309 | 28 | |||
37366 | 181746 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1246 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5989272.8487 | 2106849.4285 | 37.7643885611619 | -122.480319577317 | (37.7643885611619, -122.480319577317) | 1 | 8 | 3 | 56 | 35 | |||
37405 | 258000 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
37552 | 101159 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013387.24003 | 2105243.87751 | 37.7613518552239 | -122.396801432457 | (37.7613518552239, -122.396801432457) | 10 | 3 | 8 | 28856 | 29 | |||
37578 | 221355 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2971 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008404.74116 | 2103860.62661 | 37.757275180723 | -122.413936009452 | (37.757275180723, -122.413936009452) | 2 | 4 | 7 | 28859 | 19 | |||
37723 | 96932 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011002.04218 | 2094782.56307 | 37.7324943113535 | -122.404314536086 | (37.7324943113535, -122.404314536086) | 10 | 3 | 8 | 58 | 1 | |||
37810 | 222597 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 62 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002444.78145 | 2096589.20481 | 37.7369730385666 | -122.434028087935 | (37.7369730385666, -122.434028087935) | 2 | 7 | 5 | 63 | 7 | |||
37830 | 31102 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 215 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 6 | Permit Number 34832 | 6000072.59523 | 2094462.74015 | 37.7309993521219 | -122.442077177628 | (37.7309993521219, -122.442077177628) | 9 | 7 | 4 | 63 | 40 | |
37840 | 96018 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
37894 | 45238 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 871 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2001 12:00:00 AM | Permit Number 44088 | 6008421.36689101 | 2115188.65226849 | 37.7883802062735 | -122.414680152021 | (37.7883802062735, -122.414680152021) | 5 | 1 | 10 | 28858 | 21 | |||
39187 | 33577 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 190 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37685 | 6007025.08907683 | 2097945.62097714 | 37.7409563345382 | -122.418288026055 | (37.7409563345382, -122.418288026055) | 2 | 7 | 7 | 28859 | 2 | |||
39230 | 222571 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 593 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001358.40825 | 2101420.45569 | 37.7501768003212 | -122.438130138611 | (37.7501768003212, -122.438130138611) | 2 | 4 | 5 | 28862 | 22 | |||
39368 | 43890 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009124.11279 | 2110606.98987 | 37.7758395125283 | -122.41192485917 | (37.7758395125283, -122.41192485917) | 8 | 2 | 9 | 28853 | 34 | ||
39542 | 254749 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 164 Escolta Way | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 4x6 | Permit Number 781597 | 5986451.85258 | 2097316.8045 | 37.7380502293434 | -122.489375519691 | (37.7380502293434, -122.489375519691) | 1 | 8 | 3 | 29491 | 35 | |
39556 | 26989 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1327 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1999 12:00:00 AM | 6 | 3X3 | 6009306.59459 | 2094318.78355 | 37.7311259838562 | -122.410143394801 | (37.7311259838562, -122.410143394801) | 9 | 3 | 7 | 309 | 28 | ||
39796 | 222546 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2825 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002452.45425 | 2095510.12485 | 37.734010568315 | -122.433924450977 | (37.734010568315, -122.433924450977) | 2 | 7 | 5 | 63 | 7 | |||
40222 | 87642 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1002X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004813.344433 | 2112300.663017 | 37.7802471321724 | -122.426957567511 | (37.7802471321724, -122.426957567511) | 7 | 9 | 11 | 28852 | 41 | |||||
40262 | 221321 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005240.58146 | 2105045.63355 | 37.7603507164348 | -122.424963229285 | (37.7603507164348, -122.424963229285) | 2 | 4 | 5 | 28859 | 19 | |||
40426 | 47227 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | 10 | 3 | 7 | 309 | 28 | ||
40526 | 121353 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1221 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2016 12:00:00 AM | 3 | 3x3 | 5984567.3281 | 2106871.8527 | 37.7641755703197 | -122.496596073864 | (37.7641755703197, -122.496596073864) | 1 | 8 | 3 | 56 | 35 | ||
40666 | 110721 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
40733 | 46346 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/2002 12:00:00 AM | Permit Number 44592 | 6005461.4442402 | 2101476.38644964 | 37.7505628685682 | -122.423945552398 | (37.7505628685682, -122.423945552398) | 2 | 4 | 5 | 28859 | 19 | ||
40880 | 39219 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 347 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1998 12:00:00 AM | Permit Number 40862 | 5993215.94072133 | 2089494.769314 | 37.7169653816902 | -122.465420843024 | (37.7169653816902, -122.465420843024) | 9 | 8 | 6 | 64 | 24 | |||
41037 | 2244 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 15X Brompton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002231.00143 | 2095678.63178 | 37.7344606799209 | -122.434702126219 | (37.7344606799209, -122.434702126219) | 2 | 7 | 5 | 63 | 7 | |||
41211 | 188316 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 850 Carolina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6012420.02519 | 2103984.29593 | 37.7578394396596 | -122.400058184238 | (37.7578394396596, -122.400058184238) | 10 | 3 | 8 | 28856 | 29 | |||
41380 | 39674 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 510 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41060 | 5994056.62807806 | 2090013.39911729 | 37.7184378644924 | -122.462552614145 | (37.7184378644924, -122.462552614145) | 9 | 8 | 6 | 28861 | 24 | ||
42079 | 252895 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 790x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:29:00 PM | 3 | 3x3 | 5997282 | 2090432 | 37.7197724640349 | -122.45143407539 | (37.7197724640349, -122.45143407539) | 9 | 8 | 6 | 28861 | 24 | ||
42114 | 40737 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 163 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41716 | 6009144.8463962 | 2096601.1649491 | 37.737383844528 | -122.410863725513 | (37.737383844528, -122.410863725513) | 10 | 7 | 7 | 28859 | 2 | ||
42353 | 118039 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3501 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 5ft | 5984617.86672 | 2113142.5664 | 37.7813961183692 | -122.496884124491 | (37.7813961183692, -122.496884124491) | 11 | 6 | 2 | 55 | 26 | ||
42376 | 27049 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 910 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3x3 | 6007348.52678 | 2093482.21971 | 37.7287190140661 | -122.416853547777 | (37.7287190140661, -122.416853547777) | 9 | 3 | 7 | 309 | 5 | ||
42439 | 221348 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 225 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007116.4311 | 2096880.25923 | 37.7380362287807 | -122.417896696594 | (37.7380362287807, -122.417896696594) | 2 | 7 | 7 | 28859 | 2 | |||
42932 | 49808 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1546ARKANSAS 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46602 | 6013062.18652198 | 2105692.25425348 | 37.7625649012206 | -122.397957118424 | (37.7625649012206, -122.397957118424) | 14 | 3 | 8 | 28856 | 29 | ||
42933 | 38322 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1303 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40379 | 6006986.09982569 | 2107885.23558278 | 37.7682460414156 | -122.419127704144 | (37.7682460414156, -122.419127704144) | 8 | 4 | 7 | 28853 | 19 | ||
43425 | 222591 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 310 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003760.57016 | 2108690.93214 | 37.7702761156764 | -122.430341981792 | (37.7702761156764, -122.430341981792) | 15 | 9 | 11 | 29492 | 10 | |||
43444 | 188313 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 299 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012940.76459 | 2105761.15041 | 37.7627473116745 | -122.398381910012 | (37.7627473116745, -122.398381910012) | 14 | 3 | 8 | 28856 | 29 | |||
43630 | 26977 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 526 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6004737.76851 | 2093468.91574 | 37.728535287917 | -122.425878161452 | (37.728535287917, -122.425878161452) | 9 | 7 | 6 | 28861 | 5 | ||
43658 | 116348 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 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) );