trees
11,761 rows where qSpecies_id = 17 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29 | 264952 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 2 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
31 | 264951 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 1 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
74 | 106076 | Permitted Site 7 | Tree(s) :: 17 | 2500 Arelious Walker Dr | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 772788 | 6016510.6 | 2089868.7 | 37.7193080887588 | -122.384927739753 | (37.7193080887588, -122.384927739753) | 10 | 3 | 8 | 58 | 1 | ||||
81 | 46536 | Permitted Site 7 | Tree(s) :: 17 | 73 Summer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2002 12:00:00 AM | Permit Number 44686 | |||||||||||||
99 | 255073 | Private 9 | Tree(s) :: 17 | 173R Glenview Dr | Back Yard : Yard | Tree | Private 2 | ||||||||||||||||
108 | 44866 | Permitted Site 7 | Tree(s) :: 17 | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
109 | 34921 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
110 | 45916 | Permitted Site 7 | Tree(s) :: 17 | 51 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
111 | 97355 | Permitted Site 7 | Tree(s) :: 17 | 5 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
112 | 33929 | Permitted Site 7 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1997 12:00:00 AM | Permit Number 37893 | ||||||||||||||
129 | 107934 | DPW Maintained 1 | Tree(s) :: 17 | 3098X Market St | 3 | Median : Yard | Tree | DPW 1 | 5999920 | 2105144 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | 2 | 4 | 5 | 28862 | 3 | |||||
135 | 99586 | Permitted Site 7 | Tree(s) :: 17 | 2299 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002978.6 | 2106459.9 | 37.7641059209125 | -122.432887400675 | (37.7641059209125, -122.432887400675) | 15 | 4 | 5 | 28862 | 3 | |||||
148 | 108238 | Undocumented 4 | Tree(s) :: 17 | 764x JUNIPERO SERRA BLVD | 1 | Median : Yard | Tree | Private 2 | 5991289.6 | 2092496.8 | 37.7250969308873 | -122.472297921456 | (37.7250969308873, -122.472297921456) | 9 | 8 | 4 | 64 | 40 | |||||
158 | 100607 | Permitted Site 7 | Tree(s) :: 17 | 270x 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011410.5 | 2112131.8 | 37.7801542961347 | -122.404122955966 | (37.7801542961347, -122.404122955966) | 14 | 2 | 9 | 28853 | 34 | |||||
164 | 116129 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
171 | 50655 | Permitted Site 7 | Tree(s) :: 17 | 430 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47238 | 6008643.36799877 | 2088325.11427356 | 37.7146314352433 | -122.412012884014 | (37.7146314352433, -122.412012884014) | 9 | 7 | 8 | 309 | 18 | ||||
193 | 100595 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
195 | 101535 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46305 | 6014036.2 | 2116698.9 | 37.7928408582284 | -122.395359428861 | (37.7928408582284, -122.395359428861) | 12 | 2 | 9 | 28855 | 6 | ||||
203 | 56596 | Permitted Site 7 | Tree(s) :: 17 | 536 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003173.97949504 | 2096124.55404861 | 37.7357385703685 | -122.431473765394 | (37.7357385703685, -122.431473765394) | 2 | 7 | 5 | 63 | 7 | |||||
205 | 61223 | Permitted Site 7 | Tree(s) :: 17 | 420 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1983 12:00:00 AM | Permit Number 21092 | 6011911.40369591 | 2116824.99897206 | 37.793068691891 | -122.402720238707 | (37.793068691891, -122.402720238707) | 4 | 1 | 10 | 28854 | 6 | |||
220 | 64608 | Permitted Site 7 | Tree(s) :: 17 | 2449 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1988 12:00:00 AM | Permit Number 25511 | 6008240.06203716 | 2104170.72475134 | 37.75811738928 | -122.414527478763 | (37.75811738928, -122.414527478763) | 2 | 4 | 7 | 28859 | 19 | |||
222 | 59632 | Permitted Site 7 | Tree(s) :: 17 | 1726 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/1982 12:00:00 AM | Permit Number 19874 | 5999538.23629958 | 2110533.95574653 | 37.7750965176114 | -122.445079484139 | (37.7750965176114, -122.445079484139) | 15 | 5 | 11 | 29492 | 16 | |||
223 | 65500 | Permitted Site 7 | Tree(s) :: 17 | 5322 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/1989 12:00:00 AM | Permit Number 28384 | 5990524.68926015 | 2112731.41132738 | 37.7806115451711 | -122.47641956102 | (37.7806115451711, -122.47641956102) | 11 | 6 | 2 | 55 | 26 | |||
226 | 56655 | Permitted Site 7 | Tree(s) :: 17 | 491 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993749.22353597 | 2090472.28724098 | 37.7196801529508 | -122.463648462413 | (37.7196801529508, -122.463648462413) | 9 | 8 | 6 | 64 | 24 | |||||
227 | 102275 | Property Tree 8 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001225.6 | 2097744.2 | 37.7400751189117 | -122.438326054857 | (37.7400751189117, -122.438326054857) | 2 | 7 | 5 | 63 | 7 | ||||||
233 | 100684 | Undocumented 4 | Tree(s) :: 17 | 400 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6012367 | 2116823 | 37.7930886299645 | -122.401143699021 | (37.7930886299645, -122.401143699021) | 4 | 1 | 10 | 28854 | 6 | |||||
241 | 57687 | Permitted Site 7 | Tree(s) :: 17 | 4124 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/1976 12:00:00 AM | Permit Number 16590 | 6001721.25492757 | 2103540.26074256 | 37.7560179062476 | -122.437027141607 | (37.7560179062476, -122.437027141607) | 2 | 4 | 5 | 28862 | 3 | |||
260 | 56449 | Permitted Site 7 | Tree(s) :: 17 | 1439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5982754.68200032 | 2105326.56088651 | 37.7598262733968 | -122.502750996927 | (37.7598262733968, -122.502750996927) | 1 | 8 | 3 | 56 | 35 | |||||
271 | 107116 | DPW Maintained 1 | Tree(s) :: 17 | 300X LIBERTY ST | 18 | Median : Cutout | Tree | DPW 1 | 12 | 6004270.1 | 2103982.4 | 37.7573764628527 | -122.428243896062 | (37.7573764628527, -122.428243896062) | 2 | 4 | 5 | 28862 | 3 | ||||
273 | 117070 | Private 9 | Tree(s) :: 17 | 6 JOY ST | 3 | Front Yard : Yard | Tree | Private 2 | 6010444 | 2098901 | 37.7437714571602 | -122.406533939617 | (37.7437714571602, -122.406533939617) | 2 | 7 | 7 | 28859 | 2 | |||||
294 | 53493 | Permitted Site 7 | Tree(s) :: 17 | 262 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | Permit Number 6403 | 5992228.28376051 | 2089608.56362168 | 37.717220822263 | -122.468842940668 | (37.717220822263, -122.468842940668) | 9 | 8 | 6 | 64 | 24 | |||
305 | 56460 | Permitted Site 7 | Tree(s) :: 17 | 2430 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006920.19744074 | 2104198.59660265 | 37.7581196808576 | -122.419094125211 | (37.7581196808576, -122.419094125211) | 2 | 4 | 7 | 28859 | 19 | |||||
309 | 40920 | Permitted Site 7 | Tree(s) :: 17 | 720 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.7846879743619 | -122.401028836502 | (37.7846879743619, -122.401028836502) | 12 | 2 | 9 | 28853 | 6 | |||
333 | 44989 | Permitted Site 7 | Tree(s) :: 17 | 83 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
348 | 58983 | Permitted Site 7 | Tree(s) :: 17 | 585 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1980 12:00:00 AM | Permit Number 18272 | 5995294.04081777 | 2111581.66432509 | 37.7777300922573 | -122.45983690137 | (37.7777300922573, -122.45983690137) | 11 | 6 | 2 | 54 | 11 | |||
359 | 113255 | Undocumented 4 | Tree(s) :: 17 | 178 Edgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5996632.6 | 2106029.8 | 37.7625629978497 | -122.454805165139 | (37.7625629978497, -122.454805165139) | 15 | 5 | 11 | 29492 | 12 | |||||
361 | 107141 | Undocumented 4 | Tree(s) :: 17 | 3498 16TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003565.7 | 2106565.7 | 37.764429704069 | -122.430864344516 | (37.764429704069, -122.430864344516) | 15 | 4 | 5 | 28862 | 3 | ||||||
376 | 33627 | Permitted Site 7 | Tree(s) :: 17 | 315 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37728 | 6005028.27785393 | 2110030.93274628 | 37.7740271589488 | -122.426052389372 | (37.7740271589488, -122.426052389372) | 7 | 9 | 11 | 28852 | 10 | |||
407 | 56529 | Permitted Site 7 | Tree(s) :: 17 | 4721 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998571.81433707 | 2105652.41045975 | 37.7616378261686 | -122.448070980729 | (37.7616378261686, -122.448070980729) | 15 | 5 | 11 | 29492 | 12 | |||||
453 | 53634 | Permitted Site 7 | Tree(s) :: 17 | 4046 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1969 12:00:00 AM | Permit Number 6568 | 6003580.8041803 | 2100716.80543934 | 37.7483708836629 | -122.430394762659 | (37.7483708836629, -122.430394762659) | 2 | 4 | 5 | 28862 | 22 | |||
461 | 56448 | Permitted Site 7 | Tree(s) :: 17 | 1410 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5982800.36611702 | 2105511.04189371 | 37.7603354906122 | -122.502606655486 | (37.7603354906122, -122.502606655486) | 1 | 8 | 3 | 56 | 35 | |||||
462 | 33949 | Permitted Site 7 | Tree(s) :: 17 | 1238 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1997 12:00:00 AM | Permit Number 37907 | 5999468.65195546 | 2108623.71254321 | 37.7698475030127 | -122.445182824083 | (37.7698475030127, -122.445182824083) | 15 | 5 | 11 | 29492 | 9 | |||
492 | 44943 | Permitted Site 7 | Tree(s) :: 17 | 176 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
514 | 45011 | Permitted Site 7 | Tree(s) :: 17 | 93 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
517 | 30483 | Permitted Site 7 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1956 12:00:00 AM | Permit Number 147 | ||||||||||||||
521 | 100638 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
528 | 57932 | Permitted Site 7 | Tree(s) :: 17 | 583 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | Permit Number 16891 | 5999047.47505332 | 2086793.7936429 | 37.7098837148731 | -122.445070058439 | (37.7098837148731, -122.445070058439) | 9 | 7 | 6 | 28861 | 5 | |||
531 | 46009 | Permitted Site 7 | Tree(s) :: 17 | 195 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
542 | 35050 | Permitted Site 7 | Tree(s) :: 17 | 700 Peninsula Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1998 12:00:00 AM | Permit Number 38613 | |||||||||||||
548 | 48279 | Permitted Site 7 | Tree(s) :: 17 | 89 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
557 | 44837 | Permitted Site 7 | Tree(s) :: 17 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
622 | 48348 | Permitted Site 7 | Tree(s) :: 17 | 153 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
627 | 34919 | Permitted Site 7 | Tree(s) :: 17 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
650 | 46071 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2001 12:00:00 AM | Permit Number 44455 | ||||||||||||||
661 | 48170 | Permitted Site 7 | Tree(s) :: 17 | 63 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
676 | 44636 | Permitted Site 7 | Tree(s) :: 17 | 164 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
693 | 60435 | Permitted Site 7 | Tree(s) :: 17 | 471 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1982 12:00:00 AM | Permit Number 20019 | 6003532.89070287 | 2098907.31164333 | 37.7433997199793 | -122.430431357539 | (37.7433997199793, -122.430431357539) | 2 | 7 | 5 | 63 | 22 | |||
706 | 44899 | Permitted Site 7 | Tree(s) :: 17 | 133 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
721 | 46041 | Permitted Site 7 | Tree(s) :: 17 | 176 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
722 | 48068 | Permitted Site 7 | Tree(s) :: 17 | 234 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
747 | 59192 | Permitted Site 7 | Tree(s) :: 17 | 253 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1980 12:00:00 AM | Permit Number 18508 | 6001467.56641345 | 2096421.00019604 | 37.7364556803125 | -122.437394709055 | (37.7364556803125, -122.437394709055) | 2 | 7 | 5 | 63 | 7 | |||
777 | 84774 | Permitted Site 7 | Tree(s) :: 17 | 185 Berry St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | Permit No. 49299 | 6014606 | 2110554 | 37.7760000408576 | -122.392957754299 | (37.7760000408576, -122.392957754299) | 6 | 2 | 9 | 28856 | 20 | |||
778 | 61131 | Permitted Site 7 | Tree(s) :: 17 | 76 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/1983 12:00:00 AM | Permit Number 20983 | 5998241.83548559 | 2106883.25514995 | 37.7649985471459 | -122.449300920602 | (37.7649985471459, -122.449300920602) | 15 | 5 | 11 | 29492 | 9 | |||
783 | 56824 | Permitted Site 7 | Tree(s) :: 17 | 1787 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14055 | 5988492.53915334 | 2103043.35746657 | 37.7538927457413 | -122.482739478412 | (37.7538927457413, -122.482739478412) | 1 | 8 | 3 | 56 | 35 | |||
790 | 55179 | Permitted Site 7 | Tree(s) :: 17 | 2201 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1972 12:00:00 AM | Permit Number 11088 | |||||||||||||
793 | 64948 | Permitted Site 7 | Tree(s) :: 17 | 263 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/1989 12:00:00 AM | Permit Number 25979 | 6013492.3823467 | 2105864.52669583 | 37.763061873209 | -122.39648129263 | (37.763061873209, -122.39648129263) | 14 | 3 | 8 | 28856 | 29 | |||
794 | 44541 | Permitted Site 7 | Tree(s) :: 17 | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
841 | 44570 | Permitted Site 7 | Tree(s) :: 17 | 134 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
855 | 48153 | Permitted Site 7 | Tree(s) :: 17 | 263 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
870 | 65298 | Permitted Site 7 | Tree(s) :: 17 | 601 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1989 12:00:00 AM | Permit Number 28112 | 6004986.98138427 | 2104867.56644754 | 37.7598474581316 | -122.42582763941 | (37.7598474581316, -122.42582763941) | 2 | 4 | 5 | 28859 | 19 | |||
892 | 44903 | Permitted Site 7 | Tree(s) :: 17 | 137 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
904 | 48322 | Permitted Site 7 | Tree(s) :: 17 | 188 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
912 | 48169 | Permitted Site 7 | Tree(s) :: 17 | 62 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
921 | 61549 | Permitted Site 7 | Tree(s) :: 17 | 1129 Huff Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1984 12:00:00 AM | Permit Number 21507 | |||||||||||||
947 | 60023 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1982 12:00:00 AM | Permit Number 19510 | ||||||||||||||
949 | 38398 | Permitted Site 7 | Tree(s) :: 17 | 1000 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40450 | 6006538.75328643 | 2113902.05144478 | 37.7847415646224 | -122.421102312622 | (37.7847415646224, -122.421102312622) | 7 | 9 | 9 | 28858 | 36 | |||
960 | 45842 | Permitted Site 7 | Tree(s) :: 17 | 84 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
964 | 44568 | Permitted Site 7 | Tree(s) :: 17 | 141 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
972 | 58852 | Permitted Site 7 | Tree(s) :: 17 | 198 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1979 12:00:00 AM | Permit Number 18111 | 6007897.70750463 | 2097731.51362688 | 37.7404175243374 | -122.415255671137 | (37.7404175243374, -122.415255671137) | 2 | 7 | 7 | 28859 | 2 | |||
974 | 48301 | Permitted Site 7 | Tree(s) :: 17 | 167 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
983 | 44952 | Permitted Site 7 | Tree(s) :: 17 | 65 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1007 | 44545 | Permitted Site 7 | Tree(s) :: 17 | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1008 | 48288 | Permitted Site 7 | Tree(s) :: 17 | 98 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1011 | 45966 | Permitted Site 7 | Tree(s) :: 17 | 157 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
1035 | 44875 | Permitted Site 7 | Tree(s) :: 17 | 148 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1052 | 65988 | Permitted Site 7 | Tree(s) :: 17 | 121 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1990 12:00:00 AM | Permit Number 29018 | 5995709.58889373 | 2096251.06183698 | 37.7356600432467 | -122.457290053496 | (37.7356600432467, -122.457290053496) | 9 | 7 | 4 | 59 | 40 | |||
1064 | 44650 | Permitted Site 7 | Tree(s) :: 17 | 70 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1066 | 49147 | Permitted Site 7 | Tree(s) :: 17 | 201REVISED Elmira St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2003 12:00:00 AM | Permit Number 46271 | 6011255.32647148 | 2095465.44056571 | 37.7343834996245 | -122.40348689328 | (37.7343834996245, -122.40348689328) | 10 | 3 | 8 | 58 | 1 | |||
1091 | 44966 | Permitted Site 7 | Tree(s) :: 17 | 79 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1100 | 55205 | Permitted Site 7 | Tree(s) :: 17 | 44 Dalmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/1972 12:00:00 AM | Permit Number 11118 | |||||||||||||
1116 | 65831 | Permitted Site 7 | Tree(s) :: 17 | 2200 North Point | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1990 12:00:00 AM | Permit Number 28821 | |||||||||||||
1129 | 44885 | Permitted Site 7 | Tree(s) :: 17 | 158 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
1135 | 48105 | Permitted Site 7 | Tree(s) :: 17 | 215 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
1136 | 57990 | Permitted Site 7 | Tree(s) :: 17 | 19 Bausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/1977 12:00:00 AM | Permit Number 16955 | |||||||||||||
1148 | 33928 | Permitted Site 7 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1997 12:00:00 AM | Permit Number 37893 | ||||||||||||||
1162 | 36561 | Permitted Site 7 | Tree(s) :: 17 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1998 12:00:00 AM | Permit Number 39428 | ||||||||||||||
1165 | 44567 | Permitted Site 7 | Tree(s) :: 17 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1186 | 45889 | Permitted Site 7 | Tree(s) :: 17 | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
1208 | 54959 | Permitted Site 7 | Tree(s) :: 17 | 1571 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/1972 12:00:00 AM | Permit Number 10837 | 5982474.94240495 | 2104427.27217039 | 37.7573406377263 | -122.503651864556 | (37.7573406377263, -122.503651864556) | 1 | 8 | 3 | 56 | 35 | |||
1228 | 65998 | Permitted Site 7 | Tree(s) :: 17 | 2551 Beacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1990 12:00:00 AM | Permit Number 29030 |
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) );