trees
99 rows where Fire Prevention Districts = 2 and qSpecies_id = 133 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92777 | 247816 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 550 30th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003030.78831 | 2098349.34835 | 37.7418392269952 | -122.432127661269 | (37.7418392269952, -122.432127661269) | 2 | 7 | 5 | 63 | 22 | |||
25870 | 223054 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 701 Church St | 15 | Front Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6004339.17113 | 2104460.25399 | 37.7586924448242 | -122.428039072561 | (37.7586924448242, -122.428039072561) | 2 | 4 | 5 | 28862 | 3 | |||
110897 | 223053 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 701 Church St | 13 | Front Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 6004342.54387 | 2104435.23189 | 37.7586239308804 | -122.42802562499 | (37.7586239308804, -122.42802562499) | 2 | 4 | 5 | 28862 | 3 | |||
1435 | 68125 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 172 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31874 | 6006033.71828156 | 2099220.36912277 | 37.7444006509706 | -122.421806351312 | (37.7444006509706, -122.421806351312) | 2 | 7 | 5 | 28859 | 2 | ||
4563 | 223021 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006234.71683 | 2099501.18451 | 37.7451830394575 | -122.421131274692 | (37.7451830394575, -122.421131274692) | 2 | 7 | 7 | 28859 | 2 | |||
5637 | 223045 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008341.10325 | 2099446.02772 | 37.7451501107949 | -122.413843827126 | (37.7451501107949, -122.413843827126) | 2 | 7 | 7 | 28859 | 2 | |||
18410 | 68121 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 101 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31868 | 6006245.31002458 | 2099503.96919514 | 37.7451912827439 | -122.421094842871 | (37.7451912827439, -122.421094842871) | 2 | 7 | 7 | 28859 | 2 | ||
25370 | 28296 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1432 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2003 12:00:00 AM | 6 | 2X3 | 6005818.9272 | 2100626.68333 | 37.7482499542668 | -122.422648971496 | (37.7482499542668, -122.422648971496) | 2 | 4 | 5 | 28859 | 19 | ||
26466 | 34431 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38175 | 6002613.57489862 | 2096408.07550267 | 37.7364852770817 | -122.433431554421 | (37.7364852770817, -122.433431554421) | 2 | 7 | 5 | 63 | 7 | ||
26895 | 24597 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 451 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1996 12:00:00 AM | 6 | 3X3 | 6007425.33634 | 2097280.23764 | 37.7391518611665 | -122.416856984981 | (37.7391518611665, -122.416856984981) | 2 | 7 | 7 | 28859 | 2 | ||
27447 | 223034 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007664.49403 | 2096661.03983 | 37.7374651296141 | -122.415986246062 | (37.7374651296141, -122.415986246062) | 2 | 7 | 7 | 28859 | 2 | |||
31240 | 47741 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1384 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 45524 | 6010066.05430582 | 2101146.00958918 | 37.7499146097647 | -122.407999079784 | (37.7499146097647, -122.407999079784) | 2 | 4 | 7 | 28859 | 19 | ||
32772 | 255586 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 157 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006708 | 2105213 | 37.760893044988 | -122.419899978675 | (37.760893044988, -122.419899978675) | 2 | 4 | 7 | 28859 | 19 | ||||
32898 | 51448 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 326 Bocana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | Permit Number 47765 | 6006818.05257651 | 2097195.51767411 | 37.7388850615796 | -122.41895069494 | (37.7388850615796, -122.41895069494) | 2 | 7 | 7 | 28859 | 2 | |||
33319 | 54717 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 3609 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2002 12:00:00 AM | Permit Number 24726 | 6004298.03079874 | 2103629.31683929 | 37.756408560199 | -122.428122138519 | (37.756408560199, -122.428122138519) | 2 | 4 | 5 | 28862 | 22 | ||
34239 | 46345 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 382 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/2002 12:00:00 AM | Permit Number 44591 | 6005460.79581087 | 2101487.62598308 | 37.7505936931274 | -122.423948593876 | (37.7505936931274, -122.423948593876) | 2 | 4 | 5 | 28859 | 19 | ||
34836 | 58683 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 26 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23324 | 6006866.27520727 | 2097031.18211361 | 37.7384365478954 | -122.418772311755 | (37.7384365478954, -122.418772311755) | 2 | 7 | 7 | 28859 | 2 | ||
36175 | 68120 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 94 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31866 | 6006215.83488054 | 2099558.94321569 | 37.7453405673201 | -122.421200665955 | (37.7453405673201, -122.421200665955) | 2 | 7 | 5 | 28859 | 2 | ||
37816 | 62939 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 338 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23320 | 6006780.36050357 | 2097125.37030396 | 37.7386903299864 | -122.419076042669 | (37.7386903299864, -122.419076042669) | 2 | 7 | 7 | 28859 | 2 | ||
38562 | 66726 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 416 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31446 | 6003651.13955938 | 2102766.75784402 | 37.7540035558201 | -122.430297777513 | (37.7540035558201, -122.430297777513) | 2 | 4 | 5 | 28862 | 22 | ||
40601 | 223023 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006515.40022 | 2104174.73701 | 37.7580313639845 | -122.420492397202 | (37.7580313639845, -122.420492397202) | 2 | 4 | 7 | 28859 | 19 | |||
42650 | 68124 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 125 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31872 | 6006189.84017158 | 2099400.84484915 | 37.7449049995041 | -122.421279326768 | (37.7449049995041, -122.421279326768) | 2 | 7 | 7 | 28859 | 2 | ||
44249 | 24588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 820 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1996 12:00:00 AM | 20 | 3X3 | 6008195.26733 | 2097153.24719 | 37.7388464504963 | -122.414185921141 | (37.7388464504963, -122.414185921141) | 2 | 7 | 7 | 28859 | 2 | ||
44899 | 51539 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 4138 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.433383762609 | (37.7578376687282, -122.433383762609) | 2 | 4 | 5 | 28862 | 3 | ||
45934 | 69199 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1342 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33247 | 6009509.54623645 | 2101351.16759285 | 37.7504467544428 | -122.409938000531 | (37.7504467544428, -122.409938000531) | 2 | 4 | 7 | 28859 | 19 | ||
47287 | 82780 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 3946 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50814 | 6003353.51076321 | 2104798.51931181 | 37.7595654262957 | -122.43147208276 | (37.7595654262957, -122.43147208276) | 2 | 4 | 5 | 28862 | 3 | ||
48275 | 41698 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1 Mizpah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | 2 | 7 | 5 | 63 | 7 | ||
48817 | 41708 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42156 | 6002096.90165519 | 2096076.31860804 | 37.7355450223799 | -122.435194188204 | (37.7355450223799, -122.435194188204) | 2 | 7 | 5 | 63 | 7 | ||
52294 | 28791 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2737 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008967.21311 | 2102509.30076 | 37.7535963186214 | -122.411895265148 | (37.7535963186214, -122.411895265148) | 2 | 4 | 7 | 28859 | 19 | |||
52691 | 63792 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 4094 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24478 | 6003252.0069668 | 2101284.19573809 | 37.7499101740217 | -122.431572236451 | (37.7499101740217, -122.431572236451) | 2 | 4 | 5 | 28862 | 22 | ||
54361 | 62908 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 410 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23285 | 6007239.73762584 | 2097259.44248715 | 37.7390843209207 | -122.417497229597 | (37.7390843209207, -122.417497229597) | 2 | 7 | 7 | 28859 | 2 | ||
54373 | 223035 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 99 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008263.26696 | 2099462.20339 | 37.7451901540099 | -122.414114116572 | (37.7451901540099, -122.414114116572) | 2 | 7 | 7 | 28859 | 2 | |||
56077 | 51543 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 330 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2006 12:00:00 AM | Permit Number 47842 | 6006500.80110502 | 2104175.14616456 | 37.7580316646871 | -122.4205429163 | (37.7580316646871, -122.4205429163) | 2 | 4 | 7 | 28859 | 19 | ||
63437 | 60436 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 474 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/16/2004 12:00:00 AM | Permit Number 20020 | 6003505.36219814 | 2098957.85837164 | 37.7435369501722 | -122.430530149996 | (37.7435369501722, -122.430530149996) | 2 | 7 | 5 | 63 | 22 | ||
65845 | 223047 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3864 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6004003.36703 | 2102490.39098 | 37.7532646621477 | -122.429059987437 | (37.7532646621477, -122.429059987437) | 2 | 4 | 5 | 28862 | 22 | |||
66516 | 53193 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 44COLERIDGE Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/2006 12:00:00 AM | Permit Number 49130 | 6006839.19551401 | 2099757.71286836 | 37.7459214666672 | -122.419059278748 | (37.7459214666672, -122.419059278748) | 2 | 7 | 7 | 28859 | 2 | ||
70202 | 223024 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 979 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009975.92603 | 2103539.78877 | 37.756482348292 | -122.408479582484 | (37.756482348292, -122.408479582484) | 2 | 4 | 7 | 28859 | 19 | |||
70629 | 104352 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 304 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | Permit Number 770823 | 6001744.6 | 2103958.8 | 37.7571684409617 | -122.436976369496 | (37.7571684409617, -122.436976369496) | 2 | 4 | 5 | 28862 | 3 | |||
70967 | 28792 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2731 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008964.24348 | 2102548.86607 | 37.7537047894643 | -122.411908330514 | (37.7537047894643, -122.411908330514) | 2 | 4 | 7 | 28859 | 19 | |||
73339 | 51538 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 4138 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.433383762609 | (37.7578376687282, -122.433383762609) | 2 | 4 | 5 | 28862 | 3 | ||
76261 | 26484 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 154 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000987.64369 | 2098692.25572 | 37.7426647191989 | -122.439216742684 | (37.7426647191989, -122.439216742684) | 2 | 7 | 5 | 63 | 7 | |||
76572 | 223055 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 42 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002598.631 | 2096412.43412 | 37.7364963969952 | -122.433483533142 | (37.7364963969952, -122.433483533142) | 2 | 7 | 5 | 63 | 7 | |||
80974 | 62145 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 75 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | Permit Number 22258 | 6005427.84181989 | 2099597.4165714 | 37.7454017512266 | -122.423928154749 | (37.7454017512266, -122.423928154749) | 2 | 7 | 5 | 28859 | 22 | ||
85017 | 51537 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 4138 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.433383762609 | (37.7578376687282, -122.433383762609) | 2 | 4 | 5 | 28862 | 3 | ||
85025 | 48468 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1409 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/2002 12:00:00 AM | Permit Number 45831 | 6003303.13281599 | 2100036.19716336 | 37.7464863595987 | -122.431306366847 | (37.7464863595987, -122.431306366847) | 2 | 7 | 5 | 63 | 22 | ||
85167 | 223025 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 380 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005467.6636 | 2101500.58617 | 37.7506296665394 | -122.423925765973 | (37.7506296665394, -122.423925765973) | 2 | 4 | 5 | 28859 | 19 | |||
86127 | 32398 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 244 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 8 | Permit Number 36939 | 6005971.23324 | 2096091.59209 | 37.7358062077876 | -122.421800215602 | (37.7358062077876, -122.421800215602) | 2 | 7 | 7 | 28859 | 2 | |
91882 | 121558 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 400X Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6003675 | 2102779 | 37.7540385213778 | -122.430216135756 | (37.7540385213778, -122.430216135756) | 2 | 4 | 5 | 28862 | 22 | |||
92618 | 223022 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6006257.51967 | 2099541.04409 | 37.7452937702941 | -122.42105525589 | (37.7452937702941, -122.42105525589) | 2 | 7 | 7 | 28859 | 2 | |||
96900 | 62944 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 33 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23326 | 6006898.05353177 | 2097079.16721331 | 37.7385700935458 | -122.41866583942 | (37.7385700935458, -122.41866583942) | 2 | 7 | 7 | 28859 | 2 | ||
99489 | 68122 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 109 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31870 | 6006226.82006776 | 2099469.59440232 | 37.7450958550009 | -122.42115633768 | (37.7450958550009, -122.42115633768) | 2 | 7 | 7 | 28859 | 2 | ||
105415 | 54097 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 121 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1995 12:00:00 AM | Permit Number 9824 | 6000463.76381209 | 2104868.98714017 | 37.7595947080418 | -122.441471294748 | (37.7595947080418, -122.441471294748) | 2 | 4 | 5 | 28862 | 3 | ||
111061 | 223026 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 114 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004706.47094 | 2102901.67728 | 37.7544337331488 | -122.426657794828 | (37.7544337331488, -122.426657794828) | 2 | 4 | 5 | 28862 | 22 | |||
111443 | 62943 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 32 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23325 | 6006886.21663048 | 2097028.33083041 | 37.738429841676 | -122.418703161695 | (37.738429841676, -122.418703161695) | 2 | 7 | 7 | 28859 | 2 | ||
111603 | 62913 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 503 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23293 | 6007737.75654809 | 2096994.92041001 | 37.7383860110425 | -122.41575657686 | (37.7383860110425, -122.41575657686) | 2 | 7 | 7 | 28859 | 2 | ||
114823 | 223042 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006921.22556 | 2096271.82147 | 37.7363546053902 | -122.418528488295 | (37.7363546053902, -122.418528488295) | 2 | 7 | 7 | 28859 | 2 | |||
115399 | 61289 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 424 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1994 12:00:00 AM | Permit Number 21181 | 6007345.32477323 | 2097244.32339637 | 37.7390487477576 | -122.417131085359 | (37.7390487477576, -122.417131085359) | 2 | 7 | 7 | 28859 | 2 | ||
116102 | 223039 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007708.38718 | 2096815.60919 | 37.7378920108046 | -122.415845428432 | (37.7378920108046, -122.415845428432) | 2 | 7 | 7 | 28859 | 2 | |||
116769 | 24553 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 404 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6007222.65374 | 2097265.29025 | 37.7390994163072 | -122.417556712385 | (37.7390994163072, -122.417556712385) | 2 | 7 | 7 | 28859 | 2 | |||
123118 | 67138 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 453 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1994 12:00:00 AM | Permit Number 30567 | 6007391.81828007 | 2097290.23033564 | 37.739177413508 | -122.416973583395 | (37.739177413508, -122.416973583395) | 2 | 7 | 7 | 28859 | 2 | ||
123656 | 223036 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2743 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008969.13541 | 2102480.10351 | 37.7535162573804 | -122.411886554326 | (37.7535162573804, -122.411886554326) | 2 | 4 | 7 | 28859 | 19 | |||
123767 | 223041 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 408 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | Permit Number 776709 | 6007256.61829 | 2097259.39898 | 37.7390851512711 | -122.417438860719 | (37.7390851512711, -122.417438860719) | 2 | 7 | 7 | 28859 | 2 | ||
126962 | 62916 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23296 | 6007721.5198304 | 2096821.74854603 | 37.7379096064175 | -122.415800456905 | (37.7379096064175, -122.415800456905) | 2 | 7 | 7 | 28859 | 2 | ||
128211 | 223056 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 191 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004346.64046 | 2097517.13802 | 37.7396286835145 | -122.427518598925 | (37.7396286835145, -122.427518598925) | 2 | 7 | 5 | 63 | 7 | |||
132029 | 121560 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 400X Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6003675 | 2102779 | 37.7540385213778 | -122.430216135756 | (37.7540385213778, -122.430216135756) | 2 | 4 | 5 | 28862 | 22 | |||
137974 | 24556 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 416 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6007294.81147 | 2097256.19199 | 37.739078494466 | -122.417306578558 | (37.739078494466, -122.417306578558) | 2 | 7 | 7 | 28859 | 2 | |||
139743 | 223040 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 567 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007699.61186 | 2096703.50741 | 37.7375837106174 | -122.415867833228 | (37.7375837106174, -122.415867833228) | 2 | 7 | 7 | 28859 | 2 | |||
141735 | 61288 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 402 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23284 | 6007176.62571904 | 2097268.48245659 | 37.7391055913487 | -122.417716082945 | (37.7391055913487, -122.417716082945) | 2 | 7 | 7 | 28859 | 2 | ||
142629 | 51536 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 4138 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.433383762609 | (37.7578376687282, -122.433383762609) | 2 | 4 | 5 | 28862 | 3 | ||
142812 | 24587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 804 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1996 12:00:00 AM | 18 | 3X3 | 6008146.87115 | 2097150.77398 | 37.738836941075 | -122.414353078142 | (37.738836941075, -122.414353078142) | 2 | 7 | 7 | 28859 | 2 | ||
143896 | 62940 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 355 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23321 | 6006807.32064873 | 2097065.68374167 | 37.7385279621224 | -122.418978594844 | (37.7385279621224, -122.418978594844) | 2 | 7 | 7 | 28859 | 2 | ||
144447 | 223037 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002071.56022 | 2096098.27883 | 37.7356038810064 | -122.435283373351 | (37.7356038810064, -122.435283373351) | 2 | 7 | 5 | 63 | 7 | |||
149638 | 223046 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 77 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005471.50149 | 2099604.561 | 37.7454238329391 | -122.423777694396 | (37.7454238329391, -122.423777694396) | 2 | 7 | 5 | 28859 | 22 | |||
151854 | 223032 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 281 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006256.18709 | 2096109.4549 | 37.7358713204894 | -122.420816284439 | (37.7358713204894, -122.420816284439) | 2 | 7 | 7 | 28859 | 2 | |||
152595 | 60133 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 214 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2012 12:00:00 AM | Permit Number 768747 | 6003532.52706643 | 2096003.65082334 | 37.7354269125656 | -122.430225504542 | (37.7354269125656, -122.430225504542) | 2 | 7 | 5 | 63 | 7 | ||
152981 | 62937 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 324 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23318 | 6006824.33458428 | 2097207.20889429 | 37.7389175168089 | -122.418929803603 | (37.7389175168089, -122.418929803603) | 2 | 7 | 7 | 28859 | 2 | ||
154287 | 41697 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1 Mizpah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | 2 | 7 | 5 | 63 | 7 | ||
155068 | 255587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 157 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006708 | 2105213 | 37.760893044988 | -122.419899978675 | (37.760893044988, -122.419899978675) | 2 | 4 | 7 | 28859 | 19 | ||||
155351 | 62920 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23300 | 6007655.13385737 | 2096670.74814693 | 37.7374912602593 | -122.41601929598 | (37.7374912602593, -122.41601929598) | 2 | 7 | 7 | 28859 | 2 | ||
156398 | 41696 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1 Mizpah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | 2 | 7 | 5 | 63 | 7 | ||
159418 | 51449 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 326 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | Permit Number 47765 | 6006818.05257651 | 2097195.51767411 | 37.7388850615796 | -122.41895069494 | (37.7388850615796, -122.41895069494) | 2 | 7 | 7 | 28859 | 2 | |||
164350 | 62909 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 414 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23286 | 6007271.29358338 | 2097254.92250183 | 37.7390736855529 | -122.417387802956 | (37.7390736855529, -122.417387802956) | 2 | 7 | 7 | 28859 | 2 | ||
165574 | 65260 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1153 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 28059 | 6009500.12226017 | 2102463.02471256 | 37.7534991381214 | -122.410049073844 | (37.7534991381214, -122.410049073844) | 2 | 4 | 7 | 28859 | 19 | ||
165972 | 34344 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1325 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38101 | 6010099.44079349 | 2101484.52277039 | 37.7508459613928 | -122.407907495355 | (37.7508459613928, -122.407907495355) | 2 | 4 | 7 | 28859 | 19 | ||
166632 | 47955 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 59 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2002 12:00:00 AM | Permit Number 45685 | 6001000.20919275 | 2101375.03881203 | 37.7500317183297 | -122.439365554728 | (37.7500317183297, -122.439365554728) | 2 | 4 | 5 | 28862 | 22 | |||
167261 | 87776 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 333 Sussex St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50481 | 6001129 | 2096659 | 37.737089918679 | -122.438582321394 | (37.737089918679, -122.438582321394) | 2 | 7 | 5 | 63 | 7 | |||
169071 | 62941 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 357 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23322 | 6006800.83841041 | 2097053.62300346 | 37.7384944809927 | -122.419000152151 | (37.7384944809927, -122.419000152151) | 2 | 7 | 7 | 28859 | 2 | ||
169683 | 41707 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 203 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42156 | 6002096.90165519 | 2096076.31860804 | 37.7355450223799 | -122.435194188204 | (37.7355450223799, -122.435194188204) | 2 | 7 | 5 | 63 | 7 | ||
171056 | 223027 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 116 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6004711.20676 | 2102860.50548 | 37.754320952762 | -122.426638485476 | (37.754320952762, -122.426638485476) | 2 | 4 | 5 | 28862 | 22 | |||
171197 | 223102 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 247 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779888 | 6004283.79281 | 2099537.35517 | 37.7451721819657 | -122.427879813411 | (37.7451721819657, -122.427879813411) | 2 | 7 | 5 | 63 | 22 | |
171276 | 223044 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008324.57166 | 2099444.87133 | 37.7451460071793 | -122.413900908902 | (37.7451460071793, -122.413900908902) | 2 | 7 | 7 | 28859 | 2 | |||
176527 | 223048 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3880 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6003922.51538 | 2102484.70879 | 37.7532444831531 | -122.429339183778 | (37.7532444831531, -122.429339183778) | 2 | 4 | 5 | 28862 | 22 | |||
177067 | 223038 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 10 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002089.19721 | 2096067.16423 | 37.7355194490575 | -122.435220170783 | (37.7355194490575, -122.435220170783) | 2 | 7 | 5 | 63 | 7 | |||
177885 | 223020 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 125 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6006199.74889 | 2099432.38497 | 37.7449921601655 | -122.421247303447 | (37.7449921601655, -122.421247303447) | 2 | 7 | 7 | 28859 | 2 | |||
178314 | 223033 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 281 Richland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006248.27078 | 2096110.49551 | 37.7358737315714 | -122.420843728155 | (37.7358737315714, -122.420843728155) | 2 | 7 | 7 | 28859 | 2 | |||
178830 | 251786 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 300 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195 | 2098242 | 37.7417233638646 | -122.421179213365 | (37.7417233638646, -122.421179213365) | 2 | 7 | 7 | 28859 | 2 | ||
183578 | 35403 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 550 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38858 | 6003059.40190018 | 2098358.03858994 | 37.7418647106265 | -122.432029345324 | (37.7418647106265, -122.432029345324) | 2 | 7 | 5 | 63 | 22 | ||
187755 | 37459 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 30 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39931 | 6010620.6907028 | 2100238.51379536 | 37.7474538625831 | -122.40601718747 | (37.7474538625831, -122.40601718747) | 2 | 7 | 7 | 28859 | 2 | ||
192031 | 87775 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 333 Sussex St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50481 | 6001129 | 2096659 | 37.737089918679 | -122.438582321394 | (37.737089918679, -122.438582321394) | 2 | 7 | 5 | 63 | 7 |
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) );