trees
720 rows where qSpecies_id = 127 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
659 | 11520 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 6 | 3X3 | 6018495.90717 | 2096693.85175 | 37.738158246093 | -122.378538834904 | (37.738158246093, -122.378538834904) | 10 | 3 | 8 | 58 | 1 | ||
690 | 19651 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
750 | 11540 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018782.49291 | 2097080.98118 | 37.7392370206652 | -122.37757481115 | (37.7392370206652, -122.37757481115) | 10 | 3 | 8 | 58 | 1 | |||
1270 | 140150 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 280 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5998837.1325 | 2109760.3619 | 37.7729323858329 | -122.447449052578 | (37.7729323858329, -122.447449052578) | 15 | 5 | 11 | 29492 | 16 | |||
1658 | 62209 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 16 | Permit Number 22331 | 5988338.57879 | 2114482.10714 | 37.7852914335725 | -122.484110690197 | (37.7852914335725, -122.484110690197) | 11 | 6 | 2 | 55 | 26 | |
1786 | 19661 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 60 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
2037 | 62579 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 741 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 10 | Permit Number 22784 | 6011303.77085 | 2104898.93824 | 37.7602885436105 | -122.403983043294 | (37.7602885436105, -122.403983043294) | 10 | 3 | 8 | 28856 | 29 | |
2309 | 11966 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1009X Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015728.77645 | 2096327.58352 | 37.736999624078 | -122.388080725796 | (37.736999624078, -122.388080725796) | 10 | 3 | 8 | 58 | 1 | |||
2447 | 19649 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 48 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
3167 | 199344 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1801 03rd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 4ft | 6015727.94816 | 2106771.64308 | 37.7656767749832 | -122.388812492998 | (37.7656767749832, -122.388812492998) | 14 | 3 | 9 | 310 | 29 | ||
4852 | 218789 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 380 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 5999445.61392 | 2094740.51345 | 37.7317263020196 | -122.444264703861 | (37.7317263020196, -122.444264703861) | 9 | 7 | 4 | 63 | 40 | ||||
4905 | 224435 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 599X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 5ft | 6007163 | 2097853 | 37.7407097800121 | -122.417804616035 | (37.7407097800121, -122.417804616035) | 2 | 7 | 7 | 28859 | 2 | |||
5068 | 4202 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 3902 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004480.6649 | 2100468.03712 | 37.7477387553393 | -122.427265346224 | (37.7477387553393, -122.427265346224) | 2 | 4 | 5 | 63 | 22 | |||
5193 | 19660 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 59 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60ST | |||||||||||||
5353 | 199364 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 300x Division St | 3 | Median : Cutout | Tree | DPW 1 | 28 | Width 6ft | 6009993.3485 | 2108173.38824 | 37.7692061355694 | -122.408746211675 | (37.7692061355694, -122.408746211675) | 8 | 4 | 8 | 28853 | 19 | |||
5369 | 38224 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1099 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1998 12:00:00 AM | 14 | Permit Number 40351 | 6014264.59569 | 2102044.43409 | 37.7526156672934 | -122.393543078061 | (37.7526156672934, -122.393543078061) | 10 | 3 | 8 | 28856 | 29 | |
5501 | 250103 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1634 Pine St | 2 | : | Tree | Private 2 | 2 | Width 4ft | 6006023.8446 | 2115600.71368 | 37.7893766304877 | -122.423004504073 | (37.7893766304877, -122.423004504073) | 13 | 9 | 1 | 28858 | 41 | |||
6089 | 19680 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 79 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
6125 | 19650 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 49 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
6394 | 19671 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 70 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
6529 | 19672 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 71 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
6739 | 102293 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 801 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016486.61621 | 2101147.40436 | 37.7502758246674 | -122.385796353939 | (37.7502758246674, -122.385796353939) | 10 | 3 | 8 | 58 | 1 | |||
6861 | 11269 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1176X Ingalls St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/1990 12:00:00 AM | 3 | 3x3 | 6017716.362196 | 2093961.1645628 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | 10 | 3 | 8 | 58 | 1 | ||
7136 | 62578 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 739 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 9 | Permit Number 22783 | 6011302.74241 | 2104925.74778 | 37.7603620991639 | -122.403988486898 | (37.7603620991639, -122.403988486898) | 10 | 3 | 8 | 28856 | 29 | |
7357 | 11962 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 945X Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6015820.0973 | 2096449.8462 | 37.7373403917231 | -122.38777351408 | (37.7373403917231, -122.38777351408) | 10 | 3 | 8 | 58 | 1 | |||
7423 | 260961 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1100x Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
7486 | 224010 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1000 San Jose Ave | 31 | Front Yard : Yard | Tree | Private 2 | 18 | 6005156.6976 | 2097181.32171 | 37.7387523922042 | -122.424693884126 | (37.7387523922042, -122.424693884126) | 2 | 7 | 5 | 28859 | 7 | ||||
7791 | 199356 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2151 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6011640.657 | 2104629.31608 | 37.759567037301 | -122.402798942823 | (37.759567037301, -122.402798942823) | 10 | 3 | 8 | 28856 | 29 | |||
8025 | 10826 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1139X Hudson Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/1990 12:00:00 AM | 12 | 3X4 | 6017834.53501 | 2094620.05501 | 37.732427530713 | -122.380681442077 | (37.732427530713, -122.380681442077) | 10 | 3 | 8 | 58 | 1 | ||
8066 | 141287 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1855 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 0ft | 6001856.4282 | 2112885.6951 | 37.7816858418255 | -122.437228784957 | (37.7816858418255, -122.437228784957) | 15 | 5 | 11 | 29490 | 41 | |||
8639 | 199392 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1199 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6018085.49835 | 2093997.29329 | 37.7307313955254 | -122.379770541 | (37.7307313955254, -122.379770541) | 10 | 3 | 8 | 58 | 1 | |||
8697 | 224438 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 401X Powhattan Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 6008219.66372 | 2098116.47311 | 37.7414926273921 | -122.414169698278 | (37.7414926273921, -122.414169698278) | 2 | 7 | 7 | 28859 | 2 | |||
8761 | 19674 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 73 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
9178 | 10645 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 906 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6003455.1435 | 2110726.9996 | 37.7758493511517 | -122.431543829861 | (37.7758493511517, -122.431543829861) | 15 | 9 | 11 | 29492 | 10 | |||
9297 | 139640 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1780 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6001669 | 2112367 | 37.7802509803634 | -122.437840034507 | (37.7802509803634, -122.437840034507) | 15 | 5 | 11 | 29490 | 41 | |||
9378 | 218791 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 138 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6001157.9301 | 2094692.71106 | 37.731692590922 | -122.438341469381 | (37.731692590922, -122.438341469381) | 9 | 7 | 4 | 63 | 40 | |||
9794 | 26872 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 969 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003239 | 2110629 | 37.7755680153799 | -122.432284524402 | (37.7755680153799, -122.432284524402) | 15 | 9 | 11 | 29492 | 10 | |||
10440 | 246120 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1285 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1979 12:00:00 AM | 17 | Width 0ft | Permit Number 17675 | 5999565 | 2108371 | 37.7691591171027 | -122.444831391499 | (37.7691591171027, -122.444831391499) | 15 | 5 | 11 | 29492 | 9 | |
11151 | 206269 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 576 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 6ft | 5994053.8446 | 2099403.66341 | 37.7442210643587 | -122.463243244477 | (37.7442210643587, -122.463243244477) | 1 | 8 | 4 | 29491 | 40 | |||
11257 | 199342 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1801 03rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 4ft | 6015732.89393 | 2106644.75831 | 37.7653286510121 | -122.388786527772 | (37.7653286510121, -122.388786527772) | 14 | 3 | 9 | 310 | 29 | ||
11451 | 19677 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 76 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
11564 | 141296 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1835 ELLIS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 6002071.6645 | 2112917.5067 | 37.7817854213105 | -122.436486447843 | (37.7817854213105, -122.436486447843) | 15 | 5 | 11 | 29490 | 41 | |||
11565 | 19675 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 74 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
11704 | 19657 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 56 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60ST | |||||||||||||
12418 | 4841 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 142 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x9 | Permit Number 784458 | 6006480.03392 | 2097559.50493 | 37.7398654498357 | -122.420145233727 | (37.7398654498357, -122.420145233727) | 2 | 7 | 7 | 28859 | 2 | ||
13883 | 11536 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018721.15121 | 2096997.58655 | 37.739004655647 | -122.377781119206 | (37.739004655647, -122.377781119206) | 10 | 3 | 8 | 58 | 1 | |||
13911 | 199353 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2201 20th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6011453.77249 | 2104619.23603 | 37.7595289231366 | -122.403444576915 | (37.7595289231366, -122.403444576915) | 10 | 3 | 8 | 28856 | 29 | |||
14154 | 19656 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 55 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60ST | |||||||||||||
14191 | 11527 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018609.30332 | 2096848.22468 | 37.7385883738483 | -122.378157476493 | (37.7385883738483, -122.378157476493) | 10 | 3 | 8 | 58 | 1 | |||
14243 | 19683 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 82 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
14650 | 199380 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 200 Jennings St | 18 | : | Tree | Private 2 | 15 | Width 3ft | 6018370.09073 | 2096624.46593 | 37.7379607900541 | -122.378969032793 | (37.7379607900541, -122.378969032793) | 10 | 3 | 8 | 58 | 1 | |||
15810 | 19653 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 52 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
16132 | 123506 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2630 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 8ft | 5995210.57552 | 2110304.28467 | 37.774217945514 | -122.460033072871 | (37.774217945514, -122.460033072871) | 11 | 6 | 2 | 54 | 11 | |||
17121 | 199343 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1801 03rd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 4ft | 6015732.25453 | 2106672.58002 | 37.7654050079639 | -122.388790681754 | (37.7654050079639, -122.388790681754) | 14 | 3 | 9 | 310 | 29 | ||
17175 | 105511 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 400X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 772834 | 6003196.1616 | 2109801.36502 | 37.7732931051579 | -122.432373588443 | (37.7732931051579, -122.432373588443) | 15 | 9 | 11 | 29492 | 9 | ||||
17206 | 121988 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 528 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5991288.02079 | 2111782.83574 | 37.7780512574537 | -122.473709641027 | (37.7780512574537, -122.473709641027) | 11 | 6 | 2 | 54 | 26 | |||
17360 | 5760 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 400 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3x3 | 6003950.51884 | 2108401.53413 | 37.7694922566853 | -122.42966430667 | (37.7694922566853, -122.42966430667) | 7 | 9 | 5 | 29492 | 10 | |||
17620 | 138647 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 600 PRESIDIO AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999215.4534 | 2114556.1413 | 37.7861219706649 | -122.446485488681 | (37.7861219706649, -122.446485488681) | 15 | 6 | 1 | 29490 | 31 | |||
17736 | 199387 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1335 Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6017568.18175 | 2094804.88271 | 37.7329203283169 | -122.381615146745 | (37.7329203283169, -122.381615146745) | 10 | 3 | 8 | 58 | 1 | |||
18030 | 260962 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1100x Vermont St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
18935 | 258611 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 982 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6003166 | 2110704 | 37.7757698073842 | -122.432542407207 | (37.7757698073842, -122.432542407207) | 15 | 9 | 11 | 29492 | 10 | ||||
19102 | 19678 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 STAIRWAY5 | 77 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
19346 | 199370 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 3550 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | Width 4ft | 6016015.91083 | 2099228.15232 | 37.7449798979207 | -122.387290235768 | (37.7449798979207, -122.387290235768) | 10 | 3 | 8 | 58 | 1 | |||
19505 | 116636 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2100 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6011793.53885 | 2104686.09338 | 37.7597314702416 | -122.402274190217 | (37.7597314702416, -122.402274190217) | 10 | 3 | 8 | 28856 | 29 | |||
19848 | 250104 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1634 Pine St | 1 | : | Tree | Private 2 | 2 | Width 4ft | 6006039.94152 | 2115602.86884 | 37.7893834563277 | -122.422948963731 | (37.7893834563277, -122.422948963731) | 13 | 9 | 1 | 28858 | 41 | |||
22390 | 107072 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 400X Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 50x5 | Permit Number 773144 | 6015855.63323 | 2106318.50292 | 37.7644396262057 | -122.388339224777 | (37.7644396262057, -122.388339224777) | 14 | 3 | 9 | 310 | 29 | |
22434 | 16120 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 303 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6000032.3049 | 2094633.40383 | 37.7314656586952 | -122.442228714304 | (37.7314656586952, -122.442228714304) | 9 | 7 | 4 | 63 | 40 | |||
22529 | 248372 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1609 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5997820.1302 | 2108164.6442 | 37.7684927847419 | -122.450851888359 | (37.7684927847419, -122.450851888359) | 15 | 5 | 11 | 29492 | 9 | |||
22721 | 199372 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2 Newhall St | 2 | : | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 15 | Width 3ft | Permit Number 774049 | 6018530.30847 | 2097200.55685 | 37.7395514542225 | -122.378455061265 | (37.7395514542225, -122.378455061265) | 10 | 3 | 8 | 58 | 1 | |
22823 | 224022 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1300 San Jose Ave | 21 | Front Yard : Yard | Tree | Private 2 | 25 | 6003540.82213 | 2095652.97051 | 37.7344644939234 | -122.4301718157 | (37.7344644939234, -122.4301718157) | 2 | 7 | 5 | 63 | 7 | ||||
22932 | 11963 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1009X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6015687.60896 | 2096283.05677 | 37.7368750817287 | -122.388219954896 | (37.7368750817287, -122.388219954896) | 10 | 3 | 8 | 58 | 1 | |||
23908 | 199351 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 875 Vermont St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 6011310.44581 | 2104289.70696 | 37.7586161031593 | -122.403917085224 | (37.7586161031593, -122.403917085224) | 10 | 3 | 8 | 28856 | 29 | ||||
24371 | 11231 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1050X Ingalls St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/1990 12:00:00 AM | 50 | 3X4 | 6018085.6618829 | 2094069.8743192 | 37.7309306978843 | -122.379775016493 | (37.7309306978843, -122.379775016493) | 10 | 3 | 8 | 58 | 1 | ||
24916 | 20126 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 999X Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6003226.6736 | 2110648.3783 | 37.7756205244718 | -122.432328548686 | (37.7756205244718, -122.432328548686) | 15 | 9 | 11 | 29492 | 10 | |||
25295 | 4834 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 108 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5x5 | 6006318.50135 | 2097642.91153 | 37.7400853628581 | -122.420709666225 | (37.7400853628581, -122.420709666225) | 2 | 7 | 7 | 28859 | 2 | |||
25556 | 1293 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 4000X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 50 | 10 | 5991961.87152 | 2087160.63909 | 37.7104840184951 | -122.469585692537 | (37.7104840184951, -122.469585692537) | 9 | 8 | 4 | 64 | 24 | |||
25790 | 11503 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | |||
26698 | 246073 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1209 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1979 12:00:00 AM | 18 | Width 0ft | Permit Number 17669 | 5999896.6292 | 2108453.3917 | 37.7694042640863 | -122.443690228142 | (37.7694042640863, -122.443690228142) | 15 | 5 | 11 | 29492 | 9 | |
26841 | 3665 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 101 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6017153.34624 | 2098900.71457 | 37.7441437469313 | -122.383334362693 | (37.7441437469313, -122.383334362693) | 10 | 3 | 8 | 58 | 1 | |||
26843 | 138649 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 3073 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5999235.7723 | 2114604.2128 | 37.7862551229755 | -122.44641865052 | (37.7862551229755, -122.44641865052) | 15 | 6 | 1 | 29490 | 31 | |||
27336 | 11531 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018661.76808 | 2096921.71466 | 37.7387930541475 | -122.377981176105 | (37.7387930541475, -122.377981176105) | 10 | 3 | 8 | 58 | 1 | |||
27715 | 206283 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 201 Elk St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 2ft | 6000785.48714 | 2095941.88052 | 37.7351013290572 | -122.439718600327 | (37.7351013290572, -122.439718600327) | 2 | 7 | 5 | 63 | 7 | |||
27772 | 11546 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018856.19666 | 2097185.73418 | 37.7395287121888 | -122.377327240377 | (37.7395287121888, -122.377327240377) | 10 | 3 | 8 | 58 | 1 | |||
28126 | 3696 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 401X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016376.57655 | 2099377.09307 | 37.7454088259626 | -122.386053488085 | (37.7454088259626, -122.386053488085) | 10 | 3 | 8 | 58 | 1 | |||
28326 | 138599 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2630 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 0ft | 6001313.0958 | 2114947.1478 | 37.7873151619105 | -122.439256256 | (37.7873151619105, -122.439256256) | 13 | 6 | 1 | 29490 | 27 | |||
28448 | 6329 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1895X Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | 15 | 5 | 11 | 29490 | 41 | |||
29472 | 11507 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100 Jennings St | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | 10 | 3 | 8 | 58 | 1 | |||
30908 | 224034 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 5210 Diamond Heights Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001015.66904 | 2099302.96494 | 37.7443431769966 | -122.439163600842 | (37.7443431769966, -122.439163600842) | 2 | 7 | 5 | 63 | 7 | |||
31430 | 3675 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 111 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016978.81066 | 2099030.12804 | 37.7444894427423 | -122.383946883753 | (37.7444894427423, -122.383946883753) | 10 | 3 | 8 | 58 | 1 | ||
31541 | 11327 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1223 Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/03/1993 12:00:00 AM | 40 | 3X3 | 6017540.6929483 | 2093936.3628532 | 37.7305340258377 | -122.381649801703 | (37.7305340258377, -122.381649801703) | 10 | 3 | 8 | 58 | 1 | ||
31591 | 121615 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1406 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6011976.5645 | 2101798.75104 | 37.7518136770635 | -122.401438271261 | (37.7518136770635, -122.401438271261) | 10 | 3 | 8 | 28856 | 29 | |||
31765 | 4430 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1195 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004484.1301445 | 2101944.4411304 | 37.7517928138361 | -122.427358521283 | (37.7517928138361, -122.427358521283) | 2 | 4 | 5 | 28862 | 22 | |||
31896 | 16029 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 146 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001109.44487 | 2094693.26414 | 37.7316913516547 | -122.43850913181 | (37.7316913516547, -122.43850913181) | 9 | 7 | 4 | 63 | 40 | |||
32043 | 224431 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 111 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6002252.13649 | 2096208.57853 | 37.7359169916712 | -122.434666937538 | (37.7359169916712, -122.434666937538) | 2 | 7 | 5 | 63 | 7 | |||
32069 | 25444 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2155 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6011824.01572 | 2087503.73336 | 37.7125540294141 | -122.400961526274 | (37.7125540294141, -122.400961526274) | 10 | 3 | 8 | 309 | 1 | |||
32403 | 17784 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1798X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005418.97388 | 2115516.65721 | 37.7891116821071 | -122.425091306216 | (37.7891116821071, -122.425091306216) | 13 | 9 | 1 | 28858 | 41 | |||
32447 | 176389 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 700x Mansell St | 16 | Median : Cutout | Tree | DPW 1 | 38 | Width 0ft | 6009439.98083 | 2090047.93275 | 37.719406601704 | -122.409380963965 | (37.719406601704, -122.409380963965) | 9 | 3 | 8 | 309 | 18 | |||
32920 | 10652 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 931 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003404.4622 | 2110674.9336 | 37.775703518104 | -122.431715431116 | (37.775703518104, -122.431715431116) | 15 | 9 | 11 | 29492 | 10 | |||
33248 | 17806 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1881 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6004903.5356 | 2115394.9801 | 37.7887484569995 | -122.426865989152 | (37.7887484569995, -122.426865989152) | 13 | 9 | 11 | 28858 | 27 | |||
33591 | 224025 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1193 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6004485.64517 | 2101988.85608 | 37.7519148526121 | -122.427356445766 | (37.7519148526121, -122.427356445766) | 2 | 4 | 5 | 28862 | 22 |
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) );