trees
80 rows where Police Districts = 4 and qSpecies_id = 6 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15444 | 89331 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4658 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51984 | 6000201 | 2105201 | 37.7604913603716 | -122.4424038966 | (37.7604913603716, -122.4424038966) | 15 | 4 | 5 | 28862 | 3 | |||
47337 | 83396 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50820 | 6002600.50899636 | 2105341.51117361 | 37.7610136443426 | -122.43411515125 | (37.7610136443426, -122.43411515125) | 15 | 4 | 5 | 28862 | 3 | ||
148398 | 227552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002586.75589 | 2105341.84005 | 37.7610137667981 | -122.43416274072 | (37.7610137667981, -122.43416274072) | 15 | 4 | 5 | 28862 | 3 | |||
180998 | 227573 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4658 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000184.94355 | 2105205.65777 | 37.7605032342671 | -122.442459762729 | (37.7605032342671, -122.442459762729) | 15 | 4 | 5 | 28862 | 3 | |||
425 | 10157 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x7 | 6005745.76106 | 2103227.37374 | 37.7553867222415 | -122.423086804612 | (37.7553867222415, -122.423086804612) | 2 | 4 | 5 | 28859 | 19 | |||
618 | 238270 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 4102 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002298.332 | 2104734.40291 | 37.7593295173753 | -122.435116825204 | (37.7593295173753, -122.435116825204) | 2 | 4 | 5 | 28862 | 3 | |||
1839 | 227130 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5999573.30223 | 2100550.73469 | 37.7476870722101 | -122.444240631696 | (37.7476870722101, -122.444240631696) | 2 | 4 | 5 | 63 | 38 | |||
3377 | 227135 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 11 | : | Tree | Private 2 | 2 | Width 3ft | 5999460.85655 | 2100362.14837 | 37.7471628438967 | -122.444615908893 | (37.7471628438967, -122.444615908893) | 2 | 4 | 5 | 63 | 38 | |||
5680 | 227559 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6000741.27617 | 2104538.3206 | 37.7587025846742 | -122.44048780488 | (37.7587025846742, -122.44048780488) | 2 | 4 | 5 | 28862 | 38 | |||
8363 | 238269 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 4102 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002324.68279 | 2104735.52248 | 37.7593340877084 | -122.435025771543 | (37.7593340877084, -122.435025771543) | 2 | 4 | 5 | 28862 | 3 | |||
9616 | 92857 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1101 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 | |||
12985 | 229829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1472 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | Width 6ft | 6010097.10021 | 2100699.13339 | 37.7486893243481 | -122.407860213076 | (37.7486893243481, -122.407860213076) | 2 | 4 | 7 | 28859 | 19 | ||
13551 | 10193 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1170 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x2 | 6005736.25987 | 2102154.58599 | 37.7524405594089 | -122.423043415947 | (37.7524405594089, -122.423043415947) | 2 | 4 | 5 | 28859 | 19 | |||
16149 | 244604 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4020 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6002870 | 2104782 | 37.7594926524767 | -122.433143121723 | (37.7594926524767, -122.433143121723) | 2 | 4 | 5 | 28862 | 3 | |||
16319 | 258436 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4050 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002636 | 2104802 | 37.7595342910111 | -122.433953838093 | (37.7595342910111, -122.433953838093) | 2 | 4 | 5 | 28862 | 3 | ||||
17128 | 39895 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 290 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50795 | 6001095.73329197 | 2104700.06064199 | 37.7591668603211 | -122.439273525739 | (37.7591668603211, -122.439273525739) | 2 | 4 | 5 | 28862 | 3 | ||
22543 | 227116 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 133 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6006472.0378 | 2105330.58155 | 37.761202600143 | -122.420724416907 | (37.761202600143, -122.420724416907) | 2 | 4 | 7 | 28859 | 19 | |||
24824 | 227123 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002011.92527 | 2100876.50462 | 37.7487203851357 | -122.435831325762 | (37.7487203851357, -122.435831325762) | 2 | 4 | 5 | 28862 | 22 | |||
26064 | 227132 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 5 | : | Tree | Private 2 | 3 | Width 3ft | 5999561.91472 | 2100471.96222 | 37.7474701323504 | -122.444274349099 | (37.7474701323504, -122.444274349099) | 2 | 4 | 5 | 63 | 38 | |||
26995 | 227570 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 287 Hartford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002738.3349 | 2104276.75984 | 37.7580979146911 | -122.433562376711 | (37.7580979146911, -122.433562376711) | 2 | 4 | 5 | 28862 | 3 | |||
31711 | 227556 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000674.34081 | 2104608.13246 | 37.7588904593411 | -122.440724304978 | (37.7588904593411, -122.440724304978) | 2 | 4 | 5 | 28862 | 38 | |||
32952 | 37416 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1137 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51465 | 6001976.15825924 | 2100785.18555 | 37.7484676127991 | -122.435948474317 | (37.7484676127991, -122.435948474317) | 2 | 4 | 5 | 28862 | 22 | ||
35620 | 227157 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3330 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007941.59674 | 2104465.0078 | 37.7589086508255 | -122.41558053851 | (37.7589086508255, -122.41558053851) | 2 | 4 | 7 | 28859 | 19 | |||
36433 | 227134 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 10 | : | Tree | Private 2 | 3 | Width 3ft | 5999484.90108 | 2100375.94772 | 37.747202105595 | -122.444533756725 | (37.747202105595, -122.444533756725) | 2 | 4 | 5 | 63 | 38 | |||
43943 | 227551 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003034.11181 | 2104925.46753 | 37.7598958878974 | -122.432585790315 | (37.7598958878974, -122.432585790315) | 2 | 4 | 5 | 28862 | 3 | |||
44304 | 227096 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3639 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6006022.63157 | 2104312.28056 | 37.7583812443163 | -122.422206375532 | (37.7583812443163, -122.422206375532) | 2 | 4 | 5 | 28859 | 19 | |||
51475 | 227564 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4547 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000867.43951 | 2104613.62235 | 37.7589165280041 | -122.440056874944 | (37.7589165280041, -122.440056874944) | 2 | 4 | 5 | 28862 | 38 | |||
54301 | 227114 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1168 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008645.77837 | 2101760.16013 | 37.7515213083843 | -122.412953897625 | (37.7515213083843, -122.412953897625) | 2 | 4 | 7 | 28859 | 19 | |||
54415 | 224728 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 1110 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 771820 | 6009984.63313 | 2102660.33541 | 37.754068053508 | -122.408387439738 | (37.754068053508, -122.408387439738) | 2 | 4 | 7 | 28859 | 19 | |
55354 | 92858 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1101 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 | ||
59335 | 227553 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4445 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001135.34377 | 2105211.25899 | 37.760572740148 | -122.439173173223 | (37.760572740148, -122.439173173223) | 2 | 4 | 5 | 28862 | 3 | |||
60551 | 227567 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001758.47595 | 2103911.51009 | 37.7570393829676 | -122.436924995793 | (37.7570393829676, -122.436924995793) | 2 | 4 | 5 | 28862 | 3 | |||
71720 | 227560 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000737.03493 | 2104555.7602 | 37.7587502280493 | -122.440503723791 | (37.7587502280493, -122.440503723791) | 2 | 4 | 5 | 28862 | 38 | |||
75523 | 227127 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 105 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000615.36032 | 2102512.03507 | 37.7531317270504 | -122.440777928875 | (37.7531317270504, -122.440777928875) | 2 | 4 | 5 | 28862 | 22 | |||
80064 | 83344 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 4443-4445 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50816 | 6001265.82005399 | 2105215.83153824 | 37.7605927188575 | -122.43872224382 | (37.7605927188575, -122.43872224382) | 2 | 4 | 5 | 28862 | 3 | ||
101921 | 227133 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 9 | : | Tree | Private 2 | 4 | Width 3ft | 5999502.63692 | 2100390.28597 | 37.7472424869628 | -122.44447345809 | (37.7472424869628, -122.44447345809) | 2 | 4 | 5 | 63 | 38 | |||
108745 | 92226 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 587 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52664 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.415274584034 | (37.7590797904057, -122.415274584034) | 2 | 4 | 7 | 28859 | 19 | ||
109069 | 227555 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4611 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000604.66017 | 2104640.67953 | 37.7589758571809 | -122.440967627376 | (37.7589758571809, -122.440967627376) | 2 | 4 | 5 | 28862 | 38 | |||
109623 | 227566 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 Clover Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6000468.02748 | 2104951.63177 | 37.7598218728073 | -122.441462479323 | (37.7598218728073, -122.441462479323) | 2 | 4 | 5 | 28862 | 3 | |||
111414 | 227548 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 290 Jersey St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6003268.76291 | 2101573.30364 | 37.7507049460775 | -122.431534930712 | (37.7507049460775, -122.431534930712) | 2 | 4 | 5 | 28862 | 22 | |||
112005 | 227095 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3651 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6005946.52179 | 2104309.35666 | 37.7583689226977 | -122.422469389447 | (37.7583689226977, -122.422469389447) | 2 | 4 | 5 | 28859 | 19 | |||
123672 | 227562 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4567 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000777.25512 | 2104640.3736 | 37.7589848458951 | -122.440370692454 | (37.7589848458951, -122.440370692454) | 2 | 4 | 5 | 28862 | 38 | |||
126325 | 92859 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1101 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | 3x3 | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 | ||
127065 | 227546 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4281 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6001381.67551 | 2101715.76186 | 37.7509889636801 | -122.438070830104 | (37.7509889636801, -122.438070830104) | 2 | 4 | 5 | 28862 | 22 | |||
127998 | 227155 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3460 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007164.41586 | 2104418.82 | 37.7587381132978 | -122.418265124561 | (37.7587381132978, -122.418265124561) | 2 | 4 | 7 | 28859 | 19 | |||
135643 | 227554 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 359 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001158.33464 | 2104306.33401 | 37.7580893450524 | -122.439028803251 | (37.7580893450524, -122.439028803251) | 2 | 4 | 5 | 28862 | 3 | |||
136742 | 227158 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3318 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008087.45284 | 2104471.62086 | 37.7589350063619 | -122.415076566546 | (37.7589350063619, -122.415076566546) | 2 | 4 | 7 | 28859 | 19 | |||
142256 | 227131 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 3 | : | Tree | Private 2 | 3 | Width 3ft | 5999574.51262 | 2100531.90957 | 37.7476354520323 | -122.44423509368 | (37.7476354520323, -122.44423509368) | 2 | 4 | 5 | 63 | 38 | |||
142405 | 227565 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 290 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001097.22568 | 2104712.62438 | 37.7592014422066 | -122.439269264885 | (37.7592014422066, -122.439269264885) | 2 | 4 | 5 | 28862 | 3 | |||
144465 | 227561 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 84 Seward St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6000738.66154 | 2104570.78605 | 37.7587915779822 | -122.44049917592 | (37.7587915779822, -122.44049917592) | 2 | 4 | 5 | 28862 | 38 | |||
144527 | 227154 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 211 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006179.62036 | 2101927.37044 | 37.7518416864579 | -122.42149406392 | (37.7518416864579, -122.42149406392) | 2 | 4 | 5 | 28859 | 19 | |||
145480 | 102180 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769770 | 6001747.5 | 2103909.1 | 37.7570321415971 | -122.436962782195 | (37.7570321415971, -122.436962782195) | 2 | 4 | 5 | 28862 | 3 |
152823 | 227125 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Clipper St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002044.61682 | 2100877.86818 | 37.7487259861351 | -122.435718376327 | (37.7487259861351, -122.435718376327) | 2 | 4 | 5 | 28862 | 22 | |||
153442 | 227122 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1137 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6001978.98288 | 2100703.16052 | 37.7482425519531 | -122.435932838524 | (37.7482425519531, -122.435932838524) | 2 | 4 | 5 | 28862 | 22 | |||
154133 | 227547 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 780 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001390.11593 | 2102052.79607 | 37.7519148588942 | -122.438065782205 | (37.7519148588942, -122.438065782205) | 2 | 4 | 5 | 28862 | 22 | |||
159117 | 51978 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50788 | 6003031.54377055 | 2104930.91129788 | 37.7599106895436 | -122.432595060758 | (37.7599106895436, -122.432595060758) | 2 | 4 | 5 | 28862 | 3 | ||
162715 | 227569 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 287 Hartford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002739.75043 | 2104260.6213 | 37.7580536824469 | -122.433556327872 | (37.7580536824469, -122.433556327872) | 2 | 4 | 5 | 28862 | 3 | |||
164870 | 87861 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 96 Caselli Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50803 | 6000485.4 | 2104954.1 | 37.7598296396585 | -122.441402573572 | (37.7598296396585, -122.441402573572) | 2 | 4 | 5 | 28862 | 3 | ||
168688 | 227572 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 841 Church St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004362.06253 | 2104151.54801 | 37.7578461063327 | -122.427937906015 | (37.7578461063327, -122.427937906015) | 2 | 4 | 5 | 28862 | 3 | |||
168808 | 227549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3663 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003979.9607 | 2103616.2837 | 37.7563547731686 | -122.429221207098 | (37.7563547731686, -122.429221207098) | 2 | 4 | 5 | 28862 | 22 | |||
172352 | 227550 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3957 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003307.61262 | 2104748.70742 | 37.7594260532954 | -122.431627264983 | (37.7594260532954, -122.431627264983) | 2 | 4 | 5 | 28862 | 3 | |||
172497 | 227124 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002026.8924 | 2100876.99711 | 37.7487225875918 | -122.435779604843 | (37.7487225875918, -122.435779604843) | 2 | 4 | 5 | 28862 | 22 | |||
173829 | 227084 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1217 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010060.56336 | 2102014.94468 | 37.7523002058063 | -122.408079341009 | (37.7523002058063, -122.408079341009) | 2 | 4 | 7 | 28859 | 19 | |||
177211 | 102935 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 801X Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004394.3 | 2104124.7 | 37.7577742117678 | -122.427824502367 | (37.7577742117678, -122.427824502367) | 2 | 4 | 5 | 28862 | 3 | |||
178195 | 227115 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 587 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007890.87999 | 2104550.47449 | 37.7591404717772 | -122.415761992927 | (37.7591404717772, -122.415761992927) | 2 | 4 | 7 | 28859 | 19 | |||
181931 | 102200 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 579 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769774 | 6002583.2 | 2103808 | 37.7568020093443 | -122.434065390673 | (37.7568020093443, -122.434065390673) | 2 | 4 | 5 | 28862 | 3 |
183432 | 227156 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3458 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007201.92693 | 2104423.13266 | 37.7587520662717 | -122.418135699498 | (37.7587520662717, -122.418135699498) | 2 | 4 | 7 | 28859 | 19 | |||
187092 | 227571 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 579 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002573.48599 | 2103832.36646 | 37.7568683624992 | -122.434100727063 | (37.7568683624992, -122.434100727063) | 2 | 4 | 5 | 28862 | 3 | |||
187150 | 227568 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 287 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002743.27179 | 2104198.28781 | 37.7578827294299 | -122.433539694925 | (37.7578827294299, -122.433539694925) | 2 | 4 | 5 | 28862 | 3 | |||
188309 | 50524 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 3651 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2003 12:00:00 AM | Permit Number 47164 | 6005968.07304834 | 2104305.31315666 | 37.758359035924 | -122.422394568264 | (37.758359035924, -122.422394568264) | 2 | 4 | 5 | 28859 | 19 | ||
189609 | 227083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 770 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6008514.34527 | 2104071.33726 | 37.7578598992273 | -122.41357185686 | (37.7578598992273, -122.41357185686) | 2 | 4 | 7 | 28859 | 19 | |||
21439 | 227577 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 18 Dehon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 6003773.27056 | 2106456.0684 | 37.7641404406581 | -122.430138593823 | (37.7641404406581, -122.430138593823) | 8 | 4 | 5 | 28862 | 3 | |||
51502 | 94694 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 12 Dehon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771 | 2106542 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | 8 | 4 | 5 | 28862 | 3 | |
86722 | 94695 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 12 Dehon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771 | 2106542 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | 8 | 4 | 5 | 28862 | 3 | |
103589 | 49895 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1411 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46669 | 6007945.54854347 | 2107355.95750477 | 37.7668467518318 | -122.415771573837 | (37.7668467518318, -122.415771573837) | 8 | 4 | 7 | 28853 | 19 |
111067 | 227578 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 18 Dehon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6003773.29998 | 2106438.61168 | 37.7640925103737 | -122.430137246636 | (37.7640925103737, -122.430137246636) | 8 | 4 | 5 | 28862 | 3 | |||
131735 | 227081 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 71 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006508.23754 | 2108096.29045 | 37.7687986257867 | -122.420795571254 | (37.7687986257867, -122.420795571254) | 8 | 4 | 7 | 28853 | 19 | |||
138303 | 191219 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 318 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010580.39617 | 2106780.39752 | 37.7654141639451 | -122.406617457953 | (37.7654141639451, -122.406617457953) | 8 | 4 | 8 | 28853 | 19 | |||
140171 | 227080 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1405 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007868.4281 | 2107357.29935 | 37.7668461005058 | -122.416038416642 | (37.7668461005058, -122.416038416642) | 8 | 4 | 7 | 28853 | 19 | |||
172005 | 227579 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 77 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004499.29505 | 2107353.29779 | 37.7666451110058 | -122.427691415339 | (37.7666451110058, -122.427691415339) | 8 | 4 | 5 | 28862 | 3 |
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) );