trees
3,267 rows where qSpecies_id = 67 sorted by qLegalStatus_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68944 | 49893 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6@ OCEAN Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50572 | 5993153.17842145 | 2093093.53426236 | 37.7268430955942 | -122.46589912079 | (37.7268430955942, -122.46589912079) | 9 | 8 | 4 | 59 | 40 | ||
69032 | 51091 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 780 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2004 12:00:00 AM | Permit Number 47548 | 6001488.77752298 | 2100017.17375191 | 37.7463311353619 | -122.437578831852 | (37.7463311353619, -122.437578831852) | 2 | 7 | 5 | 63 | 22 | |||
69122 | 51863 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1105 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48085 | 6002530.44355674 | 2102366.89187427 | 37.752842076313 | -122.434144824059 | (37.752842076313, -122.434144824059) | 2 | 4 | 5 | 28862 | 22 | ||||
69246 | 45091 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1900 Ortega St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43969 | 5988148.79891202 | 2102403.3041825 | 37.7521153260597 | -122.48388126909 | (37.7521153260597, -122.48388126909) | 1 | 8 | 3 | 56 | 35 | ||
69578 | 36092 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500 16th St | 6 | 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 | |||
69722 | 42673 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 581 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.8044516138202 | -122.414709203199 | (37.8044516138202, -122.414709203199) | 3 | 1 | 10 | 308 | 23 | ||
69808 | 34848 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 792 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38469 | 5999123.37842574 | 2107737.2945324 | 37.7673939092406 | -122.446313337038 | (37.7673939092406, -122.446313337038) | 15 | 5 | 11 | 29492 | 9 | ||||
70304 | 43528 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1596 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43202 | 6000228.69199764 | 2110281.0663022 | 37.7744415315581 | -122.442672890747 | (37.7744415315581, -122.442672890747) | 15 | 5 | 11 | 29492 | 16 | ||
71077 | 57192 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 896X DOUGLASS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1974 12:00:00 AM | 3x3 | Permit Number 14472 | 6001277 | 2101164 | 37.7494680040733 | -122.438393281323 | (37.7494680040733, -122.438393281323) | 2 | 4 | 5 | 28862 | 22 | ||
71283 | 69110 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 318 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33125 | 5993325.06338494 | 2104621.67061738 | 37.7585063618762 | -122.466142306467 | (37.7585063618762, -122.466142306467) | 1 | 8 | 4 | 56 | 12 | ||
71686 | 43362 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1100X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | 4 | 3x9 | Permit Number 43112 | 6003157.69483217 | 2101814.87307727 | 37.751361942995 | -122.431936260805 | (37.751361942995, -122.431936260805) | 2 | 4 | 5 | 28862 | 22 |
72681 | 2587 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1525X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6005364.20078 | 2114992.96648 | 37.7876706638403 | -122.425243534375 | (37.7876706638403, -122.425243534375) | 13 | 9 | 11 | 28858 | 27 | |||
72844 | 14443 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 85 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3x3 | 5998809.64126 | 2112795.13693 | 37.7812635250965 | -122.447762663299 | (37.7812635250965, -122.447762663299) | 15 | 6 | 2 | 54 | 16 | |||
73478 | 66178 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 243 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/1992 12:00:00 AM | Permit Number 29252 | 6009559.7518934 | 2097182.74370338 | 37.7390039901145 | -122.409470231128 | (37.7390039901145, -122.409470231128) | 10 | 7 | 7 | 28859 | 2 | ||
74335 | 52816 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201CLAREMONT Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2006 12:00:00 AM | Permit Number 48842 | 5994261.61912336 | 2098704.96828598 | 37.7423145902485 | -122.462474141393 | (37.7423145902485, -122.462474141393) | 1 | 8 | 4 | 59 | 40 | |||
75123 | 42164 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 360 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42459 | 6011853.6 | 2111898.2 | 37.7795376326187 | -122.40257363052 | (37.7795376326187, -122.40257363052) | 14 | 2 | 9 | 28856 | 34 | |||
76097 | 64932 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2300 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1989 12:00:00 AM | Permit Number 25960 | 5991529 | 2099733 | 37.7449795602653 | -122.471997526068 | (37.7449795602653, -122.471997526068) | 1 | 8 | 4 | 29491 | 40 | ||
76760 | 81369 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 14 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2011 12:00:00 AM | Permit Number 58731 | 5992684.22042124 | 2099043.76352214 | 37.7431538726351 | -122.467952894625 | (37.7431538726351, -122.467952894625) | 1 | 8 | 4 | 29491 | 40 | |||
76854 | 61661 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 246 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/1984 12:00:00 AM | Permit Number 21655 | 6006644.56233954 | 2093348.38333355 | 37.7283119065735 | -122.419277711746 | (37.7283119065735, -122.419277711746) | 9 | 7 | 7 | 309 | 5 | ||
77048 | 67857 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 596 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31532 | 6002067.00541727 | 2099182.85111765 | 37.7440731404676 | -122.435519715541 | (37.7440731404676, -122.435519715541) | 2 | 7 | 5 | 63 | 22 | ||
78218 | 42900 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2200 Wawona St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | Permit Number 42815 | 5986138.5427207 | 2097288.78551671 | 37.737955001906 | -122.490456711772 | (37.737955001906, -122.490456711772) | 1 | 8 | 3 | 29491 | 35 | ||
78230 | 83448 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
78926 | 60175 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1988 12:00:00 AM | Permit Number 25533 | 6005979.27726365 | 2105187.71035503 | 37.7607825242813 | -122.42241851621 | (37.7607825242813, -122.42241851621) | 2 | 4 | 5 | 28859 | 19 | ||
79976 | 96339 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1494@ 27th St Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2011 12:00:00 AM | 3x3 | Permit Number 767722 | 6005839 | 2100241 | 37.7471920883951 | -122.422552158036 | (37.7471920883951, -122.422552158036) | 2 | 7 | 5 | 28859 | 22 | ||
80478 | 43619 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
80973 | 35809 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Sycamore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.7625808703221 | -122.420443179735 | (37.7625808703221, -122.420443179735) | 8 | 4 | 7 | 28859 | 19 | ||
81383 | 10049 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 389 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2003 12:00:00 AM | 3 | 3X3 | 6005557.3779151 | 2106729.2709881 | 37.7649914764619 | -122.42398730533 | (37.7649914764619, -122.42398730533) | 8 | 4 | 5 | 28853 | 19 | ||
81628 | 12317 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.426561638009 | (37.7801814652814, -122.426561638009) | 7 | 9 | 11 | 28852 | 41 | |||
84896 | 35812 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Sycamore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.7625808703221 | -122.420443179735 | (37.7625808703221, -122.420443179735) | 8 | 4 | 7 | 28859 | 19 | ||
84962 | 42831 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.7958686285947 | -122.421803333655 | (37.7958686285947, -122.421803333655) | 13 | 9 | 10 | 28858 | 32 | ||
86730 | 94495 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 739 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5997569.2 | 2107955.8 | 37.7679049841939 | -122.451704762646 | (37.7679049841939, -122.451704762646) | 15 | 5 | 11 | 29492 | 9 | ||||
87196 | 89041 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
87798 | 45341 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 667 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44171 | 5994015.44130584 | 2090992.03620537 | 37.7211225948175 | -122.462765934958 | (37.7211225948175, -122.462765934958) | 9 | 8 | 6 | 64 | 24 | ||
87891 | 54999 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 538 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | Permit Number 773428 | 5990967.79402544 | 2111724.41194432 | 37.77787229032 | -122.474813143378 | (37.77787229032, -122.474813143378) | 11 | 6 | 2 | 54 | 26 | |||
88517 | 36095 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500 16th St | 2 | 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 | |||
88734 | 33570 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 152 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37680 | 6007130.56275094 | 2098140.70005851 | 37.74149791484 | -122.417937161506 | (37.74149791484, -122.417937161506) | 2 | 7 | 7 | 28859 | 2 | |||
89803 | 53981 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 320 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/1994 12:00:00 AM | Permit Number 33298 | 5992331.54284805 | 2094776.52933726 | 37.7314167502679 | -122.468861888063 | (37.7314167502679, -122.468861888063) | 9 | 8 | 4 | 59 | 40 | |||
90836 | 64569 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1429 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | Permit Number 25462 | 6000923.9519361 | 2111020.37522765 | 37.7765110963127 | -122.440320891248 | (37.7765110963127, -122.440320891248) | 15 | 5 | 11 | 29492 | 10 | ||
91000 | 63069 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 152 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1986 12:00:00 AM | Permit Number 23543 | 6008631.63225831 | 2097862.90988188 | 37.7408195298569 | -122.412727325892 | (37.7408195298569, -122.412727325892) | 10 | 7 | 7 | 28859 | 2 | ||
91490 | 32412 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 557 Congo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.442095971095 | (37.7338982944093, -122.442095971095) | 9 | 7 | 4 | 63 | 40 | |||
91527 | 12314 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.426561638009 | (37.7801814652814, -122.426561638009) | 7 | 9 | 11 | 28852 | 41 | |||
91595 | 37777 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 449 Felton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | Permit Number 40114 | 6009618.93348363 | 2093468.47161568 | 37.7288087098037 | -122.409003606238 | (37.7288087098037, -122.409003606238) | 10 | 3 | 7 | 309 | 28 | ||
91611 | 65941 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | Permit Number 28962 | 6007255.62038472 | 2113291.4844342 | 37.7831054816789 | -122.418578871955 | (37.7831054816789, -122.418578871955) | 7 | 9 | 9 | 28852 | 36 | ||
91719 | 23956 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2004X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002791.01315 | 2119592.00114 | 37.8001527217578 | -122.434475209441 | (37.8001527217578, -122.434475209441) | 13 | 9 | 1 | 57 | 17 | |||
91972 | 66534 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 701 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | Permit Number 30772 | 6004086.63776587 | 2091699.6936924 | 37.7236405778519 | -122.428003132555 | (37.7236405778519, -122.428003132555) | 9 | 7 | 6 | 28861 | 5 | ||
93438 | 31356 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2399 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1995 12:00:00 AM | Permit Number 34966 | 5991349.80377986 | 2099091.89396406 | 37.7432088770408 | -122.472570415702 | (37.7432088770408, -122.472570415702) | 1 | 8 | 4 | 29491 | 40 | ||
94137 | 43556 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 338 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43219 | 6003694.36665872 | 2099553.79617946 | 37.745183962731 | -122.429919119626 | (37.745183962731, -122.429919119626) | 2 | 7 | 5 | 63 | 22 | ||
94246 | 12313 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.426561638009 | (37.7801814652814, -122.426561638009) | 7 | 9 | 11 | 28852 | 41 | |||
94742 | 41819 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 29 Fortuna Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42205 | 6000254.75248069 | 2112385.7950317 | 37.780222066079 | -122.442733903375 | (37.780222066079, -122.442733903375) | 15 | 5 | 1 | 29490 | 16 | ||
94981 | 35810 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Sycamore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.7625808703221 | -122.420443179735 | (37.7625808703221, -122.420443179735) | 8 | 4 | 7 | 28859 | 19 | ||
95105 | 116732 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3290 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x4 | 6007783.42095653 | 2101534.76819168 | 37.7508539880545 | -122.415920085137 | (37.7508539880545, -122.415920085137) | 2 | 4 | 7 | 28859 | 19 | |||
96516 | 34357 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1822 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38113 | 6004544.96387342 | 2098197.10530749 | 37.741506934238 | -122.426881295332 | (37.741506934238, -122.426881295332) | 2 | 7 | 5 | 63 | 7 | ||
96914 | 83450 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
97011 | 63557 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2971 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/20/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768581 | 6008414.60000343 | 2103856.53351654 | 37.7572644957121 | -122.413901624069 | (37.7572644957121, -122.413901624069) | 2 | 4 | 7 | 28859 | 19 |
98242 | 116731 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3290 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x4 | 6007783.42095653 | 2101534.76819168 | 37.7508539880545 | -122.415920085137 | (37.7508539880545, -122.415920085137) | 2 | 4 | 7 | 28859 | 19 | |||
98494 | 69410 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1033 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33515 | 6001287.00169166 | 2086793.18756043 | 37.7100096203988 | -122.437329807487 | (37.7100096203988, -122.437329807487) | 9 | 7 | 6 | 28861 | 5 | ||
98718 | 99596 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3001@Filbert Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17057 | 6002820 | 2118927.7 | 37.7983303693218 | -122.434327384023 | (37.7983303693218, -122.434327384023) | 13 | 9 | 1 | 57 | 17 | ||||
100109 | 42396 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Gennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42555 | 5997487.92419847 | 2095274.73436784 | 37.7330812596511 | -122.451071309951 | (37.7330812596511, -122.451071309951) | 9 | 7 | 4 | 59 | 40 | ||
100159 | 33604 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37717 | 6005085.63985065 | 2110091.4174032 | 37.7741964769258 | -122.42585827051 | (37.7741964769258, -122.42585827051) | 7 | 9 | 11 | 28852 | 10 | |||
100704 | 37778 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 449 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | Permit Number 40114 | 6009618.93348363 | 2093468.47161568 | 37.7288087098037 | -122.409003606238 | (37.7288087098037, -122.409003606238) | 10 | 3 | 7 | 309 | 28 | ||
101506 | 69213 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1177 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33264 | 6008095.60945385 | 2101082.12715709 | 37.7496286841094 | -122.414808474137 | (37.7496286841094, -122.414808474137) | 2 | 4 | 7 | 28859 | 19 | ||
101695 | 65575 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 44 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2007 12:00:00 AM | 3x3 | Permit Number 49937 | 6007552.07395288 | 2099897.22885684 | 37.7463446647462 | -122.41660411777 | (37.7463446647462, -122.41660411777) | 2 | 7 | 7 | 28859 | 2 | ||
101808 | 5804 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6016140.1129448 | 2096198.2445968 | 37.7366672666368 | -122.386649521955 | (37.7366672666368, -122.386649521955) | 10 | 3 | 8 | 58 | 1 | |||
102189 | 46107 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2001 12:00:00 AM | Permit Number 44471 | 6005231.58471967 | 2105020.01841489 | 37.7602798751206 | -122.424992522324 | (37.7602798751206, -122.424992522324) | 2 | 4 | 5 | 28859 | 19 | ||
103808 | 69201 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2829 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 20 | Permit Number 33249 | 6008994.37155301 | 2101984.87642995 | 37.7521578906902 | -122.411764291769 | (37.7521578906902, -122.411764291769) | 2 | 4 | 7 | 28859 | 19 | |
104602 | 66255 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1991 12:00:00 AM | Permit Number 29357 | 5998777.54020022 | 2095889.92461041 | 37.7348441754269 | -122.446657030024 | (37.7348441754269, -122.446657030024) | 9 | 7 | 4 | 59 | 40 | ||
104970 | 49862 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 75@ LAGUNA Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2004 12:00:00 AM | Permit Number 46631 | 6005455.52049644 | 2109220.32111529 | 37.7718255527878 | -122.424516811052 | (37.7718255527878, -122.424516811052) | 7 | 9 | 5 | 28852 | 10 | ||
105935 | 109717 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3832 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773646 | 5982350.4 | 2103585.5 | 37.7550220459753 | -122.504020225851 | (37.7550220459753, -122.504020225851) | 1 | 8 | 3 | 56 | 35 |
106867 | 7689 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 545 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008705.23662 | 2121043.72673 | 37.8044727403042 | -122.414112396989 | (37.8044727403042, -122.414112396989) | 3 | 1 | 10 | 308 | 23 | |||
106907 | 67517 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 331 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31053 | 5997889.85712008 | 2093779.21238518 | 37.7289979144345 | -122.449574001825 | (37.7289979144345, -122.449574001825) | 9 | 7 | 4 | 28861 | 40 | ||
107611 | 31138 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 419 Hearst Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34852 | 5998635.87955939 | 2094356.6234018 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | 9 | 7 | 4 | 28861 | 40 | ||
107713 | 64933 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2299 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1989 12:00:00 AM | Permit Number 25961 | 5991453.69210058 | 2099794.8219263 | 37.745144949294 | -122.472262430335 | (37.745144949294, -122.472262430335) | 1 | 8 | 4 | 29491 | 40 | ||
108556 | 42674 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.8044516138202 | -122.414709203199 | (37.8044516138202, -122.414709203199) | 3 | 1 | 10 | 308 | 23 | ||
108835 | 40956 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 39 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1999 12:00:00 AM | Permit Number 41810 | 5993626.53166315 | 2093066.42761178 | 37.7267959624654 | -122.464260796159 | (37.7267959624654, -122.464260796159) | 9 | 8 | 4 | 59 | 40 | |||
108847 | 42861 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2599 31st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2000 12:00:00 AM | Permit Number 42787 | 5986745.41813509 | 2097587.07290157 | 37.7388094476944 | -122.488380388139 | (37.7388094476944, -122.488380388139) | 1 | 8 | 3 | 29491 | 35 | |||
110112 | 31003 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 285 Chicago Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34778 | 6002766.74364375 | 2086692.10708835 | 37.7098160865806 | -122.432208324272 | (37.7098160865806, -122.432208324272) | 9 | 7 | 6 | 28861 | 5 | ||
110230 | 42132 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 171 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42428 | 5998957.22367334 | 2093763.17021168 | 37.729014870842 | -122.445882895755 | (37.729014870842, -122.445882895755) | 9 | 7 | 4 | 28861 | 40 | ||
110243 | 42899 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2200 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | Permit Number 42815 | 5986138.5427207 | 2097288.78551671 | 37.737955001906 | -122.490456711772 | (37.737955001906, -122.490456711772) | 1 | 8 | 3 | 29491 | 35 | ||
110281 | 67889 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 217 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31586 | 6005100.28778176 | 2100163.31762382 | 37.7469370880579 | -122.425101042804 | (37.7469370880579, -122.425101042804) | 2 | 7 | 5 | 63 | 22 | ||
110311 | 65802 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2229 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28770 | 5990998.9640501 | 2100230.16806226 | 37.7463139697598 | -122.473866540085 | (37.7463139697598, -122.473866540085) | 1 | 8 | 4 | 29491 | 40 | ||
110572 | 56203 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 184 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1973 12:00:00 AM | Permit Number 12322 | 6007622.41344299 | 2100258.98375641 | 37.7473419182586 | -122.416386510472 | (37.7473419182586, -122.416386510472) | 2 | 7 | 7 | 28859 | 2 | |||
110778 | 62443 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4486 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22606 | 5999444.95917987 | 2105754.12577185 | 37.7619669848025 | -122.445058450512 | (37.7619669848025, -122.445058450512) | 15 | 5 | 5 | 28862 | 3 | ||
111037 | 100187 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 217 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | ||
112588 | 82741 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
112639 | 61979 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774514 | 6001287.16223059 | 2101175.19968833 | 37.749499333766 | -122.438358942397 | (37.749499333766, -122.438358942397) | 2 | 4 | 5 | 28862 | 22 | |||
112909 | 88718 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | 7 | 9 | 11 | 29492 | 10 | |
113393 | 42265 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1730 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42506 | 5987835.88750869 | 2103511.72763123 | 37.7551405372057 | -122.48504466581 | (37.7551405372057, -122.48504466581) | 1 | 8 | 3 | 56 | 35 | |||
114729 | 94064 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 4 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
114778 | 33541 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 213 BOCANA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37650 | 6007164 | 2097722 | 37.7403501394021 | -122.417791875043 | (37.7403501394021, -122.417791875043) | 2 | 7 | 7 | 28859 | 2 | |||
115200 | 83947 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 621 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50877 | 5993846.00894891 | 2107297.16077744 | 37.7658826019177 | -122.464534924027 | (37.7658826019177, -122.464534924027) | 11 | 8 | 11 | 56 | 12 | ||
115267 | 42901 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2200 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | Permit Number 42815 | 5986138.5427207 | 2097288.78551671 | 37.737955001906 | -122.490456711772 | (37.737955001906, -122.490456711772) | 1 | 8 | 3 | 29491 | 35 | ||
115343 | 32489 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 26 Uranus Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36996 | 5999299.5495957 | 2105598.47960948 | 37.7615313187924 | -122.445550170873 | (37.7615313187924, -122.445550170873) | 15 | 5 | 5 | 28862 | 3 | ||
115426 | 65680 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 223 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28600 | 5997900.25631717 | 2096664.39788468 | 37.736920541741 | -122.449745884352 | (37.736920541741, -122.449745884352) | 9 | 7 | 4 | 59 | 40 | ||
115714 | 33540 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 213 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37650 | 6007159.19506099 | 2097721.08233602 | 37.7403473492981 | -122.417808423627 | (37.7403473492981, -122.417808423627) | 2 | 7 | 7 | 28859 | 2 | |||
115833 | 36093 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500 16th St | 7 | 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 | |||
116378 | 4854 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 208X Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3x3 | 6000949.9317226 | 2097825.576354 | 37.7402828758816 | -122.439285032066 | (37.7402828758816, -122.439285032066) | 2 | 7 | 5 | 63 | 7 | |||
116736 | 13236 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2308 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6001297.71761 | 2119386.00749 | 37.7995022380504 | -122.439627803312 | (37.7995022380504, -122.439627803312) | 13 | 9 | 1 | 57 | 17 | |||
117013 | 97908 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002143 | 2119896 | 37.8009506172383 | -122.436739355692 | (37.8009506172383, -122.436739355692) | 13 | 9 | 1 | 57 | 17 | |||
117404 | 43562 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 406 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43223 | 6003924.16559982 | 2098981.19483718 | 37.7436247428067 | -122.429083695417 | (37.7436247428067, -122.429083695417) | 2 | 7 | 5 | 63 | 22 | ||
117921 | 69349 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002263.91991676 | 2119868.04210329 | 37.8008807234583 | -122.436318920048 | (37.8008807234583, -122.436318920048) | 13 | 9 | 1 | 57 | 17 |
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) );