trees
493 rows where qSpecies_id = 133 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64516 | 40751 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 54 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.72655370366 | -122.46791340088 | (37.72655370366, -122.46791340088) | 9 | 8 | 4 | 59 | 40 | ||
113884 | 206558 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 517 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995506.85137 | 2100151.86426 | 37.7463590370584 | -122.458273237436 | (37.7463590370584, -122.458273237436) | 1 | 5 | 4 | 59 | 40 | |||
134750 | 206557 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 517 Laguna Honda Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995503.23656 | 2100160.44134 | 37.7463823798599 | -122.458286357642 | (37.7463823798599, -122.458286357642) | 1 | 5 | 4 | 59 | 40 | |||
37635 | 206573 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993216.90415 | 2099626.41246 | 37.7447844257663 | -122.466153363383 | (37.7447844257663, -122.466153363383) | 1 | 8 | 4 | 29491 | 40 | |||
114209 | 206572 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | 1 | 8 | 4 | 29491 | 40 | |||
159238 | 206571 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993219.18082 | 2099666.63445 | 37.7448949964991 | -122.466148413523 | (37.7448949964991, -122.466148413523) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||
14886 | 51359 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 50 Pomona St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014112.78564 | 2094416.99761 | 37.7316638818713 | -122.393534297068 | (37.7316638818713, -122.393534297068) | 10 | 3 | 8 | 58 | 1 |
80368 | 51358 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 50 Pomona St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014110.4538 | 2094404.71931 | 37.7316300385939 | -122.393541499766 | (37.7316300385939, -122.393541499766) | 10 | 3 | 8 | 58 | 1 |
152397 | 78332 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 50 Pomona St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52305 | 6014106.86245 | 2094390.75811 | 37.7315915044312 | -122.393552939125 | (37.7315915044312, -122.393552939125) | 10 | 3 | 8 | 58 | 1 |
153668 | 51360 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 50 Pomona St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014114.6767 | 2094431.72556 | 37.7317044268964 | -122.39352878962 | (37.7317044268964, -122.39352878962) | 10 | 3 | 8 | 58 | 1 |
128619 | 206610 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Sola Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994851.29052 | 2100738.8321 | 37.7479330107067 | -122.46058260112 | (37.7479330107067, -122.46058260112) | 1 | 8 | 4 | 29491 | 40 | |||
156321 | 206611 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Sola Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994869.30829 | 2100730.97603 | 37.7479124764813 | -122.460519727717 | (37.7479124764813, -122.460519727717) | 1 | 8 | 4 | 29491 | 40 | |||
194061 | 206612 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Sola Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994889.66342 | 2100721.49656 | 37.7478876192364 | -122.460448654307 | (37.7478876192364, -122.460448654307) | 1 | 8 | 4 | 29491 | 40 | |||
74334 | 244873 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000342.3248 | 2109115.5777 | 37.7712478709156 | -122.442196132801 | (37.7712478709156, -122.442196132801) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
77345 | 206554 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 47 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993895.61602 | 2101166.11299 | 37.7490511881613 | -122.463918266634 | (37.7490511881613, -122.463918266634) | 1 | 8 | 4 | 29491 | 40 | |||
161052 | 206555 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 47 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5993893.29504 | 2101174.89341 | 37.7490751632062 | -122.463926929805 | (37.7490751632062, -122.463926929805) | 1 | 8 | 4 | 29491 | 40 | |||
54746 | 143086 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 459 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010641.4481 | 2120294.7479 | 37.8025247902186 | -122.407359099343 | (37.8025247902186, -122.407359099343) | 3 | 1 | 10 | 308 | 23 | |||
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 | ||
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 | ||
114722 | 218122 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Lopez Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5994032.10421 | 2100668.86964 | 37.7476937487685 | -122.463410213512 | (37.7476937487685, -122.463410213512) | 1 | 8 | 4 | 29491 | 40 | |||
193008 | 218121 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Lopez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5994024.91011 | 2100655.57636 | 37.7476568343048 | -122.463434125583 | (37.7476568343048, -122.463434125583) | 1 | 8 | 4 | 29491 | 40 | |||
132506 | 223049 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002666.83309 | 2105626.92623 | 37.7618010890622 | -122.433906166852 | (37.7618010890622, -122.433906166852) | 15 | 4 | 5 | 28862 | 3 | |||
61748 | 206655 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994255.40167 | 2101538.85258 | 37.7500953640099 | -122.462701170033 | (37.7500953640099, -122.462701170033) | 1 | 8 | 4 | 29491 | 40 | |||
149954 | 206654 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Alton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994247.90783 | 2101537.24109 | 37.7500905076701 | -122.462726967074 | (37.7500905076701, -122.462726967074) | 1 | 8 | 4 | 29491 | 40 | |||
155431 | 206656 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Alton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994277.82387 | 2101540.85875 | 37.7501021637853 | -122.46262377888 | (37.7501021637853, -122.46262377888) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||
111308 | 206609 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 44 Sola Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994867.72907 | 2100768.79557 | 37.7480162285692 | -122.460527928626 | (37.7480162285692, -122.460527928626) | 1 | 8 | 4 | 29491 | 40 | |||
25861 | 206613 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 432 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995024.84981 | 2100327.10403 | 37.7468124923186 | -122.459952623323 | (37.7468124923186, -122.459952623323) | 1 | 8 | 4 | 29491 | 40 | |||
102548 | 206614 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 432 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995034.15561 | 2100336.79731 | 37.7468396428317 | -122.459921147044 | (37.7468396428317, -122.459921147044) | 1 | 8 | 4 | 29491 | 40 | |||
150332 | 31296 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 431 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 4 | Permit Number 34940 | 5991578.61319 | 2097704.4347 | 37.7394125098801 | -122.471678172112 | (37.7394125098801, -122.471678172112) | 1 | 8 | 4 | 29491 | 40 | |
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 | ||
108499 | 218322 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 420 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5993190.15092 | 2099959.3697 | 37.7456970982494 | -122.466270063011 | (37.7456970982494, -122.466270063011) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||
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 | |||
146731 | 223028 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 42 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998401.23132 | 2106021.8866 | 37.7626425622232 | -122.448687567871 | (37.7626425622232, -122.448687567871) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
157257 | 223043 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 4107 Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008381.78974 | 2096055.87054 | 37.7358437688638 | -122.413463422917 | (37.7358437688638, -122.413463422917) | 10 | 7 | 7 | 28859 | 2 | |||
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 | ||
40920 | 206659 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994198.61036 | 2101541.1054 | 37.750098278721 | -122.462897719553 | (37.750098278721, -122.462897719553) | 1 | 8 | 4 | 29491 | 40 | |||
48224 | 206660 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994227.71262 | 2101539.78712 | 37.7500963352778 | -122.462796987411 | (37.7500963352778, -122.462796987411) | 1 | 8 | 4 | 29491 | 40 | |||
98018 | 206657 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994149.03126 | 2101531.53277 | 37.7500691388799 | -122.463068471138 | (37.7500691388799, -122.463068471138) | 1 | 8 | 4 | 29491 | 40 | |||
103756 | 206658 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994157.02115 | 2101539.85513 | 37.7500924502117 | -122.463041445619 | (37.7500924502117, -122.463041445619) | 1 | 8 | 4 | 29491 | 40 | |||
151204 | 52741 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 409@ ALTON Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2006 12:00:00 AM | Permit Number 48790 | 5994026.96721275 | 2101530.61038788 | 37.7500595741159 | -122.463490505234 | (37.7500595741159, -122.463490505234) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||
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 | ||
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 | |||
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 | ||
39404 | 206537 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 401 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994067.3294 | 2101503.80633 | 37.7499883024325 | -122.46334898679 | (37.7499883024325, -122.46334898679) | 1 | 8 | 4 | 29491 | 40 | |||
58588 | 206536 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 401 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994052.44062 | 2101520.15999 | 37.7500323476354 | -122.463401659183 | (37.7500323476354, -122.463401659183) | 1 | 8 | 4 | 29491 | 40 | |||
27571 | 69506 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 401 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33632 | 6008948.22977241 | 2096437.66011224 | 37.7369238689745 | -122.411531974789 | (37.7369238689745, -122.411531974789) | 10 | 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 | |||
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 | |||
17056 | 206626 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 40 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994084.99265 | 2101862.22446 | 37.7509734449922 | -122.463313912312 | (37.7509734449922, -122.463313912312) | 1 | 8 | 4 | 29491 | 40 | |||
167005 | 206627 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 40 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994076.75455 | 2101874.65457 | 37.7510071002966 | -122.463343302157 | (37.7510071002966, -122.463343302157) | 1 | 8 | 4 | 29491 | 40 | |||
8606 | 190946 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 40 Bluxome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6013405.51497 | 2110852.0091 | 37.7767515500726 | -122.397131477343 | (37.7767515500726, -122.397131477343) | 6 | 2 | 9 | 28856 | 34 | |||
157044 | 206570 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 4 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993230.10677 | 2099675.67045 | 37.7449204374235 | -122.46611129043 | (37.7449204374235, -122.46611129043) | 1 | 8 | 4 | 29491 | 40 | |||
140646 | 206538 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 399 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994103.27732 | 2101446.93652 | 37.7498342233673 | -122.463220551898 | (37.7498342233673, -122.463220551898) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||
16321 | 206539 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 393 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994118.07071 | 2101419.5251 | 37.749759810788 | -122.463167407365 | (37.749759810788, -122.463167407365) | 1 | 8 | 4 | 29491 | 40 | |||
27348 | 206661 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 390 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994161.93741 | 2101486.33597 | 37.7499457833913 | -122.463020562465 | (37.7499457833913, -122.463020562465) | 1 | 8 | 4 | 29491 | 40 | |||
158137 | 206662 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 390 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994173.63187 | 2101468.04914 | 37.7498962460271 | -122.462978796147 | (37.7498962460271, -122.462978796147) | 1 | 8 | 4 | 29491 | 40 | |||
170380 | 206663 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 390 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994181.82756 | 2101452.31219 | 37.7498535084399 | -122.462949313674 | (37.7498535084399, -122.462949313674) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
68672 | 206540 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 387 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994134.95664 | 2101369.7507 | 37.7496241156629 | -122.463105404514 | (37.7496241156629, -122.463105404514) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
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 | ||
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 | |||
140400 | 223031 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 38 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5998471.48427 | 2106911.98504 | 37.7650905653978 | -122.448508695418 | (37.7650905653978, -122.448508695418) | 15 | 5 | 11 | 29492 | 9 | |||
48825 | 116196 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 3751 CLAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996888 | 2115293 | 37.7880119756846 | -122.454591065245 | (37.7880119756846, -122.454591065245) | 11 | 6 | 1 | 54 | 31 | ||||
189944 | 116195 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 3751 CLAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996888 | 2115293 | 37.7880119756846 | -122.454591065245 | (37.7880119756846, -122.454591065245) | 11 | 6 | 1 | 54 | 31 | ||||
158228 | 206541 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 375 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994147.31458 | 2101302.53521 | 37.7494402708691 | -122.463057794403 | (37.7494402708691, -122.463057794403) | 1 | 8 | 4 | 29491 | 40 | |||
47801 | 206671 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 370 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995266.43425 | 2095204.88442 | 37.732762033223 | -122.458746484089 | (37.732762033223, -122.458746484089) | 9 | 7 | 4 | 59 | 40 | |||
80109 | 206672 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 370 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995263.98331 | 2095214.43939 | 37.732788127969 | -122.458755649049 | (37.732788127969, -122.458755649049) | 9 | 7 | 4 | 59 | 40 | |||
139505 | 206673 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 370 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995261.57654 | 2095226.10502 | 37.7328200206111 | -122.458764814062 | (37.7328200206111, -122.458764814062) | 9 | 7 | 4 | 59 | 40 | |||
59731 | 206585 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 368 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993961.34204 | 2099692.54098 | 37.745008919941 | -122.463584056983 | (37.745008919941, -122.463584056983) | 1 | 8 | 4 | 29491 | 40 | |||
190886 | 47755 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 364St. Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2002 12:00:00 AM | Permit Number 45535 | 5994004.07072151 | 2099729.00956261 | 37.7451115153754 | -122.463438956035 | (37.7451115153754, -122.463438956035) | 1 | 8 | 4 | 29491 | 40 | |||
168589 | 183679 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3627 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5984438.7811 | 2106305.4338 | 37.7626128114068 | -122.496998863919 | (37.7626128114068, -122.496998863919) | 1 | 8 | 3 | 56 | 35 | |||
14146 | 41229 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3618 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 5 | 3x3 | Permit Number 41935 | 6002621.77288 | 2121066.97203 | 37.8041929962699 | -122.435166401228 | (37.8041929962699, -122.435166401228) | 13 | 9 | 1 | 57 | 17 |
55830 | 41230 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3618 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 6 | 3x3 | Permit Number 41935 | 6002625.18254 | 2121047.68706 | 37.804140238442 | -122.435153221671 | (37.804140238442, -122.435153221671) | 13 | 9 | 1 | 57 | 17 |
92863 | 47756 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 360St. Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2002 12:00:00 AM | Permit Number 45536 | 5994029.42937676 | 2099753.03047002 | 37.7451789317369 | -122.463353013703 | (37.7451789317369, -122.463353013703) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||
12800 | 206586 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 360 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993997.55659 | 2099722.78299 | 37.7450940434634 | -122.463461028807 | (37.7450940434634, -122.463461028807) | 1 | 8 | 4 | 29491 | 40 | |||
160958 | 46178 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 36 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44505 | 5998475.49358611 | 2106915.81544951 | 37.7651013119743 | -122.448495104116 | (37.7651013119743, -122.448495104116) | 15 | 5 | 11 | 29492 | 9 | ||
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 | ||
19680 | 206561 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995302.34368 | 2095238.16689 | 37.732855482695 | -122.458624745542 | (37.732855482695, -122.458624745542) | 9 | 7 | 4 | 59 | 40 | |||
66765 | 206560 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995304.48103 | 2095229.25095 | 37.7328311245367 | -122.458616711016 | (37.7328311245367, -122.458616711016) | 9 | 7 | 4 | 59 | 40 | |||
110640 | 206559 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995306.63453 | 2095221.10602 | 37.7328088843117 | -122.458608676455 | (37.7328088843117, -122.458608676455) | 9 | 7 | 4 | 59 | 40 | |||
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 | ||
133847 | 206553 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 352 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5994206.92878 | 2101186.05332 | 37.74912387497 | -122.462843199074 | (37.74912387497, -122.462843199074) | 1 | 8 | 4 | 29491 | 40 | |||
161629 | 206542 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 351 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994154.36407 | 2101104.38684 | 37.7488966118001 | -122.46301904262 | (37.7488966118001, -122.46301904262) | 1 | 8 | 4 | 29491 | 40 | |||
63519 | 206524 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992940.67499 | 2098878.9332 | 37.7427160965819 | -122.467054169341 | (37.7427160965819, -122.467054169341) | 1 | 8 | 4 | 59 | 40 | |||
71121 | 206526 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992953.91132 | 2098913.47299 | 37.7428116981042 | -122.467010912843 | (37.7428116981042, -122.467010912843) | 1 | 8 | 4 | 59 | 40 |
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) );